标题: 进行oracle数据库测试时,提示No suitable driver [打印本页] 作者: long_jianxiu 时间: 2010-3-29 16:21 标题: 进行oracle数据库测试时,提示No suitable driver 有把oracle的驱动放在lib文件夹下,测试计划中也指向了该目录,但运行的时候老提示找不到合适的驱动,我换了2个版本的驱动,提示的结果都一样,不知道这个是怎么个匹配的.
请多多指教
下面是日志信息:
2010/03/29 15:33:30 INFO - jmeter.gui.util.JMeterMenuBar: setRunning(true,*local*)
2010/03/29 15:33:30 INFO - jmeter.engine.StandardJMeterEngine: Starting 10 threads for group 线程组. Ramp up = 10.
2010/03/29 15:33:30 INFO - jmeter.engine.StandardJMeterEngine: Thread will continue on error
2010/03/29 15:33:30 INFO - jmeter.threads.JMeterThread: Thread started: 线程组 1-1
2010/03/29 15:33:30 WARN - jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(JdbcConnectionFactory.java:185)
at org.apache.avalon.excalibur.pool.ResourceLimitingPool.newPoolable(ResourceLimitingPool.java:672)
at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.newPoolable(ValidatedResourceLimitingPool.java:178)
at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcConnectionPool.newPoolable(ResourceLimitingJdbcConnectionPool.java:123)
at org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPool.java:402)
at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:130)
at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:270)
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:140)
at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:170)
at org.apache.jmeter.threads.JMeterThread.process_sampler(JMeterThread.java:346)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:243)
2010/03/29 15:33:59 WARN - jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.lang.Exception: Could not create enough Components to service your request (Timed out).
at org.apache.avalon.excalibur.pool.ResourceLimitingPool.get(ResourceLimitingPool.java:350)
at org.apache.avalon.excalibur.pool.ValidatedResourceLimitingPool.get(ValidatedResourceLimitingPool.java:130)
at org.apache.avalon.excalibur.datasource.ResourceLimitingJdbcDataSource.getConnection(ResourceLimitingJdbcDataSource.java:222)
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement$DataSourceComponentImpl.getConnection(DataSourceElement.java:270)
at org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:140)
at org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:170)
at org.apache.jmeter.threads.JMeterThread.process_sampler(JMeterThread.java:346)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:243)
at java.lang.Thread.run(Thread.java:595)作者: archonwang 时间: 2010-3-30 10:37
检查下你的Oracle版本呢，看是不是有合适的Oracle驱动对应到你的应用程序。作者: long_jianxiu 时间: 2010-4-1 09:54
这个问题已经解决了.现在成功了的测试,驱动是从oracle安装目录下拿的.然后没有设置pool的名字