This week's book giveaway is in the JDBC forum.
We're giving away four copies of Make it so: Java DB Connections & Transactions and have Marcho Behler on-line!
See this thread for details.
The moose likes JBoss/WildFly and the fly likes 402 STATUS_NO_TRANSACTION Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Make it so: Java DB Connections & Transactions this week in the JDBC forum!
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "402 STATUS_NO_TRANSACTION Problem" Watch "402 STATUS_NO_TRANSACTION Problem" New topic


graham king
Ranch Hand

Joined: Dec 30, 2004
Posts: 133
I have a project deployed on JBOSS which makes use of EJB's.

Just today a user informed me of a problem during an update:

It's strange because the method is also called during an Insert and they don't seem to fail. I've checked the ejb.xml file and the methods trans-attribute's are set to the RequiresNew, just switched one to Required with no affect.

How is it possible that the call would fail due to no transaction? Am I doing something/everything wrong?

Also wondering if the calls to multiple methods might be the fault? The sesion bean handles the initial request and passes it off to another method which then invokes a call on a different bean. Do all these methods have to have the trans attibute set? The main session bean has * - Supports, so I thought that the rest would fall into place when using Required or RequiresNew.

That's what I get for thinking!

thanks for any HELP!
[ July 27, 2006: Message edited by: graham king ]

write, revise, re-write, revise, again...<br />write, revise, re-write, revise, again...
graham king
Ranch Hand

Joined: Dec 30, 2004
Posts: 133
A JBoss staging environment is also setup. One that runs on a separate machine and points to test data. The EJB submits the insert fine!!!

We are running against SQL Server 7.0...

Any Thoughts?
graham king
Ranch Hand

Joined: Dec 30, 2004
Posts: 133
Hate to beat this one down, but, i'm just looking for ideas for what might be causing this one? especially the NO_TRANSACTION?

i took another look at the code and found within the suspect DAO a check on the return value:

removing the check allows for an update. what do you thing the cause is for the STATUS_NO_TRANSACTION? if the jdbc driver doesn't support the method call then shouldn't it just fail gracefully?

is this a known problem with microsoft's jdbc driver or just a known problem with microsoft?
I agree. Here's the link:
subject: 402 STATUS_NO_TRANSACTION Problem
jQuery in Action, 3rd edition