Hi
Yes its working replacing ${track_id} with fixed data values i.e 1000
But the same way i was trying to send the parameter values from a CSV data
file so..
CSV file name: c:/filepath
Variables: track_id,trackname,.....
*Jdbc request*:
select * from product where product_id =?
Parameter values: ${track_id}
Parametr type: Numeric
Thanks,
Siri
On Tue, Nov 18, 2008 at 5:53 PM, sebb <[EMAIL PROTECTED]> wrote:
> On 18/11/2008, Parvathaneni, Sireesha <[EMAIL PROTECTED]>
> wrote:
> > I am sorry i havent put the error messages:
> >
> > Response message: org.postgresql.util.PSQLException: ERROR:
> > invalid input syntax for type numeric: "${track_id}"
>
> That means JMeter could not find the variable "track_id". Try adding a
> Debug Sampler to check that it is being set correctly.
>
> >
> > Response message: org.postgresql.util.PSQLException: The
> > column index is out of range: 1, number of columns: 0.
>
> Not sure what that means - it may be caused by the earlier error.
>
> Try replacing ${track_id} with a fixed number and see if the error goes
> away.
>
> > 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]
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
