Re: jdbc3, pg 8.1.4 , and stored procedures

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