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

[alchemista]

Hello,

I'm using JBoss 4.0.3, with Oracle 9iR2 DB, with Oracle 11g JDBC Drivers.

I'm using a JBoss datasource to the Oracle DB.

I have the need to call Statement.cancel() on the currently running JDBC Statement, but from a thread that does not have visibility of the Statement object.

I have visibility of the Connection object, but there is not a standard JDBC API to retrieve the currently executing Statements from that Connection.  I'm wondering if there's a JBoss-specific way to retrieve the active Statement from a given Connection?

Basically, what I want to do is:
Use my session manager that keeps one connection per session.  Then, when a new thread comes in, look up that session's Connection, view its active Statements (probably just one), and then call Statement.cancel() on those statements.

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

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