error in connection establish（ERROR Connection is readonly. venus224 ITeye技术网站）

时间2025-07-31 15:17:45分类IT科技浏览5651

导读：今天在serviceImpl的查询中,调用了一样更新的操作!...

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

结果出现如下错误!

Java代码

ERROR-Connectionisread-only.Queriesleadingtodatamodificationarenotallowed org.springframework.jdbc.UncategorizedSQLException:Hibernateoperation:couldnotexecuteupdatequery;uncategorizedSQLExceptionforSQL[updatet_nodesetfact_people=1wherenode_id=200825000001andenterprise_id=200825];SQLstate[S1009];errorcode[0];Connectionisread-only.Queriesleadingtodatamodificationarenotallowed;nestedexceptionisjava.sql.SQLException:Connectionisread-only.Queriesleadingtodatamodificationarenotallowed 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代码

<propkey="query*">PROPAGATION_REQUIRED,readOnly</prop>

<prop key="query*">PROPAGATION_REQUIRED,readOnly</prop>

只要把它改为

Java代码

<propkey="query*">PROPAGATION_REQUIRED</prop>

<prop key="query*">PROPAGATION_REQUIRED</prop>

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

声明：本站所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。