A back in January, I kept getting ORA-12519, and I tried all the
suggestions on the web,
e.g.
alter system set processes = 300 scope = spfile;
alter system set sessions = 335 scope = spfile;
alter system set transactions = 369 scope = spfile;
All to no avail.
Looking in /app/<user>/diag/tnslsnr/<user>/listener/trace/listener.log
confirms hundreds of connections being opened by OpenJPA before it
gets hit with ORA-12519, which I assume is a side-effect of running
out of connections.
I then dropped in the commons-dbcp-1.4.jar jar to enable connection
pooling and the issue went away.
Today, I am seeing it again, and although the stack trace seems to
suggest that connection pooling
is not happening... could someone confirm? Also I thought it was
sufficient to merely have
commons-dbcp-1.4.jar on the classpath to enable pooling - is there a
config adjustment required
also? (That I may have forgotten about since January)?
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:218)
at
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:29)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
at
org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getSimpleConnection(SimpleDriverDataSource.java:84)
at
org.apache.openjpa.jdbc.schema.AutoDriverDataSource.getConnection(AutoDriverDataSource.java:39)
at
org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(SimpleDriverDataSource.java:76)
at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:118)
at
org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(DecoratingDataSource.java:93)
at
org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(DelegatingDataSource.java:118)
at
org.apache.openjpa.jdbc.schema.DataSourceFactory$DefaultsDataSource.getConnection(DataSourceFactory.java:304)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connectInternal(JDBCStoreManager.java:982)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(JDBCStoreManager.java:967)
Thanks,
Chris
