openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Wolf <>
Subject Getting "ORA-12519, TNS:no appropriate service handler found"...again. I don't think it's picking up DBCP pooling
Date Mon, 29 Apr 2013 20:18:44 GMT
A back in January, I kept getting ORA-12519, and I tried all the
suggestions on the web,

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>(
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(
	at oracle.jdbc.driver.OracleDriver.connect(
	at org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getSimpleConnection(
	at org.apache.openjpa.jdbc.schema.AutoDriverDataSource.getConnection(
	at org.apache.openjpa.jdbc.schema.SimpleDriverDataSource.getConnection(
	at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(
	at org.apache.openjpa.lib.jdbc.DecoratingDataSource.getConnection(
	at org.apache.openjpa.lib.jdbc.DelegatingDataSource.getConnection(
	at org.apache.openjpa.jdbc.schema.DataSourceFactory$DefaultsDataSource.getConnection(
	at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connectInternal(
	at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.connect(



View raw message