upgrade problem with driver postgresql-8.1-407.jdbc3.jar - Mailing list pgsql-jdbc

From David Gagnon
Subject upgrade problem with driver postgresql-8.1-407.jdbc3.jar
Date
Msg-id 44FED47A.3010008@siunik.com
Whole thread Raw
Responses Re: upgrade problem with driver postgresql-8.1-407.jdbc3.jar  (Dave Cramer <pg@fastcrypt.com>)
Re: upgrade problem with driver postgresql-8.1-407.jdbc3.jar  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
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



pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Moving to pgfoundry
Next
From: Dave Cramer
Date:
Subject: Re: upgrade problem with driver postgresql-8.1-407.jdbc3.jar