[Persistence, JBoss/CMP, Hibernate, Database] - Can you get the active Statement object from a Connection ob
by 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
18 years, 8 months
[JBoss Seam] - Re: IllegalStateException: could not acquire lock
by jasondlee
Well, some progress to report. I built a Seam "nightly" and redeployed my app, and things seem to be better. If I click like a "normal" user, things are fine, but if I go nuts and click the link a bunch of times, I get the locking error. My only guess is that there's a timing issue between my onslaught of requests and the lock releases, but that's a semi-educated and somewhat obvious guess. The upshot is that it's working well enough for demoing/testing, though I'd still like to get a real fix for it.
Any pointers are appreciated. I have the Seam source checked out, so I can go diving through that, and, of course, if the issue lies with JSF RI, I can fix that (hopefully) in short order. Thanks. :)
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4083651#4083651
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4083651
18 years, 8 months