jdbc3, pg 8.1.4 , and stored procedures

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

Responses

Browse pgsql-jdbc by date

  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