jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sebb <seb...@gmail.com>
Subject Re: jmeter.protocol.jdbc.config.DataSourceElement: Could not return Connection java.sql.SQLException: No suitable driver
Date Sat, 22 Nov 2008 16:05:37 GMT
On 19/11/2008, sebb <sebbaz@gmail.com> wrote:
> On 19/11/2008, Parvathaneni, Sireesha <sireesha.parvathaneni@gmail.com> wrote:
>   >
>   >
>   > On Wed, Nov 19, 2008 at 1:49 PM, sebb <sebbaz@gmail.com> wrote:
>   >
>   >
>   > >
>   > >
>   > >
>   > > On 19/11/2008, Parvathaneni, Sireesha
>   > <sireesha.parvathaneni@gmail.com> 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:
>   > jmeter-user-unsubscribe@jakarta.apache.org
>   > > For additional commands, e-mail:
>   > jmeter-user-help@jakarta.apache.org
>   > >
>   > >
>   >
>   >
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org


Mime
View raw message