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]
