This week's book giveaways are in the Refactoring and Agile forums. We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line! See this thread and this one for details.
LocalTransactionException during and after Oracle database shutdown.
posted 4 years ago
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?