Connection pooling trouble
Hi, Running 0.9.7 from March 7 (I think; someone else configured this). Running very short transactions (createEM, begin, find one instance, commit, close EM) I observe that connections are constantly being acquired and then closed (hundreds of times per second). Did I misconfigure the pool somehow? These settings are in the persistence.xml, providerorg.apache.openjpa.persistence.PersistenceProviderImpl/ provider ... property name=openjpa.ConnectionDriverName value=org.apache.derby.jdbc.ClientDriver/ property name=openjpa.ConnectionURL value=jdbc:derby://localhost:1527/pbdb;create=true;/ property name=openjpa.ConnectionUserName value=ejb3/ property name=openjpa.ConnectionPassword value=ejb3/ property name=openjpa.ConnectionRetainMode value=always/ property name=openjpa.ConnectionFactoryProperties value=MaxActive=200,MaxIdle=200,MaxCachedStatements=250/ Thanks, Craig Craig Russell DB PMC, OpenJPA PPMC [EMAIL PROTECTED] http://db.apache.org/jdo smime.p7s Description: S/MIME cryptographic signature
Re: connection pooling?
Roger- Which is true? The first statement ... the package documentation is in error (I've just fixed it). On Nov 2, 2006, at 5:00 PM, roger.keays wrote: From the 0.9.0 docs online, section 3.13 [1]: OpenJPA's built-in datasource does not perform connection pooling or prepared statement caching. From the 0.9.0 javadocs online [2]: Package org.apache.openjpa.lib.jdbc Description Includes an implementation of the DataSource APIs around a normal JDBC 1.x driver. Implements connection pooling and prepared statement caching. Which is true? Thanks, Roger [1] http://incubator.apache.org/openjpa/docs/openjpa-0.9.0-incubating/ manual/manual.html#ref_guide_optimization [2] http://incubator.apache.org/openjpa/openjpa-javadocs/openjpa-lib- apidocs/org/apache/openjpa/lib/jdbc/package-summary.html -- View this message in context: http://www.nabble.com/connection- pooling--tf2565072.html#a7149730 Sent from the open-jpa-dev mailing list archive at Nabble.com.
RE: connection pooling?
The former. -- Patrick Linskey BEA Systems, Inc. ___ Notice: This email message, together with any attachments, may contain information of BEA Systems, Inc., its subsidiaries and affiliated entities, that may be confidential, proprietary, copyrighted and/or legally privileged, and is intended solely for the use of the individual or entity named in this message. If you are not the intended recipient, and have received this message in error, please immediately return this by email and then delete it. -Original Message- From: roger.keays [mailto:[EMAIL PROTECTED] Sent: Thursday, November 02, 2006 5:01 PM To: open-jpa-dev@incubator.apache.org Subject: connection pooling? From the 0.9.0 docs online, section 3.13 [1]: OpenJPA's built-in datasource does not perform connection pooling or prepared statement caching. From the 0.9.0 javadocs online [2]: Package org.apache.openjpa.lib.jdbc Description Includes an implementation of the DataSource APIs around a normal JDBC 1.x driver. Implements connection pooling and prepared statement caching. Which is true? Thanks, Roger [1] http://incubator.apache.org/openjpa/docs/openjpa-0.9.0-incubat ing/manual/manual.html#ref_guide_optimization [2] http://incubator.apache.org/openjpa/openjpa-javadocs/openjpa-l ib-apidocs/org/apache/openjpa/lib/jdbc/package-summary.html -- View this message in context: http://www.nabble.com/connection-pooling--tf2565072.html#a7149730 Sent from the open-jpa-dev mailing list archive at Nabble.com.