If I use a userid and password in my bean code to get a pooled connection
like so
Connection connection = ((DataSource)new
InitialContext().lookup("java:comp/env/jdbc/OracleDB")).getConnection(userid
, password);
how are such connections shared? Say I execute the above the first time
with userid = "abc" and the 2nd time with "def". If the third one that
comes in is again "abc", will the pool be smart enough to reuse the first
connection it created? As far as I know, it cannot use the second one,
because the credentials are passed when the connection is first brought up.
So the first connection can only ever be used by "abc", while the second can
only ever be used by "def". My understanding may be incorrect, and I
appreciate being corrected if so.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user