mybatis autocommit always committing even when false

[Vincent Sharma]

Hi, I'm trying to get my code to perform a number of inserts and commit at the very end if they all were successful. Here are the relevant mybatis config specs:

<environment id="all"> <transactionManager type="JDBC"> <property name="JDBC.DefaultAutoCommit" value="false" /> <property name="JDBC.CommitRequired" value="true" /> </transactionManager> <dataSource type="JNDI"> <property name="data_source" value="jdbc/thedb"/> </dataSource> </environment>


And here is a rough outline of the code:

session = sqlSessionFactory.openSession(false);

... insert A, insert B, insert C ...

session.commit();

...unless there is an exception...

session.rollback(true);


However, when I try to call the session.commit(); it gives this error: "Operation Connection.commit is not allowed during a global transaction." and then when I check the table, the record is there. So it seems to have autocommitted.

I've tried setting <transactionManager type="EXTERNAL"> and it says it doesn't know what external is. If I set session = sqlSessionFactory.openSession(true); then I don't get an exception, but then it autocommits. What I am trying to do is to get it to only commit when I call session.commit() and then not commit anything if there is an exception and I call the rollback. Any help would be appreciated.

Vincent