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 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]
>
>
