I use EJB3 to connect to Postgres 8.1. At random times, I get a database connection
error:
| No ManagedConnections available within configured blocking timeout ( 30000 [ms] ); -
nested throwable: (javax.resource.ResourceException: No ManagedConnections available
within configured blocking timeout ( 30000 [ms] ))
|
From what I have read, this means that the database connection pool is
messing up some how. In my datasource definition, I have included:
| <local-tx-datasource>
| <jndi-name>MyDS</jndi-name>
| <connection-url>jdbc:postgresql://cherry/pgacms</connection-url>
| <driver-class>org.postgresql.Driver</driver-class>
| <user-name>...</user-name>
| <password>...</password>
| <min-pool-size>5</min-pool-size>
| <max-pool-size>30</max-pool-size>
| <new-connection-sql>SELECT version()</new-connection-sql>
| <check-valid-connection-sql>SELECT version()</check-valid-connection-sql>
|
| </local-tx-datasource>
|
I have checked, and the max number of connections defined for all my datasources is less
than the maximum connections that Postgres allows. From what I have read about this error,
most people say that the database connection is not being closed correctly in the java
code.
So my question, since I am using EJB3 for my database connection, do I have to do anything
to explicitly close the connection?
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4035323#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...