0 Replies Latest reply on Aug 5, 2002 6:14 AM by Sean Radford

    Multiple JBoss instances and db locking

    Sean Radford Novice

      Hi,

      I have multiple JBoss 3.0 instances running (on different machines) running the same application, connecting to the same Oracle DB.

      However, when you start the applications, the first one to make a db connection runs perfectly happily whilst locking the others out. The lock stays until you shut down the JBoss instance that caused the lock (the application just finishing it's code-run keeps the lock).

      The code being run is a bean-managed transaction stateless session bean that: starts a transaction, does a select for update, does the update and then closes the connection (commiting the transaction). (It's a key generator).

      Anyone have any ideas as to why the lock is happening?

      Thanks in advance,

      Sean