upgrade problem with driver postgresql-8.1-407.jdbc3.jar

From: David Gagnon <dgagnon(at)siunik(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: upgrade problem with driver postgresql-8.1-407.jdbc3.jar
Date: 2006-09-06 14:00:26
Message-ID: 44FED47A.3010008@siunik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-09-06 14:13:34 Moving to pgfoundry
Previous Message Koth, Christian (DWBI) 2006-09-06 07:39:39 Re: scollable result sets