Connection contexts in SQLJ routines

[Jean-Marc Blaise]

Hi,

The Information Center (V8 FP4) states that "Each SQL statement must
explicitly indicate the Connection Context object, and that context must be
explicitly instantiated in the Java method" to avoid unexpected failures.

Can someone give exemples of unexpected failures ? Is it in link with the
DB2 Connection Concentrator only ?

Thanks for your help,

Jean-Marc

[Sean McKeough]

If you don't get your own context, then threads end up sharing the
'default' one (I'm presuming you're running the default of threadsafe
java). You can get a thread stealing another threads result set cursor,
or closing it or...

Jean-Marc Blaise wrote:

Hi,

The Information Center (V8 FP4) states that "Each SQL statement must
explicitly indicate the Connection Context object, and that context must be
explicitly instantiated in the Java method" to avoid unexpected failures.

Can someone give exemples of unexpected failures ? Is it in link with the
DB2 Connection Concentrator only ?

Thanks for your help,

Jean-Marc

[Jean-Marc Blaise]

Hi Sean,

Thanks for your reply.

Jean-Marc

"Sean McKeough" <mc******@nospam.ibm.com> a écrit dans le message de
news:41********@news3.prserv.net...

If you don't get your own context, then threads end up sharing the
'default' one (I'm presuming you're running the default of threadsafe
java). You can get a thread stealing another threads result set cursor,
or closing it or...

Jean-Marc Blaise wrote:

Hi,

The Information Center (V8 FP4) states that "Each SQL statement must
explicitly indicate the Connection Context object, and that context must be explicitly instantiated in the Java method" to avoid unexpected failures.
Can someone give exemples of unexpected failures ? Is it in link with the DB2 Connection Concentrator only ?

Thanks for your help,

Jean-Marc