Hi, I'm trying to use JMeter in order to test our database (SAP-DB).
1. I have built a simple test plan : connection to the DB and simple SELECT
statement. (see attached file "SAPDB Ess 1-noPasswd.jmx")
2. I start JMeter :
...
C:\Program Files\JMeter\bin>set LOCALCLASSPATH=
C:\Program Files\JMeter\bin>for %i in ("..\lib\*.jar") do CALL ..\lcp.bat %i
C:\Program Files\JMeter\bin>CALL ..\lcp.bat ..\lib\ant-1.4.1.jar
org.apache.jmeter.protocol.jdbc.config.DbConfig@61373f
org.apache.jmeter.protocol.jdbc.config.PoolConfig@c297a3
org.apache.jmeter.protocol.jdbc.config.SqlConfig@3e1bc8
3. If I then first start the test, JMeter connects effectively to the DB
instance. (appears in SAP-DB DBManager), but no result appear.
4. If I stop the test, the following exception occurs:
java.lang.NullPointerException
at
com.sap.dbtech.jdbc.ConnectionSapDB.getRequestPacket(ConnectionSapDB.java:42
0)
at com.sap.dbtech.jdbc.FetchInfo.close(FetchInfo.java:259)
at com.sap.dbtech.jdbc.ResultSetSapDB.close(ResultSetSapDB.java:212)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:
151)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:138)
at java.lang.Thread.run(Thread.java:536)
5. And if I try to start it again, it does not connect to the DB anymore,
and throws each time the same exception:
java.lang.NullPointerException
at java.util.Hashtable.get(Hashtable.java:326)
at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.releaseConnection(D
BConnectionManager.java:211)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:
169)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:138)
at java.lang.Thread.run(Thread.java:536)
So my questions are:
+ did I do somethimg wrong?
+ is there a problem on JMeter side (I didn't find anything in the bugs)?
+ or on our JDBC driver?
Thank you for your help, and mind to have a look at our site
(www.sapdb.org), SAP-DB is open source under GPL.
Mathieu Baudier
SAP Labs Berlin - SAP DB
[EMAIL PROTECTED]
www.sapdb.org
SAPDB Ess 1-noPasswd.jmx
Description: Binary data
C:\Program Files\JMeter\bin>set LOCALCLASSPATH=
C:\Program Files\JMeter\bin>for %i in ("..\lib\*.jar") do CALL ..\lcp.bat %i
C:\Program Files\JMeter\bin>CALL ..\lcp.bat ..\lib\ant-1.4.1.jar
org.apache.jmeter.protocol.jdbc.config.DbConfig@61373f
org.apache.jmeter.protocol.jdbc.config.PoolConfig@c297a3
org.apache.jmeter.protocol.jdbc.config.SqlConfig@3e1bc8
java.lang.NullPointerException
at
com.sap.dbtech.jdbc.ConnectionSapDB.getRequestPacket(ConnectionSapDB.java:420)
at com.sap.dbtech.jdbc.FetchInfo.close(FetchInfo.java:259)
at com.sap.dbtech.jdbc.ResultSetSapDB.close(ResultSetSapDB.java:212)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:151)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:138)
at java.lang.Thread.run(Thread.java:536)
java.lang.NullPointerException
at java.util.Hashtable.get(Hashtable.java:326)
at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.releaseConnection(DBConnectionManager.java:211)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:169)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:138)
at java.lang.Thread.run(Thread.java:536)
java.lang.NullPointerException
at java.util.Hashtable.get(Hashtable.java:326)
at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.releaseConnection(DBConnectionManager.java:211)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:169)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:138)
at java.lang.Thread.run(Thread.java:536)
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
