Re: Switching user within connection. - Mailing list pgsql-jdbc

From Rob Kirkbride
Subject Re: Switching user within connection.
Date
Msg-id 43846D95.9070602@rkcomputing.co.uk
Whole thread Raw
In response to Re: Switching user within connection.  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc
Oliver Jowett wrote:

> Rob Kirkbride wrote:
>
>> Thanks for your reply. I think I'd guessed that would be the reply.
>> It's probably off topic really now but I wanted to maintain a series
>> of pooled connections but with potentially different users. I got
>> lost reading the JCA documentation which may do something clever but
>> I'm guessing if the underlying JDBC driver doesn't support it then
>> there's not a lot it can do really.
>
>
> My JCA is a bit rusty, but from memory the way you deal with this is
> by implementing ManagedConnectionFactory.matchManagedConnections() to
> only consider connections that have matching authentication info. So
> the container can maintain a single pool of connections, but when it
> asks the connector for a suitable connection authenticated as Joe then
> only connections in the pool that are already authenticated as Joe are
> considered.
>
> You may end up needing more connections in the pool depending on the
> actual usage pattern, but you don't need to reauthenticate on an
> existing connection.
>
Thanks for you help - I see yes what you've given would be helpful.
However I'm struggling at the moment to work out how to configure JCA on
JBoss using Hibernate. But I guess that's a question for another forum!

Thanks again Oliver.

Rob


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Can PostgreSQL do data type automated casting in prepared
Next
From: Thomas Kellerer
Date:
Subject: Why is bool == java.sql.Types.BIT ??