Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. It was working fine since last few month. But suddenly client got an error. Anyone can give the correct reason of this issue and which solution will be best to resolve the issue, so that in future we will not get this again. Update : I have two separate application that deal with same db.
One is a service that create pending items to be process and saving in DB and client is pick the pending item from db and process it. Workaround 1: If not, then move them into the same network segment to eliminate router related issue. Workaround 2: If already same network, or no router issue, then install both DB and application into the same machine to eliminate network related issue. Info 3: Pay attention to the DB connection idle time from last use.
The pattern of this behavior could be due to the idle time when it is across 2 different network segment. Info 2: Run sqlplus from the application server machine to the remote Oracle DB. Keep the connection open and idle after login for hours. Simply run any command after let it sit from idle, e. If yes, then talk with DBA and network admin whether they setup a "policy" in either Oracle or network equipment to forcefully close idle connections.
Info 3: Does the application has connection pool manager? If yes, then tune its parameter so that it keeps near 0 idle connections. Progressively increase it to see at what threshold the problem will be visible. Is there a virtual hostname that point to different server when application is actively talking to the prior server? In tnsnames. Thanks for any insight. Posted: Mon May 02, am. Use a connection pool like c3p0. It will handle the reset connection recovery for you.
All rights reserved. FAQ Search. Page 1 of 1. Previous topic Next topic. According to the hibernate manul chapter 3: "C3P0 is an open source JDBC connection pool distributed along with Hibernate in the lib directory. Hibernate will use the built-in C3P0ConnectionProvider for connection pooling if you set the hibernate. If so, is it hibernate. Therefore, it does not seem to me that I need to define hibernate. DriverManagerConnectionProvider hibernate. DatasourceConnectionProvider hibernate.
C3P0ConnectionProvider hibernate. Posted: Wed Sep 29, pm. I establish a connection using standard JNDI and a connection provider class My hibernate. Connection; import java. SQLException; import java. Properties; import javax. InitialContext; import javax. NamingException; import javax.
0コメント