I am using the j2sdk1.4.2_03 on windows with jmeter 2.0.3 and the oracle
driver ojdbc14.jar
The oracle driver is working normally for other java applications that
i'm running
i got the following error displayed in the listener "View Results Tree"
which is listening to the jdbc request sample shown below:
Load time: 0
HTTP response code: null
HTTP response message:
org.apache.jmeter.protocol.jdbc.util.ConnectionPoolException: Error
instantiating JDBC connection pool class
'org.apache.jmeter.protocol.jdbc.util.JMeter19ConnectionPool':
java.lang.reflect.InvocationTargetException
HTTP response headers:
this is my jdbc request:
Name: JDBC Request
JDBC URL: jdbc:oracle:thin:@db-rdtdb:1521:rdtdb
driver class: oracle.jdbc.driver.OracleDriver
username: xxx
password: xxx
number of connections in pool: 1
max usage for each connection: 50
the sql querystring is valid for my database:
select * from dealer_fix_request order by request_id desc
this is my log:
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine: About to
call test listeners
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listener:
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listener: org.apache.jmeter.reporters.ResultCollector
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listener: org.apache.jmeter.reporters.ResultCollector
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listener: org.apache.jmeter.gui.MainFrame
2005/07/21 15:42:40 INFO - jmeter.gui.util.JMeterMenuBar:
setRunning(true,local)
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine: Starting
1 threads for group JDBC. Ramp up = 1.
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine: Continue
on error
2005/07/21 15:42:40 INFO - jmeter.threads.JMeterThread: Thread JDBC 1-1
started
2005/07/21 15:42:40 ERROR -
jmeter.protocol.jdbc.util.DBConnectionManager: Error instantiating JDBC
connection pool class
'org.apache.jmeter.protocol.jdbc.util.JMeter19ConnectionPool'
java.lang.reflect.InvocationTargetException:
java.lang.NoClassDefFoundError: java/sql/Savepoint
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:
521)
at
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at
org.apache.jmeter.protocol.jdbc.util.JMeter19ConnectionPool.validateMaxC
onnections(JMeter19ConnectionPool.java:88)
at
org.apache.jmeter.protocol.jdbc.util.JMeter19ConnectionPool.<init>(JMete
r19ConnectionPool.java:64)
at java.lang.reflect.Constructor.newInstance(Native Method)
at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.createConnectio
nPool(DBConnectionManager.java:132)
at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.getKey(DBConnec
tionManager.java:104)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.getKey(JDBCSampler.j
ava:185)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.j
ava:102)
at
org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:281)
at java.lang.Thread.run(Unknown Source)
2005/07/21 15:42:40 ERROR - jmeter.protocol.jdbc.sampler.JDBCSampler:
Error in JDBC sampling
org.apache.jmeter.protocol.jdbc.util.ConnectionPoolException: Error
instantiating JDBC connection pool class
'org.apache.jmeter.protocol.jdbc.util.JMeter19ConnectionPool':
java.lang.reflect.InvocationTargetException
at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.createConnectio
nPool(DBConnectionManager.java:141)
at
org.apache.jmeter.protocol.jdbc.util.DBConnectionManager.getKey(DBConnec
tionManager.java:104)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.getKey(JDBCSampler.j
ava:185)
at
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.j
ava:102)
at
org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:281)
at java.lang.Thread.run(Unknown Source)
2005/07/21 15:42:40 INFO - jmeter.threads.JMeterThread: Thread JDBC 1-1
is done
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying listeners of end of test
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listener:
org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listener: org.apache.jmeter.reporters.ResultCollector
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listener: org.apache.jmeter.reporters.ResultCollector
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine:
Notifying test listener: org.apache.jmeter.gui.MainFrame
2005/07/21 15:42:40 INFO - jmeter.gui.util.JMeterMenuBar:
setRunning(false,local)
2005/07/21 15:42:40 INFO - jmeter.engine.StandardJMeterEngine: Test has
ended
i find this line interresting:
java.lang.reflect.InvocationTargetException:
java.lang.NoClassDefFoundError: java/sql/Savepoint
i found the class java/sql/Savepoint is in my JDK, so this should not be
possible.
i replaced my oracle driver with a third party driver and the problem is
still the same.
maybe this is also interesting:
i tried a wrong password and got:
Load time 15 with the same error message instead of Load Time 0
thank you for any help.
__________________________________________
Correspondence with tele.ring Telekom Service GmbH via e-mail is only for
information purposes, unless otherwise expressly stipulated. tele.ring
emphasizes that legally binding declarations of tele.ring may be issued only by
authorized persons in accordance with their signing power. No one can rely upon
a conclusion of an agreement until it bears a written legally binding signature
of tele.ring.
This message is intended for the individual named above and is confidential and
may also be privileged. If you are not the intended recipient, please do not
read, copy, use or disclose this communication to others. Also please notify
the sender by replying to this message and then delete it from your system
permanently.
We also would like to draw your attention to the fact that transmissions via
the Internet per E-mail can be lost, changed or falsified, with or without any
interference by third persons.
