You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Sankar Das <00...@gmail.com> on 2016/09/01 17:37:57 UTC
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!
Re: Not able to test jdbc request from Jmeter
Posted by Philippe Mouawad <ph...@gmail.com>.
Modify the validation query select 1 to select 1 from dual
Regards
On Thu, Sep 1, 2016 at 7:37 PM, Sankar Das <00...@gmail.com>
wrote:
> 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!
>
--
Cordialement.
Philippe Mouawad.
Re: Not able to test jdbc request from Jmeter
Posted by Sankar Das <00...@gmail.com>.
Thanks a lot. Working like a charm.
On Fri, Sep 2, 2016 at 2:28 PM, Felix Schumacher <
felix.schumacher@internetallee.de> wrote:
>
>
> Am 2. September 2016 12:15:27 MESZ, schrieb Sankar Das <
> 007bhabanisankar@gmail.com>:
> >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
> >)
>
> Use "select 1 from dual" instead of "select 1" as validation query.
>
> Felix
> >
> >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 <us...@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 <us...@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 <us...@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
> >> > >
> >> >
> >>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>
Re: Not able to test jdbc request from Jmeter
Posted by Felix Schumacher <fe...@internetallee.de>.
Am 2. September 2016 12:15:27 MESZ, schrieb Sankar Das <00...@gmail.com>:
>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
>)
Use "select 1 from dual" instead of "select 1" as validation query.
Felix
>
>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 <us...@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 <us...@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 <us...@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
>> > >
>> >
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org
Re: Not able to test jdbc request from Jmeter
Posted by Sankar Das <00...@gmail.com>.
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 <us...@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 <us...@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 <us...@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
> > >
> >
>
RE: Not able to test jdbc request from Jmeter
Posted by Jacob Zwiers <Ja...@tpsgc-pwgsc.gc.ca>.
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 <us...@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 <us...@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 <us...@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
> >
>
Re: Not able to test jdbc request from Jmeter
Posted by Sankar Das <00...@gmail.com>.
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 <us...@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 <us...@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
> >
>
RE: Not able to test jdbc request from Jmeter
Posted by Jacob Zwiers <Ja...@tpsgc-pwgsc.gc.ca>.
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 <us...@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 <us...@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
>
Re: Not able to test jdbc request from Jmeter
Posted by Sankar Das <00...@gmail.com>.
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 <us...@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
>
RE: Not able to test jdbc request from Jmeter
Posted by Jacob Zwiers <Ja...@tpsgc-pwgsc.gc.ca>.
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 <us...@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