Re: Switching user within connection.

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