jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sankar Das <007bhabanisan...@gmail.com>
Subject Re: Not able to test jdbc request from Jmeter
Date Fri, 02 Sep 2016 10:15:27 GMT
Thanks. After removing the semicolon and removing some spaces from
validation query for 2.13 it started working.

But same query is not working for jmeter version 3.0.

Getting error

Cannot create PoolableConnectionFactory (ORA-00923: FROM keyword not found
where expected
)

On Thu, Sep 1, 2016 at 10:10 PM, Jacob Zwiers <
Jacob.Zwiers@tpsgc-pwgsc.gc.ca> wrote:

> What happens when you remove it (and adjust validation query as per other
> poster's suggestion)?
>
> -----Original Message-----
> From: Sankar Das [mailto:007bhabanisankar@gmail.com]
> Sent: September-01-16 3:06 PM
> To: JMeter Users List <user@jmeter.apache.org>
> Subject: Re: Not able to test jdbc request from Jmeter
>
> with semicolon @ end.
>
> On Thu, Sep 1, 2016 at 9:51 PM, Jacob Zwiers <Jacob.Zwiers@tpsgc-pwgsc.gc.
> ca
> > wrote:
>
> > With or without the semicolon @ the end?
> >
> > -----Original Message-----
> > From: Sankar Das [mailto:007bhabanisankar@gmail.com]
> > Sent: September-01-16 2:46 PM
> > To: JMeter Users List <user@jmeter.apache.org>
> > Subject: Re: Not able to test jdbc request from Jmeter
> >
> > It was a simple select statement.
> >
> > select * from table name;
> >
> > The same query is running fine in sql devloper.
> >
> >
> > On Thu, Sep 1, 2016 at 8:53 PM, Jacob Zwiers
> <Jacob.Zwiers@tpsgc-pwgsc.gc.
> > ca
> > > wrote:
> >
> > > What is the value in your JDBC Connection Pool's "Validation Query"
> > field?
> > >
> > > What is the actual SQL command you are attempting to run?
> > >
> > > -----Original Message-----
> > > From: Sankar Das [mailto:007bhabanisankar@gmail.com]
> > > Sent: September-01-16 1:38 PM
> > > To: JMeter Users List <user@jmeter.apache.org>
> > > Subject: Not able to test jdbc request from Jmeter
> > >
> > > Hello Everyone,
> > >
> > > I am trying to build one jdbc connection from jmeter. But getting
> > > different error for different jmeter version.
> > >
> > > Jmeter 3: Cannot create PoolableConnectionFactory (ORA-00923: FROM
> > > keyword not found where expected
> > >
> > > Jmeter 2.13: ORA-00911: invalid character
> > >
> > > Same select query I am able to run from sql devloper.
> > >
> > > I have placed the jdbc driver in lib folder, have given the
> > > connection variable name and also correct connection url.
> > >
> > >
> > >
> > > These are all oracle error but connection configuration I am missing .
> > > Thanks!
> > >
> > > --------------------------------------------------------------------
> > > - To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> > > For additional commands, e-mail: user-help@jmeter.apache.org
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message