Hi all,

Does anyone know if there are any Informix JDBC drivers that support the Java Transaction Architecture(JTA), or even if the Informix DBMS supports JTA itself.

I have been trying to implement a simple web application that uses a stateless session bean through JBoss and makes use of Hibernate as the persistent layer to an Informix Database. Setting up Hibernate to use the default jdbcTransactionManager seems to work fine and records are added to the table in the database, but I would like to use the JTATransactionManager instead. I think I have configured everything fine and I do not get any errors when running the web application, but when i try query the database to see that the record has been added, I get a record locked error...!?!

Anyway, thanks in advance for any information, links or advice.

Andrew.