Question

s2sh数据库更新报错Hibernate flushing: Could not execute JDBC batch update;Connection is read-only

org.springframework.dao.TransientDataAccessResourceException: Hibernate flushing: Could not execute JDBC batch update; SQL [update user set user_create_time=?, user_email=?, user_level=?, user_name=?, user_password=?, user_phone_number=?, user_sex=?, user_update_time=? where user_id=?]; Connection is read-only. Queries leading to data modification are not allowed; nested exception is java.sql.SQLException: Connection is read-only.

Answer 1

Java代码
<prop key="query*">PROPAGATION_REQUIRED,readOnly</prop>
只要把它改为
Java代码
<prop key="query*">PROPAGATION_REQUIRED</prop>
再做更新和查询,没有问题了!

Answer 2

你的方法要与spring配置的事物切面方法一致，类似于update*开头的配置

Answer 3

session 打开了吗？ 还有就是看你的连接对了吗