Thread: Multiple threads querying using the same connection

Multiple threads querying using the same connection

From
Rini Dutta
Date:
Hi ,
I sent out an email asking about the  following error
messages, I don't know if it got posted -
Cannot handle multiple result groups
&
Unknown Response Type

I am wondering if the following two situations are
permitted/handled in the JDBC driver -
1. Multiple threads making different/separate
queries(Statements) using the same connection, at the
same time
2. Multiple threads making the same type of query(same
Statement) perhaps with different parameters, using
separate Connections.
3. I would like to reuse a PreparedStatement, is
closing the ResultSet after each query enough.

Thanks,
Rini


__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/