Skip site navigation (1) Skip section navigation (2)

Re: JDBC rewriting a bad query?

From: "Woody Woodring" <george(dot)woodring(at)iglass(dot)net>
To: "'Kris Jurka'" <books(at)ejurka(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: JDBC rewriting a bad query?
Date: 2008-03-24 15:57:18
Message-ID: 059b01c88dc7$bd398190$80b1a8c0@istructure.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Kris,

Sorry for wasting your time.  We ran your sample and it worked.

Upon further investigation, our tomcat web servers have a copy of a postgres
jar file that it must use instead of the one with our webapp.  Who knows how
old it is.  We upgraded that one and the problem went away.

Thanks for your help,
Woody 

> -----Original Message-----
> From: pgsql-jdbc-owner(at)postgresql(dot)org 
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Kris Jurka
> Sent: Wednesday, March 19, 2008 11:35 PM
> To: Woody Woodring
> Cc: pgsql-jdbc(at)postgresql(dot)org
> Subject: Re: [JDBC] JDBC rewriting a bad query?
> 
> 
> 
> On Wed, 19 Mar 2008, Woody Woodring wrote:
> 
> > We were able to reproduce the issue with 
> postgresql-8.3-603.jdbc3.jar.
> > Please let me know if I can be of any assistance in finding 
> the issue.
> >
> 
> If you can send a self-contained test case, I'd be happy to 
> look at it.  I tried the attached test case and I get the expected:
> 
> Exception in thread "main" org.postgresql.util.PSQLException: ERROR: 
> syntax error at or near ")"
>    Position: 356
> 
> 
> Kris Jurka
> 


In response to

pgsql-jdbc by date

Next:From: Craig RingerDate: 2008-03-24 17:40:55
Subject: Re: Non-ORM layers over JDBC
Previous:From: David ClarkDate: 2008-03-24 14:53:11
Subject: Re: Non-ORM layers over JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group