ERROR Connection is readonly. venus224 ITeye技术网站

发布时间：2022-07-05 文章分类：编程知识 投稿人：王小丽 字号： 默认 | 大 | 超大 打印

ERROR - Connection is read-only.

    博客分类：

  • j2ee
SQLJavaHibernateJDBC
今天在serviceImpl的查询中,调用了一样更新的操作!

结果出现如下错误!

Java代码
  1. ERROR-Connectionisread-only.Queriesleadingtodatamodificationarenotallowed
  2. org.springframework.jdbc.UncategorizedSQLException:Hibernateoperation:couldnotexecuteupdatequery;uncategorizedSQLExceptionforSQL[updatet_nodesetfact_people=1wherenode_id='200825000001'andenterprise_id=200825];SQLstate[S1009];errorcode[0];Connectionisread-only.Queriesleadingtodatamodificationarenotallowed;nestedexceptionisjava.sql.SQLException:Connectionisread-only.Queriesleadingtodatamodificationarenotallowed
  3. Causedby:java.sql.SQLException:Connectionisread-only.Queriesleadingtodatamodificationarenotallowed
ERROR - Connection is read-only. Queries leading to data modification are not allowed
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute update query; uncategorized SQLException for SQL [update t_node set fact_people=1 where node_id='200825000001' and enterprise_id=200825]; SQL state [S1009]; error code [0]; Connection is read-only. Queries leading to data modification are not allowed; nested exception is java.sql.SQLException: 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

检查代码,没有问题!

忽然想到配置文件上,查询的话,是只读的!

Java代码
  1. <propkey="query*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="query*">PROPAGATION_REQUIRED,readOnly</prop>

只要把它改为

Java代码
  1. <propkey="query*">PROPAGATION_REQUIRED</prop>
<prop key="query*">PROPAGATION_REQUIRED</prop>

再做更新和查询,没有问题了!:)

标签 , ,