On 19/11/2008, sebb <[EMAIL PROTECTED]> wrote: > On 19/11/2008, Parvathaneni, Sireesha <[EMAIL PROTECTED]> wrote: > > > > > > On Wed, Nov 19, 2008 at 1:49 PM, sebb <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > > 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. > > > > > > Yes, its working on client machine but not running through server. > Getting > > above messages while running on server. > > > Are there any other errors logged by the DataSourceElement? > > JDBC works fine for me in client-server mode, but when the classname > is missing I get an extra error message. >
It turns out that the JDBC jar had been added correctly to the lib directory, but the server had not been restarted, so it did not update its classpath. > > > > > > > > > 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. > > > > > > it is under /lib/ on jmeterserver , hope this is the right place as > > found the above mentioned jars(commons-logging, jorphan etc) in the same > > place. > > > > > > > > > Are you sure the correct classname is used, and is present in the jar? > > > > > > The clasname in JDBC config is :org.postgresql.Driver which is located > in > > jar file : under org.postgresql.Driver.class > > > > > > > > > > Rgrds, > > > > Siri > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
