Connection is read-only. Queries leading to data modification are not allowed

详细错误:
Caused by: java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1552)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:93)
at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:56)

出现这个错误的原因是在spring的事务中把某个方法设置为read-only模式,但是在方法中却试图修改数据库,比如进行了save操作,如下面这个“get*”表示在service层以get开头的方法都是只读的,不能修改数据库,完整事务配置如下:

    <bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>

    <aop:config>
        <aop:pointcut id="bussinessService"
            expression="execution(public * com.coder.service..*.*(..))" />
        <aop:advisor pointcut-ref="bussinessService" advice-ref="txAdvice" />
    </aop:config>
    <aop:aspectj-autoproxy proxy-target-class="true"/>
    <tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="list*" read-only="true" />
            <tx:method name="find*" read-only="true" />
            <tx:method name="get*" read-only="true" />
            <tx:method name="check*" read-only="true" />
            <tx:method name="query*" read-only="true" />
            <tx:method name="delete*" propagation="REQUIRED" rollback-for="com.coder.zexception.ServerErrorException;" />
            <tx:method name="update*" propagation="REQUIRED" rollback-for="com.coder.zexception.ServerErrorException;" />
            <tx:method name="create*" propagation="REQUIRED" rollback-for="com.coder.zexception.ServerErrorException;" />
            <tx:method name="save*" propagation="REQUIRED" rollback-for="com.coder.zexception.ServerErrorException;" />
            <tx:method name="cancel*" propagation="REQUIRED" rollback-for="com.coder.zexception.ServerErrorException;" />
        </tx:attributes>
    </tx:advice>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值