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

Re: Totally weird behaviour in org.postgresql.Driver

From: Guy Rouillier <guyr-ml1(at)burntmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Totally weird behaviour in org.postgresql.Driver
Date: 2009-03-16 01:30:47
Message-ID: 49BDABC7.3030108@burntmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
peter wrote:
>>         
>>         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?
>>
>> It's fairly unusual to have a tomcat application of any size login to
>> the db as the user. Could you share the reason why ?
>>
> 
> The app is actually middleware for Adobe Flex frontend and PG backend,
> not a regular web app. The architecture requires PG to know which user
> has connected (lots of heavy lifting takes place in PG), and we so far
> havent found any other way how to let PG know which user has connected.
> The only alternative was to supply user ID in every PG function call but
> that is messy and introduces it's own limitations as well. If you have
> any suggestions I'm all ears! ;)

Set a user variable after you've obtained a connection from the pool, 
and use that to log user-specific values.  That way, you maintain the 
benefits of connection pools, but can still identify individual users.

-- 
Guy Rouillier

In response to

Responses

pgsql-jdbc by date

Next:From: Osamu TachiyamaDate: 2009-03-16 08:57:52
Subject: Question of Encryption and ECCN number
Previous:From: Oliver JowettDate: 2009-03-16 00:58:36
Subject: Re: Totally weird behaviour in org.postgresql.Driver

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