On 19/11/2008, Parvathaneni, Sireesha <[EMAIL PROTECTED]> wrote: > Hi > > I was trying to run Jmeter DB tests remotely for postgreSQl db and i had put > the jdbc-pgsql driver .jar file under /jmeterserver/lib but still seeing > below messages > > driver iusing to connect to PostGreSQL DB : postgresql-8.3-603.jdbc4.jar > > starting remotely : Start -> Remote Start -> Remote Server > > 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:267) > at > org.apache.jmeter.protocol.jdbc.config.DataSourceElement.getConnection(DataSourceElement.java:137) > at > org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler.sample(JDBCSampler.java:155) > at > org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:290) > at java.lang.Thread.run(Thread.java:595) > > Help me, let me know if need to do anything more.Thanks in advance!
Does it work if you use JMeter in GUI mode (i.e. not Client-Server)? Try running that on the server node if you can. Are you sure that the jdbc jar is in the correct directory on the server? The correct directory will contain several other jars, e.g. commons-logging, jorphan etc. Are you sure the correct classname is used, and is present in the jar? > Rgrds, > Siri > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
