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

Re: Which version of driver to use ?

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Dave Cramer <davec(at)fastcrypt(dot)com>
Cc: Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Which version of driver to use ?
Date: 2005-06-24 16:28:53
Message-ID: 1119630533.3994.118.camel@coppola.muc.ecircle.de (view raw or flat)
Thread:
Lists: pgsql-jdbc
Thanks Dave,

The connection URL version will be good I guess, I'll try tomorrow.

Cheers,
Csaba.

On Fri, 2005-06-24 at 18:25, Dave Cramer wrote:
> Csaba,
> 
> Yeah, you can force v2 protocol on the 8.0 driver
> 
> just add ?protocolVersion=2 to the connection url
> 
> see
> http://jdbc.postgresql.org/documentation/80/connect.html#connection-
> parameters
> 
> for more details
> 
> re the 74 code : it's in the main server tree for version 7.4 tag is  
> REL7_4_STABLE
> 
> Dave
> 
> On 24-Jun-05, at 11:33 AM, Csaba Nagy wrote:
> 
> > Hi all,
> >
> > We have a postgres 7.4 installation with production code running on  
> > it.
> > The code is written in Java and uses the JDBC driver to access it.
> >
> > I recently discovered that the JDBC driver we were using is not  
> > properly
> > detecting connection problems in the pooled connection  
> > implementation to
> > report them to our connection pool. However, when giving a go to fix
> > this, I also discovered that the latest 8.0 driver fixes this problem
> > (I've checked the code).
> >
> > So I've tried to upgrade to the 8.0 driver, but failed: our code is
> > pretty sloppy with the parameter types of prepared statements, and the
> > new driver is very strict about them. Eventually we will fix this, but
> > for the deployed code it's not an option.
> >
> > Question: is there a way to make the 8.0 driver less strict ? E.g. we
> > have quite a few places where numeric fields are set with "setString",
> > and other things like this.
> >
> > Alternatively, have anybody back-patched the connection error
> > notification fix to the 7.4 driver line ? If not, I could do that
> > myself, in this case what's the recommended way of getting the latest
> > 7.4 sources ? Is there actually a CVS branch for it for bug-fixes ?
> >
> > Thanks,
> > Csaba.
> >
> >
> >
> > ---------------------------(end of  
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> >
> 


In response to

Responses

pgsql-jdbc by date

Next:From: Kevin MurphyDate: 2005-06-24 21:18:35
Subject: Re: Statement setNull for Types.CLOB
Previous:From: Dave CramerDate: 2005-06-24 16:25:57
Subject: Re: Which version of driver to use ?

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