From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | David Gagnon <dgagnon(at)siunik(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: upgrade problem with driver postgresql-8.1-407.jdbc3.jar |
Date: | 2006-09-06 17:49:23 |
Message-ID: | 3162722F-A4BB-47C0-9906-B99B83B206FE@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
David,
The driver has no idea how to deal with a $,
It also uses prepared statements if you use the preparedStatement
interface.
Dave
On 6-Sep-06, at 10:00 AM, David Gagnon wrote:
> Hi all,
>
> I'm running into this problem when upgrading my jdbc driver from
> pg74.216.jdbc3.jar to postgresql-8.1-407.jdbc3.jar
>
> I started having syntax error with the new driver and cannot find
> where is the problem.
> Here is the log:
>
>
> 2006-09-06 09:48:20 LOG: statement: PREPARE <unnamed> AS
> COPY vd (VDVSSRC, VDVSNUM, VDKEY, VDDATA) FROM $1
> 2006-09-06 09:48:20 ERROR: syntax error at or near "$1" at
> character 66
> 2006-09-06 09:48:20 STATEMENT: COPY vd (VDVSSRC,
> VDVSNUM, VDKEY, VDDATA) FROM $1
> Here is the VARCHAR given for $1:
> c:\\temp\\webCatalog\
> \20060517030156.zip20060517030156.zip20060517030156.zip
>
> If I try the corresponding command in pgAdmin3 it works well...
>
> Any idea what is the error? Which I suspect is quite evident .. :-/
>
> Thanks for the help!
> Best Regards
> /David
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Petersen | 2006-09-06 20:03:25 | PL/Java problem. |
Previous Message | Matt Chambers | 2006-09-06 16:13:43 | Re: scollable result sets |