0

Sometimes when shutting down Websphere there are database locks not released. As a result, when WAS is restarted nobody can work because of these locks, that must be removed manually by the DBA.

It's a Java web application, transactions are XA and the database is Oracle. All the transactional code has a try catch finally and the transaction commit/rollback is done in the finally. I suspect that WAS do not enter the finally clause.

Lluis Martinez
  • 101
  • 3

1 Answers1

1

Does this application only exhibit this issue when running WAS?

If it's possible, I would see whether this behavior is repeatable in a different Java app server, such as JBoss or Tomcat.

When doing the testing, however, it would be crucial to use the exact same Oracle JDBC driver that WAS uses.

If not possible, I would inquire to the version of Oracle JDBC driver that WAS is using and see whether there is a newer version available.

Victor Chan
  • 126
  • 2
  • Yes it happens only with WAS. We have other customers with JBoss and it's not happening. But WAS has it's own JVM, so who knows... – Lluis Martinez Dec 11 '13 at 17:29
  • Yeah, I'm thinking the issue right now be JDK related, assuming that the Oracle JDBC driver versions running on WAS vs. Jboss are the same. The only thing I can think of is to put on tracing on WAS and send it off to IBM. Have they been helpful in resolving the issue? – Victor Chan Dec 11 '13 at 18:56