Re: jdbc3, pg 8.1.4 , and stored procedures

[Dave Cramer <pg(at)fastcrypt(dot)com>]

Matt,

That's pretty strange, the test suite in the driver uses exactly the same syntax. 

Can you send a self contained test that fails ?

Dave

On 30-Aug-06, at 7:11 PM, Matt Chambers wrote:

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