A week ago, I dropped this message related to a failing JDBC request. I would
appreciate some feedback in order to clarify the use of JDBC requests : are
there any specific rules that apply only to JDBC requests ?. The same query
runs successfully in a HTTP request and the exception seems to contain some
failing jmeter classes. Am I wrong ?.
Hello,
I made a very simple test scenario consisting of a single JDBC Request :
SELECT col1, col2, col3 FROM mytable. I start it in an endless loop using a
connection pool. Default URL and driver details are given in a JDBC config
element.
Here are the versions I use :
Linux SuSE 8.1
MySQL 4.0.13
JMeter 1.8.1
MySQL connector 3.0.8
This is what I systematically receive after a few thousands iterations :
07/28/2003 3:12:27 PM WARN - jmeter.protocol.jdbc: DBConnectionManager: Lost
a connection connection='[EMAIL PROTECTED]
07/28/2003 3:12:27 PM ERROR - jmeter.protocol.jdbc: Error in JDBC sampling
java.lang.IllegalThreadStateException
at java.lang.Thread.start(Native Method)
at
org.apache.jmeter.protocol.jdbc.util.ConnectionObject.release(ConnectionObjec
t.java:282)
at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.releaseConnection(DB
ConnectionManager.java:229)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:1
91)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:141)
at java.lang.Thread.run(Thread.java:534)
The same DB logic has been wrapped in a JSP. Using Tomcat 4.1.24 and an HTTP
request instead, my simple test runs successfully.
Your help and suggestions are very welcome.
Thanks,
Serge
-------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
-------------------------------------------------------
--
Serge van Thiel
Ph.:+32 2 3752277
Mob.:+32 477 414543
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
