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]
