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 < [email protected]> wrote: > What happens when you remove it (and adjust validation query as per other > poster's suggestion)? > > -----Original Message----- > From: Sankar Das [mailto:[email protected]] > Sent: September-01-16 3:06 PM > To: JMeter Users List <[email protected]> > Subject: Re: Not able to test jdbc request from Jmeter > > with semicolon @ end. > > On Thu, Sep 1, 2016 at 9:51 PM, Jacob Zwiers <[email protected]. > ca > > wrote: > > > With or without the semicolon @ the end? > > > > -----Original Message----- > > From: Sankar Das [mailto:[email protected]] > > Sent: September-01-16 2:46 PM > > To: JMeter Users List <[email protected]> > > 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 > <[email protected]. > > 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:[email protected]] > > > Sent: September-01-16 1:38 PM > > > To: JMeter Users List <[email protected]> > > > 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: [email protected] > > > For additional commands, e-mail: [email protected] > > > > > >
