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?