[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Can you get the active Statement object from a Connectio

[alchemista]

As a follow-up for future searchers:

We had to customize our own code to store a reference to the Statement and then try to cancel() it from the separate thread.

That worked but then the original Statement hung on the close() method.

What we had to do, using Oracle, was to store the Oracle session ID of the executing thread, then issue a separate call to the DB to kill that session.

It's a shame that didn't work in JDBC, as that appears to be the point of Statement.cancel().  Maybe it's Oracle-only JDBC implementation, but I could not find much general info on the web.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4086183#4086183

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4086183