Bugs item #621692, was opened at 2002-10-10 20:27
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=621692&group_id=22866
Category: JBossCX
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Elias Ross (genman)
Assigned to: Nobody/Anonymous (nobody)
Summary: NoTxConnection -- Periodic SQLExceptions
Initial Comment:
Regarding the NoTxConnection manager to work...
I was wondering if there was a way to use a managed
connection from an MBean, for example, (look at the
billing-service.xml file attached), I want to use
the 'billing' datasource to log records to the database
using an MBean, while also using it from
a MessageDrivenBean. Periodically I get exceptions,
however:
(Note that the SQL connection was obtained
during the MBean initialization, and this MBean
is being called by a MDB using JNDI.)
java.sql.SQLException: Connection handle is not currently associated with a
ManagedConnection
at
org.jboss.resource.adapter.jdbc.local.LocalConnection.checkStatus(LocalConnection.java:774)
at
org.jboss.resource.adapter.jdbc.local.LocalConnection.checkTransaction(LocalConnection.java:755)
at
org.jboss.resource.adapter.jdbc.local.LocalStatement.checkTransaction(LocalStatement.java:771)
at
org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeUpdate(LocalPreparedStatement.java:305)
at com.proteusmobile.oamp.mdr.MdrDBAppender.logDB(MdrDBAppender.java:200)
... 31 more
Is this a bug or am I configuring things incorrectly?
This is with Oracle 9.2, JBoss 3.0.1, on Java 1.4
on Linux.
----------------------------------------------------------------------
>Comment By: Elias Ross (genman)
Date: 2002-10-10 20:31
Message:
Logged In: YES
user_id=556458
Forgot to submit the XML file.
The MBean in start service looks something like this:
public class {
Connection con;
public void startService() throws Exception {
con = new InitialContext().lookup("java:/billing/ds");
}
public void billSomething() throws Exception {
PrepareStatement ps = con.prepareStatement("insert ...");
ps.executeUpdate();
}
}
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=376685&aid=621692&group_id=22866
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
