Bugs item #621692, was opened at 2002-10-11 03:27
Message generated for change (Comment added) made by ejort
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: Closed
>Resolution: Out of Date
Priority: 5
Submitted By: Elias Ross (genman)
>Assigned to: Adrian Brock (ejort)
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: Adrian Brock (ejort)
Date: 2003-09-15 12:33
Message:
Logged In: YES
user_id=9459
Reopen if this is still a problem with recent versions of jboss.
----------------------------------------------------------------------
Comment By: Elias Ross (genman)
Date: 2002-10-11 03:56
Message:
Logged In: YES
user_id=556458
Sorry for the multiple postings (sourceforge.net
timed out my browser several times.)
I've noticed that using Java 1.3.1 the periodic
problem of mine "goes away".
I suspect it's probably an issue of concurrency.
I'm pumping out messages like at the rate of 50-100/second.
----------------------------------------------------------------------
Comment By: Elias Ross (genman)
Date: 2002-10-11 03:56
Message:
Logged In: YES
user_id=556458
Sorry for the multiple postings (sourceforge.net
timed out my browser several times.)
I've noticed that using Java 1.3.1 the periodic
problem of mine "goes away".
I suspect it's probably an issue of concurrency.
I'm pumping out messages like at the rate of 50-100/second.
----------------------------------------------------------------------
Comment By: Elias Ross (genman)
Date: 2002-10-11 03:32
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();
}
}
----------------------------------------------------------------------
Comment By: Elias Ross (genman)
Date: 2002-10-11 03:32
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();
}
}
----------------------------------------------------------------------
Comment By: Elias Ross (genman)
Date: 2002-10-11 03:32
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();
}
}
----------------------------------------------------------------------
Comment By: Elias Ross (genman)
Date: 2002-10-11 03:32
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();
}
}
----------------------------------------------------------------------
Comment By: Elias Ross (genman)
Date: 2002-10-11 03: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
