Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 30 Aug 2006 16:11:23 -0700
|
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 |
- Follow-Ups:
- Re: jdbc3, pg 8.1.4 , and stored procedures
- From: Dave Cramer
- Re: jdbc3, pg 8.1.4 , and stored procedures
- Prev by Date: Re: [HACKERS] [PATCHES] log_statement output for protocol
- Next by Date: Re: jdbc3, pg 8.1.4 , and stored procedures
- Previous by thread: Catching postgres exceptions - functions returning error values?
- Next by thread: Re: jdbc3, pg 8.1.4 , and stored procedures
- Indexes: