Hi
org.postgresql.util.PSQLException: ERROR: syntax error at end of input
> 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
>
> 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
On Wed, Nov 12, 2008 at 1:57 PM, <[EMAIL PROTECTED]>wrote:
> Hi! This is the ezmlm program. I'm managing the
> [email protected] mailing list.
>
> I'm working for my owner, who can be reached
> at [EMAIL PROTECTED]
>
> Acknowledgment: I have added the address
>
> [EMAIL PROTECTED]
>
> to the jmeter-user mailing list.
>
> Welcome to [EMAIL PROTECTED]
>
> Please save this message so that you know the address you are
> subscribed under, in case you later want to unsubscribe or change your
> subscription address.
>
>
> --- Administrative commands for the jmeter-user list ---
>
> I can handle administrative requests automatically. Please
> do not send them to the list address! Instead, send
> your message to the correct command address:
>
> To subscribe to the list, send a message to:
> <[EMAIL PROTECTED]>
>
> To remove your address from the list, send a message to:
> <[EMAIL PROTECTED]>
>
> Send mail to the following for info and FAQ for this list:
> <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED]>
>
> Similar addresses exist for the digest list:
> <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED]>
>
> To get messages 123 through 145 (a maximum of 100 per request), mail:
> <[EMAIL PROTECTED]>
>
> To get an index with subject and author for messages 123-456 , mail:
> <[EMAIL PROTECTED]>
>
> They are always returned as sets of 100, max 2000 per request,
> so you'll actually get 100-499.
>
> To receive all messages with the same subject as message 12345,
> send a short message to:
> <[EMAIL PROTECTED]>
>
> The messages do not really need to be empty, but I will ignore
> their content. Only the ADDRESS you send to is important.
>
> You can start a subscription for an alternate address,
> for example "[EMAIL PROTECTED]", just add a hyphen and your
> address (with '=' instead of '@') after the command word:
> <[EMAIL PROTECTED]>
>
> To stop subscription for this address, mail:
> <[EMAIL PROTECTED]>
>
> In both cases, I'll send a confirmation message to that address. When
> you receive it, simply reply to it to complete your subscription.
>
> If despite following these instructions, you do not get the
> desired results, please contact my owner at
> [EMAIL PROTECTED] Please be patient, my owner is a
> lot slower than I am ;-)
>
> --- Enclosed is a copy of the request I received.
>
> Return-Path: <[EMAIL PROTECTED]>
> Received: (qmail 37357 invoked by uid 99); 12 Nov 2008 18:57:40 -0000
> Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
> by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Nov 2008 10:57:40
> -0800
> X-ASF-Spam-Status: No, hits=2.0 required=10.0
> tests=HTML_MESSAGE,SPF_PASS
> X-Spam-Check-By: apache.org
> Received-SPF: pass (athena.apache.org: domain of
> [EMAIL PROTECTED] designates 74.125.92.25 as permitted
> sender)
> Received: from [74.125.92.25] (HELO qw-out-2122.google.com) (74.125.92.25)
> by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Nov 2008 18:56:21
> +0000
> Received: by qw-out-2122.google.com with SMTP id 3so362004qwe.31
> for
> <jmeter-user-sc.1226429835.dhgjiodlnjllnbpknfbi-sireesha.parvathaneni=
> [EMAIL PROTECTED]>; Wed, 12 Nov 2008 10:57:04 -0800 (PST)
> DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
> d=gmail.com; s=gamma;
> h=domainkey-signature:received:received:message-id:date:from:to
> :subject:in-reply-to:mime-version:content-type:references;
> bh=N36CzgLZqAbEsMqznQDDsK8uCa0UGfC/p5ttXOaOSN0=;
> b=XVE02ED2NFuVr8SLyropQKseVR8N4EEaEK01EuLP56V9QpreqF0J+R7uEZcguTtNvI
>
> Q/fsiA6IP9FSpaRSaEJue6GVvI6x/uTMghEf+RoLDpFfiA4Vq4V5rFOe1Nh4GmTHyve2
> lo9VjlPlRJ6eZoKvxO5rdzi7a6syDfRF11xw8=
> DomainKey-Signature: a=rsa-sha1; c=nofws;
> d=gmail.com; s=gamma;
> h=message-id:date:from:to:subject:in-reply-to:mime-version
> :content-type:references;
> b=elpKqy+UeOQG+mJtZOTrlFjYtoge0NRtoNSe9olXywofbDsYIoqfNKpwUAsdg2rl0f
>
> O0EzxOwGpT/D1l1mFxjfeVU9F7ctDNBtVC6+rIQ3MFeiIqyfQ3z83s2u41wor5q8gdbC
> aszsyDLfiK3n2f4NBQ8c2YukJ8MOt78DBmV7I=
> Received: by 10.214.9.17 with SMTP id 17mr10092313qai.222.1226516224357;
> Wed, 12 Nov 2008 10:57:04 -0800 (PST)
> Received: by 10.215.14.9 with HTTP; Wed, 12 Nov 2008 10:57:04 -0800 (PST)
> Message-ID: <[EMAIL PROTECTED]>
> Date: Wed, 12 Nov 2008 13:57:04 -0500
> From: "Parvathaneni, Sireesha" <[EMAIL PROTECTED]>
> To: jmeter-user-sc.1226429835.dhgjiodlnjllnbpknfbi-sireesha.parvathaneni=
> [EMAIL PROTECTED]
> Subject: Fwd: Returned post for [email protected]
> In-Reply-To: <[EMAIL PROTECTED]>
> MIME-Version: 1.0
> Content-Type: multipart/alternative;
> boundary="----=_Part_15517_22939407.1226516224359"
> References: <[EMAIL PROTECTED]>
> <[EMAIL PROTECTED]>
> X-Virus-Checked: Checked by ClamAV on apache.org
>
> ------=_Part_15517_22939407.1226516224359
> Content-Type: text/plain; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline
>
> ---------- Forwarded message ----------
> From: Parvathaneni, Sireesha <[EMAIL PROTECTED]>
> Date: Wed, Nov 12, 2008 at 1:55 PM
> Subject: Re: Returned post for [email protected]
> To: [EMAIL PROTECTED]
>
>
> Looking forward for a solution to my below mentioned problem.
>
> On Tue, Nov 11, 2008 at 2:36 PM, <[EMAIL PROTECTED]
> >wrote:
>
> > Hi! This is the ezmlm program. I'm managing the
> > [email protected] mailing list.
> >
> > I'm working for my owner, who can be reached
> > at [EMAIL PROTECTED]
> >
> > I'm sorry, your message (enclosed) was not accepted by the moderator.
> > If the moderator has made any comments, they are shown below.
> >
> > >>>>> -------------------- >>>>>
> > Please subscribe to the list before posting - thanks!
> > You will need to reply to the subscribe confirmation before you can post.
> > <<<<< -------------------- <<<<<
> >
> >
> > ---------- Forwarded message ----------
> > From: "Parvathaneni, Sireesha" <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED],
> > [EMAIL PROTECTED], [email protected]
> > Date: Tue, 11 Nov 2008 13:56:29 -0500
> > Subject: org.postgresql.util.PSQLException: ERROR: syntax error at end of
> > input
> > 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
> >
> > 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
> >
> >
> >
> >
> >
>
> ------=_Part_15517_22939407.1226516224359
> Content-Type: text/html; charset=ISO-8859-1
> Content-Transfer-Encoding: 7bit
> Content-Disposition: inline
>
> <br><br>
> <div class="gmail_quote">---------- Forwarded message ----------<br>From:
> <b class="gmail_sendername">Parvathaneni, Sireesha</b> <span
> dir="ltr"><<a href="mailto:[EMAIL PROTECTED]">
> [EMAIL PROTECTED]</a>></span><br>
> Date: Wed, Nov 12, 2008 at 1:55 PM<br>Subject: Re: Returned post for <a
> href="mailto:[email protected]";>
> [email protected]</a><br>To: <a href="http://gmail.com";>
> gmail.com</a>@<a href="http://jakarta.apache.org";>jakarta.apache.org
> </a><br>
> <br><br>Looking forward for a solution to my below mentioned
> problem.<br><br>
> <div class="gmail_quote">
> <div>
> <div></div>
> <div class="Wj3C7c">On Tue, Nov 11, 2008 at 2:36 PM, <span dir="ltr"><<a
> href="mailto:[EMAIL PROTECTED]" target="_blank">
> [EMAIL PROTECTED]</a>></span> wrote:<br></div></div>
> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
> 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
> <div>
> <div></div>
> <div class="Wj3C7c">Hi! This is the ezmlm program. I'm managing
> the<br><a href="mailto:[email protected]"; target="_blank">
> [email protected]</a> mailing list.<br><br>I'm working
> for my owner, who can be reached<br>
> at <a href="mailto:[EMAIL PROTECTED]" target="_blank">
> [EMAIL PROTECTED]</a>.<br><br>I'm sorry, your
> message (enclosed) was not accepted by the moderator.<br>If the moderator
> has made any comments, they are shown below.<br>
> <br>>>>>> --------------------
> >>>>><br>Please subscribe to the list before posting -
> thanks!<br>You will need to reply to the subscribe confirmation before you
> can post.<br><<<<< --------------------
> <<<<<<br>
> <br><br></div></div>---------- Forwarded message
> ----------<br>From: "Parvathaneni, Sireesha" <<a
> href="mailto:[EMAIL PROTECTED]" target="_blank">
> [EMAIL PROTECTED]</a>><br>To: <a href="mailto:
> [EMAIL PROTECTED]" target="_blank">
> [EMAIL PROTECTED]</a>, <a href="mailto:
> [EMAIL PROTECTED]" target="_blank">
> [EMAIL PROTECTED]</a>, <a href="mailto:
> [email protected]" target="_blank">
> [email protected]</a><br>
> Date: Tue, 11 Nov 2008 13:56:29
> -0500<br>Subject: org.postgresql.util.PSQLException: ERROR: syntax
> error at end of input<br>
> <div>Hi</div>
> <div> </div>
> <div>I was getting above message while trying to parameter values in JDBC
> request, below is the info that i was trying to do:</div>
> <div> </div>
> <div>Connection was made to the pgSQl DB adn it works when i tried without
> parameter values:</div>
> <div> </div>
> <div>select * from product where product_id =1000 ---it works with
> this but when i tried with </div>
> <div>select * from product where product_id =?</div>
> <div> </div>
> <div>parameter values : 1000</div>
> <div>parameter type: Numeric</div>
> <div> </div>
> <div>Reponse message: org.postgresql.util.PSQLException: ERROR: syntax
> error at end of input</div>
> <div>I havent seen anything in the logs.</div>
> <div> </div>
> <div>The same way i was tryin to send parameter values from CSV data file,
> but taht also fails.</div>
> <div> </div>
> <div>CSV file name: c:/filepath</div>
> <div>Variables: track_id,trackname,.....</div>
> <div> </div>
> <div>Jdbc request:</div>
> <div>select * from product where product_id =?</div>
> <div> </div>
> <div>Parameter values: ${track_id}</div>
> <div>Parametr type: Numeric</div>
> <div> </div>
> <div> </div>
> <div>I have gone through the archive mails for the same issue and I
> downgrade to pgSQL-jdbc dirver to 8.2 but no luck.</div>
> <div> </div>
> <div>Please help me with the above.</div>
> <div> </div>
> <div>Regards,<br>Siri</div>
> <div> </div>
> <div> </div>
> <div> </div><br></blockquote></div><br></div><br>
>
> ------=_Part_15517_22939407.1226516224359--
>
