事務不生效 · walk

工程中默認使用聲明式事務，事務控制在service層，規則定義在transaction.xml文件中 * 以select、query、get等開頭的方法為只讀事務 * 以insert、create、save、do等開頭的方法走事務所以當控制臺報Connection is read-only錯誤時就要注意下service中方法開頭了 ``` Caused by: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ``` transaction.xml文件內容 ```  <tx:advice id="txAdvice" transaction-manager="txManager"> <tx:attributes> <tx:method name="select*" read-only="true"/> <tx:method name="query*" read-only="true"/> <tx:method name="get*" read-only="true"/> <tx:method name="load*" read-only="true"/> <tx:method name="list*" read-only="true"/> <tx:method name="insert*" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="create*" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="save*" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="submit*" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="update*" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="modify*" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="del*" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="remove" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="do*" read-only="false" propagation="REQUIRED" rollback-for="Throwable" /> <tx:method name="*" read-only="true"/> </tx:attributes> </tx:advice>  <aop:config> <aop:pointcut id="serviceOperation" expression="execution(* org.walkframework.base.mvc.service.*.*.*(..)) or execution(* org.walkframework.base.mvc.service.*.*.*.*(..)) or execution(* com.asiainfo.walk.*.mvc.service.*.*.*(..)) or execution(* com.asiainfo.walk.*.mvc.service.*.*.*.*(..))" /> <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceOperation" /> </aop:config> ``` **注意：** 當數據庫是mysql時，如果發現方法開頭也對，代碼任何地方也沒問題，但事務始終就是不生效時，這時就要注意下表的存儲引擎類型了，MyISAM是不支持事務的，可考慮改成InnoDB類型