users@glassfish.java.net

Re: Problem allocating db connection - max connections in use

From: <glassfish_at_javadesktop.org>
Date: Fri, 05 Dec 2008 04:35:26 PST

This is what is being used to setup the pool:

  [i]<jdbc-connection-pool allow-non-component-callers="false" connection-validation-method="auto-commit" datasource-classname="org.apache.derby.jdbc.ClientDataSource" fail-all-connections="false" idle-timeout-in-seconds="300" is-connection-validation-required="false" is-isolation-level-guaranteed="true" max-pool-size="32" max-wait-time-in-millis="60000" name="csemDatabasePool" non-transactional-connections="false" pool-resize-quantity="2" res-type="javax.sql.DataSource" steady-pool-size="8">
    <property name="serverName" value="localhost"/>
    <property name="PortNumber" value="1527"/>
    <property name="DatabaseName" value="csemdb"/>
    <property name="User" value="csem"/>
    <property name="Password" value="csem"/>
  </jdbc-connection-pool>

  <jdbc-resource enabled="true" jndi-name="jdbc/csemdb" object-type="user" pool-name="csemDatabasePool"/>[/i]

The stack callback indicates that the error occur when one of my MDB's tries to get a database connection for a JPA query. Again, all database access is done through CMT JPA access so I am pretty sure that my code does not have a connection leak.
[Message sent by forum member 'bbergquist' (bbergquist)]

http://forums.java.net/jive/thread.jspa?messageID=320272