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
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to