I am sorry i havent put the error messages:
Response message: org.postgresql.util.PSQLException: ERROR: invalid input
syntax for type numeric: "${track_id}"
Response message: org.postgresql.util.PSQLException: The column index is out
of range: 1, number of columns: 0.
I was trying to send parameter values from CSV dat file in a Prepared
statment..
On Tue, Nov 18, 2008 at 4:42 PM, Parvathaneni, Sireesha <
[EMAIL PROTECTED]> wrote:
> 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]
>>>
>>>
>>
>
