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?