Yes i have added debug sampler which helps me to resolve the issue, Thanks a
lot.
As the CSv data file contains coulmn headers at the beginign and its taking
the parameters like below:
album_id=album_id
track_id=track_id
I removed the column headers in the file , now its working..Appriciate your
help!
On Wed, Nov 19, 2008 at 12:06 PM, sebb <[EMAIL PROTECTED]> wrote:
> On 19/11/2008, Parvathaneni, Sireesha <[EMAIL PROTECTED]>
> wrote:
> > Hi
> > Yes its working replacing ${track_id} with fixed data values i.e 1000
>
> OK, so the problem is not in the JBDC request.
>
> Did you try adding a Debug Sampler (see my last message)?
>
> > 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]
> > >
> > >
> >
> >
>
