In our application, we use XAConnection on Oracle 8. Everything is fine, but I noticed for a particular code that is not EJB (but uses the managed connection from Jboss), the changes made by that code does not get commited until maybe an hour later. I can see the changes within the application, but from another application, I won't see thc changes on the database until maybe an hour later. I tried shutting down the server and the changes do get commited before shutdown. I changed the code to be a local EJB and the changes are now reflected right away.
What's the default behaviour for non ejb code using a managed XA connection? Can we change it so that my database change by non ejbs will commit right away? I am using Jboss 3.2.2.