Hi,
thank you for the quick answer!
I made the modification, and it's now running the FIRST test. But if I stop,
it cannot launch another one:
Error after stop:
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:
170)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:138)
at java.lang.Thread.run(Thread.java:536)
Error after new start (the same actually):
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:
170)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:138)
at java.lang.Thread.run(Thread.java:536)
I tried a few other modifications (testing if con!=null before calling
releaseConnection(), or at the beginning of this method in order to avoid
rentedConnections.get(c) with c==null) but it did not work (pb with Data
header).
Please let me know when (how) you fix it, because I plan to use JMeter
intensively during next weeks in order to test SAP-DB.
It's already great that it works. Thanks again,
Mathieu
-----Original Message-----
From: Stover, Michael [mailto:[EMAIL PROTECTED]]
Sent: Freitag, 22. M�rz 2002 14:34
To: 'JMeter Users List'; Baudier, Mathieu
Subject: RE: Problems with JDBC test - Release connection
This is a real bug, unfortunately. You might try the following to fix it:
go into the file JDBCSampler.java (in the
src/org/apache/jmeter/protocol/jdbc/sampler directory)
Find the following section:
=============================================
public class JDBCSampler implements Sampler
{
//database connection pool manager
DBConnectionManager manager = DBConnectionManager.getManager();
// end method
public final static String QUERY = "JDBCSampler.query";
private static Map keyMap = new HashMap();
==============================================
Remove the word "static" from the last line above (make it "private Map
keyMap = new HashMap();" )
Rebuild JMeter - type "build install" on command line in jmeter's top level
directory.
Let me know if that fixes your problem.
It won't make the exceptions go away when you stop a test (they aren't
important), but you should be able to start a new one without problems.
-Mike
> -----Original Message-----
> From: Baudier, Mathieu [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 22, 2002 5:34 AM
> To: JMeter mailing list (E-mail)
> Subject: Problems with JDBC test - Release connection
>
>
> 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(Connectio
> nSapDB.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(JDB
> CSampler.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.relea
> seConnection(D
> BConnectionManager.java:211)
> at
> org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDB
> CSampler.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
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
