Multiplexed Connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dot.yet@gmail.com - 26 Sep 2008 21:09 GMT

Hi Everyone,

I have a question (dont know if its dumb or not) related to how DB2
manages connections. Can I have two active java threads use a single
DB2 connection at the same time. Is it possible to have two
independent statements running on the same DB2 connection at the same
time ("in-flight")?

Thanks in advance.
dotyet

Reply to this Message

Ian - 27 Sep 2008 00:06 GMT

> Hi Everyone,
>
[quoted text clipped - 3 lines]
> independent statements running on the same DB2 connection at the same
> time ("in-flight")?

Sure. This happens all of the time. Imagine an application that
opens a cursor, and for each row it fetches, it issues an update to
another table. Two separate statements, both executing at the same
time, with a single connection.

Ian

Reply to this Message