You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Rainer David <Da...@telering.co.at> on 2005/07/21 16:10:06 UTC
JDBC Request Error
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.
Re: JDBC Request Error
Posted by sebb <se...@gmail.com>.
On 21/07/05, Rainer David <Da...@telering.co.at> wrote:
> 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
Is it possible that the JDBC driver you are using does not support SavePoints?
> 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.
>
>
>
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: JDBC Request Error
Posted by Peter Lin <wo...@gmail.com>.
my first guess is the driver name is wrong. I haven't used
ojdbc14.jar, but the older drivers were different. are you using
oracle 10g?
peter
On 7/21/05, Rainer David <Da...@telering.co.at> wrote:
> 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.
>
>
>
>
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org