I have installed the latest community release of Ingres, and was trying
to do some testing with it, using JBoss EAP 5.0.1. I successfully
installed, and created my database schema, and successfully created a
working data source definition for JBoss. When running the first part
of my application (an EJB 3 application), the database seemed to just
hang, and eventually the transaction manager in JBoss timeout the
transaction, and forced a rollback as it should.

Forget the hang for now. The problem I'm most interested in is why
when the transaction manager forced a rollback did Ingres do nothing?
Maybe it was the hang condition, or does Ingres not work with a
transaction manager properly? I was using the latest JDBC driver 4.0.2
as well, and I couldn't even shut down the server (application server
that is), unless I shutdown the database.


--
andrigtmiller