jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From serge van Thiel <>
Subject Repetitive loss of connection with JDBC request and MySQL
Date Tue, 29 Jul 2003 09:09:51 GMT

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 
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='com.mysql.jdbc.jdbc2.Connection@a5d3d5
07/28/2003 3:12:27 PM ERROR - jmeter.protocol.jdbc: Error in JDBC sampling
        at java.lang.Thread.start(Native Method)
org.apache.jmeter.protocol.jdbc.util.ConnectionObject.release(ConnectionObjec at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.releaseConnection(DB at
91) at at

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.



To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message