Caused by: javax.ejb.EJBException: null; CausedByException is:
ISISDatabaseConnection: Unable to create connection to ISIS Database.
at com.ingenta.content.BrowseUtilities.getConnection(BrowseUtilities.java:214)
at com.ingenta.content.ejb.BrowseControllerBean.getIssue(BrowseControllerBean.java:542)
-- xxxxxxxxxxxxxxxxxxxxxxxx Scott Stark Chief Technology Officer JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxx
Andrew May wrote:
Our production application has on several times run out of connections from a pool and we've had to restart the server to reset the pool.
We have a pool of 100 Oracle connections used for BMP entity beans and calls to the database from Session beans via Data Access Objects:
<local-tx-datasource>
<jndi-name>jdbc.oraclePool</jndi-name>
<connection-url>jdbc:oracle:thin:@machine:1521:schema</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>username</user-name>
<password>password</password>
<min-pool-size>10</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>
We're typically only using between 0 to 20 connections in use at any given time (I'm using EJTools Swing JMX browser to graph the ConnectionCount and AvailableConnectionCount at 10 second intervals), although I suspect there are peaks > 30 at times.
------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here: http://www.vmware.com/wl/offer/345/0 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
