Write operations are not allowed in read-only mode (FlushMode.MANUAL): Turn your Session into FlushMode.COMMIT/AUTO or remove 'readOnly' marker from transaction definition.
在使用hibernate模板对数据库进行读写操作时，有时会遇到删除、写入操作受限，对于这种异常，可以多种办法解决，
首先你测试先一下是添加受限，还是删除受限，如果添加和删除有一个可以成功，那么错误可能是：
第一）种错误，没有给对应方法配置权限，
<props>
<prop key="save*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="do*">PROPAGATION_REQUIRED</prop>
<prop key="recv*">PROPAGATION_REQUIRED</prop>
<prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
第二）种错误，在Dao层中添加，删除方法错误，请测试查看异常
如果添加和删除都不成功，那么很有可能就是权限问题了，请继续看，以下办法可以解决
1）第一种在Dao层更改 session.setFlushMode(FlushMode.AUTO)；
操作如下：
//注入 hibernateTemplate
private HibernateTemplate hibernateTemplate;
//生成get（）,set（）方法
public HibernateTemplate getHibernateTemplate()
{
return hibernateTemplate;
}
public void setHibernateTemplate(HibernateTemplate hibernateTemplate)
{
this.hibernateTemplate = hibernateTemplate;
}
/**
* 根据id删除记录
* @param id
*/
@Transactional("txManager")
public int removeUser(Integer id)
{
// 1.参数检测
if (index != null && hibernateTemplate != null&& hibernateTemplate.getSessionFactory() != null)
{
// 2.取得sission
Session session = hibernateTemplate.getSessionFactory()
.getCurrentSession();
if (session != null)
{
//2.1 设置session属性
session.setFlushMode(FlushMode.AUTO);
// 2.2删除该id的对象
Query query = session.createQuery("from User where id ="
+ id);
Comment comment = null;
//3 非空检查
if (query != null)
{
if (query.list().size() > 0)
{
user = (Comment) (query.list().get(0));
// 4.1删除该对象
hibernateTemplate.delete(user);
// 4.2清理缓存
session.flush();
//返回一个表示，成功返回1，失败返回0
return 1;
}
}
}
}
return 0;
}
2 ) 第二种在配置文件web.xml和applicationContext.xml中更改
web.xml文件
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaeehttp://java.sun.com/xml/ns/javaee/web-app_3_0.xsd" id="WebApp_ID" version="3.0"> <display-name>Doshare</display-name> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <filter> <filter-name>OpenSessionInViewFilter</filter-name> <filter-class> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter </filter-class> <init-param> <param-name>sessionFactoryBeanName</param-name> <param-value>sessionFactory</param-value> </init-param> <init-param> <param-name>singleSession</param-name> <param-value>true</param-value> </init-param> <init-param> <param-name>flushMode</param-name> <param-value>AUTO </param-value> </init-param> </filter> <filter-mapping> <filter-name>OpenSessionInViewFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <jsp-config> <jsp-property-group> <display-name>JSPConfiguration</display-name> <url-pattern>*.htm</url-pattern> <el-ignored>true</el-ignored> <page-encoding>UTF-8</page-encoding> <scripting-invalid>false</scripting-invalid> </jsp-property-group> <jsp-property-group> <display-name>JSPConfiguration</display-name> <url-pattern>*.jsp</url-pattern> <el-ignored>false</el-ignored> <page-encoding>UTF-8</page-encoding> <scripting-invalid>false</scripting-invalid> </jsp-property-group> </jsp-config> <!-- Struts2 核心过滤器 --> <filter> <filter-name>struts2</filter-name> <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class> </filter> <filter-mapping> <filter-name>struts2</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- Spring 監聽器 --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> </web-app>
applicationContext.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"
xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context-4.0.xsd">
<!-- 指定C3P0连接池 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="org.mariadb.jdbc.Driver"></property>
<property name="jdbcUrl"
value="jdbc:mysql://localhost:3308/test?userUnicode=true&characterEncoding=UTF-8"></property>
<!--数据库用户名和密码-->
<property name="user" value="root"></property>
<property name="password" value="123456"></property>
<!--最大连接数-->
<property name="maxPoolSize" value="500"></property>
<!--最小连接数-->
<property name="minPoolSize" value="5"></property>
<!-- 保持MySQL连接 -->
<property name="preferredTestQuery" value="SELECT 1"></property>
</bean>
<!-- 使用Spring管理Hibernate -->
<bean id="sessionFactory"
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!-- Hibernate的属性 -->
<property name="hibernateProperties">
<props>
<!-- 连接池自动重连 -->
<prop key="hibernate.connection.autoReconnectForPools">true</prop>
<!-- 连接编码 -->
<prop key="hibernate.connection.characterEncoding">UTF-8</prop>
<!-- 方言 -->
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<!-- showsq -->
<prop key="hibernate.show_sql">true</prop>
<!-- 避免JDBC出错，仅限于MySQL -->
<prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop>
<!-- 自动创建表 -->
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.current_session_context_class">org.springframework.orm.hibernate4.SpringSessionContext
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/doshr/xmen/app/server/bean/Comment.hbm.xml</value>
<value>com/doshr/xmen/app/server/bean/WeChatFriend.hbm.xml</value>
<value>com/doshr/xmen/app/server/bean/Address.hbm.xml</value>
<value>com/doshr/xmen/app/server/bean/Propertyes.hbm.xml</value>
</list>
</property>
</bean>
<!-- 配置Spring的Hibernate模板 -->
<bean id="hibernateTemplate" class="org.springframework.orm.hibernate4.HibernateTemplate">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>
<!-- 配置Spring事务管理器 -->
<bean id="txManager"
class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>
<!-- 配置事務攔截器 -->
<bean id="txInterceptor"
class="org.springframework.transaction.interceptor.TransactionInterceptor">
<property name="transactionManager">
<ref bean="txManager" />
</property>
<property name="transactionAttributes">
<props>
<prop key="save*">PROPAGATION_REQUIRED</prop>
<prop key="update*">PROPAGATION_REQUIRED</prop>
<prop key="delete*">PROPAGATION_REQUIRED</prop>
<prop key="do*">PROPAGATION_REQUIRED</prop>
<prop key="recv*">PROPAGATION_REQUIRED</prop>
<prop key="find*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>
<!-- 事务代理 -->
<bean
class="org.springframework.aop.framework.autoproxy.BeanNameAutoProxyCreator">
<property name="interceptorNames">
<list>
<value>txInterceptor</value>
</list>
</property>
<property name="beanNames">
<list>
<value>*Dao</value>
<value>*Service</value>
</list>
</property>
</bean>
</beans>
3)第三种写一个过滤器，让类（继承）extends
org.springframework.orm.hibernate4.support.OpenSessionInViewFilter 重写方法
<!--结束-->
有问题的或者异常的，请说明信息，一起讨论
![[Error] ‘for‘ loop initial declarations are only allowed in C99 or C11 mode 解决方法](https://ucc.alicdn.com/images/user-upload-01/2021022718274711.png?x-oss-process=image/resize,h_160,m_lfit)
![[Error] ‘for‘ loop initial declarations are only allowed in C99 mode](https://ucc.alicdn.com/images/user-upload-01/img_convert/45e886c36126f909b65535693c185792.png?x-oss-process=image/resize,h_160,m_lfit)
