From: | Matt Chambers <chambers(at)imageworks(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | jdbc3, pg 8.1.4 , and stored procedures |
Date: | 2006-08-30 23:11:23 |
Message-ID: | 44F61B1B.4030009@imageworks.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Greetings. I've inherited this Tomcat / Postgres application and I'm
having a problem, not sure what is. Basically, its a postgres 8.1.4
server and a tomcat application. All of the SQL is done in plpgsql,
which is called with prepareCall statements, example:
"{ ? = call getDispatchList ( ? ) }"
With the 7.4 driver it works, with the 8.1 driver every query fails with:
WARNING: Caught unexpected: org.postgresql.util.PSQLException: Malformed
function or procedure escape syntax at offset 4.,
org.postgresql.util.PSQLException: Malformed function or procedure
escape syntax at offset 4.
I've been able to move the other applications over to the 8.1 driver
(none use stored procedures) no problem. What is the secret?
--
*Matt Chambers <chambers(at)imageworks(dot)com>*
*Sony Pictures Imageworks*
Software Engineer
Phone: (310) 840 9072
Cell: (703) 624 0221
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2006-08-30 23:56:25 | Re: jdbc3, pg 8.1.4 , and stored procedures |
Previous Message | Bruce Momjian | 2006-08-30 18:21:18 | Re: [HACKERS] [PATCHES] log_statement output for protocol |