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

Re: Totally weird behaviour in org.postgresql.Driver

From: "Peter" <peter(at)greatnowhere(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Totally weird behaviour in org.postgresql.Driver
Date: 2009-03-15 07:10:31
Message-ID: 49bca9e8$0$1341$834e42db@reader.greatnowhere.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
>> I checked out dbcp and c3po (thanks for the pointers!) but none fits my 
>> app
>> as each user needs to connect with his own credentials.
>
> This was a problem for me as well.  So, I made a factory for returning
> connections from dbcp and made some adjustments to the connection returned
> from the pool, so that our auditing triggers knew the application user 
> that
> was using the connection.
>
> That way we could get the auditing and use a pool that has hopefully had 
> the
> bugs beaten out of if.  But, that would not work in every situation.

Thanks for sharing the tip! What adjustments exactly did you have to make? I 
just make every user to log on with different PG username. Are there any 
other options?

Peter 



In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2009-03-15 11:09:09
Subject: Re: Totally weird behaviour in org.postgresql.Driver
Previous:From: decibelDate: 2009-03-14 14:42:22
Subject: Re: Query much slower when run from postgres function

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