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

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...