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
> 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.
In response to
pgsql-jdbc by date
|Next:||From: Thomas Kellerer||Date: 2005-11-23 17:43:06|
|Subject: Why is bool == java.sql.Types.BIT ??|
|Previous:||From: Dave Cramer||Date: 2005-11-23 13:13:15|
|Subject: Re: Can PostgreSQL do data type automated casting in prepared|