Hi
Again i was facing the same issue
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
Please help.
Thanks&Regards,
Siri
On Wed, Nov 12, 2008 at 5:29 PM, Parvathaneni, Sireesha <
[EMAIL PROTECTED]> wrote:
> 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]
>>
>>
>
