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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
