Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of cwolf.algo@gmail.com
 designates 209.85.212.43 as permitted sender)
MIME-Version: 1.0
Date: Mon, 29 Apr 2013 16:18:44 -0400
Message-ID: 
 <CAK=acOK7OQ1nQXbsfDWO0b4ikihsH0TXV4YWYRxn7_r5TMoXUA@mail.gmail.com>
Subject: Getting "ORA-12519, TNS:no appropriate service handler
 found"...again. I don't think it's picking up DBCP pooling
From: Chris Wolf <cwolf.algo@gmail.com>
To: users@openjpa.apache.org
Content-Type: text/plain; charset=ISO-8859-1

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