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]
