Spring and iBATIS transaction problem

[Rusty Enisin]

If any of you are familiar with Spring and iBATIS transactions, please look at this. I am really stuck right now.

I have a typical multi tiered project. Logic layers are in Spring. DAO is handled by iBATIS. Transaction management is handled by Spring's DataSourceTransactionManager.

The problem is I am getting the following error when I use the transaction manager.

 faultString: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [S1009]; error code [0];   
--- The error occurred in com/mmm/ci/empi/dao/ibatis/map/AddAuditDao.xml.  
--- The error occurred while applying a parameter map.  
--- Check the addAuditLog-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in com/company/dao/ibatis/map/AddAuditDao.xml.  
--- The error occurred while applying a parameter map.  
--- Check the addAuditLog-InlineParameterMap.  
--- Check the statement (update failed).  
--- Cause: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed

Spring's application config looks like this:

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  <property name="dataSource" ref="dataSource"/>
</bean>
 
<bean class="org.springframework.transaction.interceptor.TransactionAttributeSourceAdvisor">
  <property name="transactionInterceptor" ref="transactionInterceptor"/>
</bean>
 
<bean id="transactionInterceptor" class="org.springframework.transaction.interceptor.TransactionInterceptor">
  <property name="transactionManager" ref="transactionManager"/>
  <property name="transactionAttributeSource">
    <bean class="org.springframework.transaction.annotation.AnnotationTransactionAttributeSource"/>
  </property>
</bean>

Note: If I remove the transaction manager, the code works fine. With the transaction manager this one insert does not work. Other inserts, updates, deletes, and selects all work fine either way.

It looks like a simple configuration issue. The transaction is blocking access to the database because the class has read-only access according to the transaction manager.

I have tried specifying the access privileges manually in the Spring application config. No go. I am using the transaction annotation. I have tried setting the privilege there with @Transactional(readOnly=false). No go.

What totally obvious thing am I doing wrong?

[Christophe Verré]

Did you check why the error is happening in AddAuditDao.xml ?