ERROR Connection is readonly. venus224 ITeye技术网站
ERROR - Connection is read-only. - venus224 - ITeye技术网站
ERROR - Connection is read-only.
博客分类：
j2ee
SQLJavaHibernateJDBC
今天在serviceImpl的查询中,调用了一样更新的操作!
结果出现如下错误!
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
检查代码,没有问题!
忽然想到配置文件上,查询的话,是只读的!
<prop key="query*">PROPAGATION_REQUIRED,readOnly</prop>
只要把它改为
<prop key="query*">PROPAGATION_REQUIRED</prop>
再做更新和查询,没有问题了!:)