rollback and commit when calling connection.close

[W Che]

Hello

This is my first post here as a newbie to MYSQL.

I have been debugging an issue with our existing system, which is based on java/Spring/hibernate. Basically during system startup, it saves few rows into some table. The followings are few lines of log from MYSQL:

6 Query SET autocommit=0
6 Query SELECT @@session.tx_isolation
6 Query INSERT INTO ...
6 Query rollback

The code does NOT call commit or rollback, so I believe 'rollback' in the log is triggered by connection.close().

Now the issue: the code works fine on 5.1.58-1ubuntu1 (our existing DB server). I am trying to set up a new replacement server on EC2 with version 5.5.24. The same code does not save the rows. I have been comparing configurations between the 2 servers and can't seem to figure out what is the cause.

Thanks in advance.