Berin Thanks for your comments. I would like to check the source for Excalibur Pool 1.2 and see how it is handling errors from the driver, in case that is where the fault lies. Is it possible to download that version's source? I have found the binary of it on one of the FTP mirror sites, and the source for later versions, but not that one.
Simon -----Original Message----- From: Berin Loritsch [mailto:[EMAIL PROTECTED] Sent: 22 February 2008 16:22 To: Excalibur Users List; [EMAIL PROTECTED] Subject: Re: problem with closing database connections using Excalibur Pool 1.2 The Oracle driver is notorious about dealing with open resources. If you forget to close one resultset, statement, etc. then not only will the connection not close, but you'll get an exception regarding too many cursors or something like that. Make sure you are closing all those resources inside a finally block, because one exception will throw things off otherwise. That's my best guess after not being in the code for years. Simon Payne wrote: > Hello, > > I am using JMeter to load test an Oracle database. I have been having > trouble with JDBC connect strings and TNSNAMES entries. The code within > JMeter that handles connect strings (i.e. db urls) is Excalibur Pool v. 1.2, > hence I am addressing this forum. > > The problem appears on closure of the connection - opening connections works > fine. How does Excalibur Pool work in this respect? > > Why would I be getting an error like the one below? Has anyone else seen and > resolved it? > > Here is my environment:- > > Excalibur Pool v. 1.2 > JMeter v. 2.3 > Database: Oracle 10g3 (10.2.0.3.0) > JDBC driver: Oracle ojdbc14.jar v. 10.2.0.3.0 > Client JVM: J2RE, Standard Edition (build 1.5.0_06-b05) Java HotSpot(TM) > Client VM (build 1.5.0_06-b05, mixed mode). > Platform: Client: Windows XP Pro 2002 SP2; Server: Suse Enterprise Linux v. > 10. > > The exception I am getting is: > > 2008/02/22 14:59:31 WARN - jmeter.protocol.jdbc.config.DataSourceElement: > Could not close connection java.sql.SQLException: Protocol violation > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145) > at > oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:207) > at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:149) > at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:464) > at > oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1202) > at > org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.dispose(Abstra > ctJdbcConnection.java:317) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39 > ) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl > .java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at > org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.invoke(Abstrac > tJdbcConnection.java:357) > at $Proxy0.dispose(Unknown Source) > at > org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.decommission(Jd > bcConnectionFactory.java:248) > at > org.apache.avalon.excalibur.pool.ResourceLimitingPool.removePoolable(Resourc > eLimitingPool.java:697) > at > org.apache.avalon.excalibur.pool.ResourceLimitingPool.permanentlyRemovePoola > ble(ResourceLimitingPool.java:639) > at > org.apache.avalon.excalibur.pool.ResourceLimitingPool.dispose(ResourceLimiti > ngPool.java:518) > at > org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.dispos > e(ResourceLimitingJdbcDataSource.java:442) > at > org.apache.jmeter.protocol.jdbc.config.DataSourceElement.testEnded(DataSourc > eElement.java:75) > at > org.apache.jmeter.engine.StandardJMeterEngine.notifyTestListenersOfEnd(Stand > ardJMeterEngine.java:246) > at > org.apache.jmeter.engine.StandardJMeterEngine$StopTest.run(StandardJMeterEng > ine.java:321) > at java.lang.Thread.run(Thread.java:595) > > Here is how we've discussed it so far, on the JMeter user forum:- > > http://mail-archives.apache.org/mod_mbox/jakarta-jmeter-user/200802.mbox/aja > x/[EMAIL PROTECTED] > (cut and paste link into a browser). > > Thanks in anticipation of your help. > > Regards, > > Simon Payne > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
