Thanks a lot. Working like a charm. On Fri, Sep 2, 2016 at 2:28 PM, Felix Schumacher < [email protected]> wrote:
> > > Am 2. September 2016 12:15:27 MESZ, schrieb Sankar Das < > [email protected]>: > >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 < > >[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] > >> > > > >> > > >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
