Transactions on IBM I (AS400)

I’m using Spring Boot 3.3.5, so I’m using Hibernate 6.5.3.Final, and I’m using JTOpen driver to connect to IBM I, and I was doing some tests to test transactions, and I noticed that rollback is not running, so I wanted to ask for support, is there any particular configuration I should do to make it work? I’m using Spring’s @Transactional, should I do it in another way? Rollback is very necessary, and it’s the only database I can use, if you can help me, I’d be grateful

PS: the connection driver seemed far-fetched to me, so I’m providing it here:

Hibernate ORM integrates with the transaction provider, so if you’re using Spring transactions, then Hibernate ORM will inform the Spring transaction manager about rollbacks. It is then the responsibility of the Spring transaction manager to ensure a transaction is rolled back by invoking the necessary methods on the JDBC connection.

Since nobody else complains about this not working, I can only assume that the AS400 JDBC driver has a bug or you have it misconfigured. Contact your IBM support or raise a ticket on the JTOpen repository about this.

I’ll investigate to see if the problem is the driver, or if it’s something else, let’s see what I can get, thanks

1 Like