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$ (view raw, whole thread or download thread mbox)
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?


In response to


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-2017 The PostgreSQL Global Development Group