This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes LocalTransactionException during and after Oracle database shutdown. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "LocalTransactionException during and after Oracle database shutdown." Watch "LocalTransactionException during and after Oracle database shutdown." New topic
Author

LocalTransactionException during and after Oracle database shutdown.

Rob Micah
Ranch Hand

Joined: Aug 30, 2011
Posts: 94
I have a JSF bean that creates a stateful session bean. The session bean has 2 dependency injected @Resources of DataSources that point to 2 different oracle databases and does nothing more than return a Connection object. Everything works fine until database 1 has its nightly shutdown. If I try to access my JSF application and connect to database 1 I get an exception. However, even after providing a different parameter so that my application connects to database 2 I still get the same exception even though database 2 never went down. I have no experience with transactions and this appears to be a transaction error. What am I doing wrong?


 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: LocalTransactionException during and after Oracle database shutdown.