| 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 15:12:22 |
| Message-ID: | 44FEE556.5000408@siunik.com |
| Views: | Whole Thread | Raw Message | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Chambers | 2006-09-06 16:13:43 | Re: scollable result sets |
| Previous Message | Dave Cramer | 2006-09-06 14:13:34 | Moving to pgfoundry |