>> 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