2013年9月16日星期一

About jdbc connect to the database error : Couldn't get connection because we are at maximum connection. . .

The entire contents of error : nested exception is java.sql.SQLException: Couldn't get connection because we are at maximum connection count (30/30) and ; there are none available

my side of the client-side code that is also the server , the client is mainly connected by our own database , find out from other database data synchronization into our own database.
from another database server after establishing a connection that queries other data in the database .
Now the client above error will be reported regularly , and generally working hours during the day when this error.
database connectivity through proxool document says :

000

jdbc: oracle: thin: @ 134.64.111.111:1522: XXXX

oracle.jdbc.driver.OracleDriver




900000
20
8
select CURRENT_DATE from DUAL
true


The above error is more than the maximum number of connections 30 , however , there is no definition 30 this figure has not to be found where the problem , find the Great God enlighten
------ Solution ----- ---------------------------------------
is beyond your set maximum database number of connections
1, increase the book database set maximum number of connections
2, check the code , the release of a long temporary database connection.
------ For reference only -------------------------------------- -
1, increase the database connection: refers to the increase proxool this file database connection it ? The number of connections used to be 10 , then I added 10 .
2, this problem only appears in this one I connect to the database , this code will connect to many other databases , they did not report this kind of error it .
------ For reference only -------------------------------------- -
not set proxool, is to set your installed database ( that is, your problem is that the database ) the maximum number of connections.
------ For reference only -------------------------------------- -
Will fix the problem ? Seeking advice , also encountered this problem .
------ For reference only -------------------------------------- -
paste the Lord, fix the problem ? ? ?

没有评论:

发表评论