Thanx for your suggestion, I've just tried it and the problem still exists.
<transactionManager type="JDBC" commitRequired="true">
<property name="DataSource" type="SIMPLE" />
<property name="JDBC.Driver" value="${driver}" />
<property name="JDBC.ConnectionURL" value="${url}" />
<property name="JDBC.Username" value="${username}" />
<property name="JDBC.Password" value="${password}" />
<property name="JDBC.DefaultAutoCommit" value="true" />
</transactionManager>
Here how I config the sql map. Is there anything wrong here? I also already
tried like this :
<transactionManager type="JDBC">
<property name="DataSource" type="SIMPLE" />
<property name="JDBC.Driver" value="${driver}" />
<property name="JDBC.ConnectionURL" value="${url}" />
<property name="JDBC.Username" value="${username}" />
<property name="JDBC.Password" value="${password}" />
<property name="JDBC.DefaultAutoCommit" value="true" />
<property name="commitRequired" value="true" />
</transactionManager>
-----Original Message-----
From: Larry Meadors
Set <transactionManager ... commitRequired="true">
This will force even queries to be committed.
Larry