jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: JDBC Request Error
Date Thu, 21 Jul 2005 14:46:04 GMT
On 21/07/05, Rainer David <David.Rainer@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


Mime
View raw message