Gr8..It works.. i didnt check prepared option under querytype...i had gone through many times the link you posted but didnt realize..thanks!
On Wed, Nov 12, 2008 at 2:47 PM, sebb <[EMAIL PROTECTED]> wrote: > On 12/11/2008, Parvathaneni, Sireesha <[EMAIL PROTECTED]> > wrote: > > Hi > > > > I was getting above message while trying to parameter values in JDBC > > request, below is the info that i was trying to do: > > > > Connection was made to the pgSQl DB adn it works when i tried without > > parameter values: > > > > select * from product where product_id =1000 ---it works with this but > when > > i tried with > > > > select * from product where product_id =? > > parameter values : 1000 > > parameter type: Numeric > > > > What "Query Type" did you use? > > > http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Request > > Parameters only apply to Prepared Select. > > > Reponse message: org.postgresql.util.PSQLException: ERROR: syntax error > at > > end of input > > > > I havent seen anything in the logs. > > > > The same way i was tryin to send parameter values from CSV data file, > but > > taht also fails. > > > > CSV file name: c:/filepath > > Variables: track_id,trackname,..... > > > > Jdbc request: > > select * from product where product_id =? > > Parameter values: ${track_id} > > Parametr type: Numeric > > > > I have gone through the archive mails for the same issue and I downgrade > to > > pgSQL-jdbc dirver to 8.2 but no luck. > > > > Please help me with the above. > > > > Regards, > > Siri > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
