openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Wolf <cwolf.a...@gmail.com>
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,
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

Mime
View raw message