Hi all,

Recently I posted a problem about not getting more than one connection
to the db at a time.  Seems like there was no pool, and my system had to
wait for the connection to be closed before another bean could get a
connection.

One response I got was that if I was using a JDBC 1.0 driver, there
would be no pool, and to get multiple connections, I would have to
upgrade to a JDBC 2 driver.

I am unclear about some things here.  If the above statement is correct,
how would I ever be able to get more then one connection when using
jdk1.1.8?  I have yet to find anything written about JDBC 2.0 drivers
working with jdk1.1.x.  So does this mean that if I am using jdk1.1 I do
not get a connection pool, but a connection?

I have another question about this.  If I am using a connection from the
pool, will there be a transaction attached to that connection?  In other
words my code looks like this

Connection conn =
((DataSource)initialContext.lookup(connectionName)).getConnection();
UserTransaction transaction = initialContext.getUserTransaction();

will the transaction here be attached to the same connection as the conn
object?

Thanks in advance
Chris

Reply via email to