java ssm web项目报 Unknown system variable 'tx_read_only'错 在线等 急
来源:互联网 发布:云计算软件有哪些 编辑:程序博客网 时间:2024/06/06 13:54
最近在做项目的时候搭好框架之后做了一个测试的流程,只涉及到查询并没有问题。真正开始做项目是涉及到查询的还是没问题,但是涉及到增删改时就报以下错:
### Cause: java.sql.SQLException: Could not retrieve transation read-only status server
; SQL []; Could not retrieve transation read-only status server; nested exception is java.sql.SQLException: Could not retrieve transation read-only status server] with root cause
java.sql.SQLException: Unknown system variable 'tx_read_only'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3541)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3516)
at com.mysql.jdbc.PreparedStatement.checkReadOnlySafeStatement(PreparedStatement.java:1113)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1133)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
之前查了下,说是mysql6.0版本的只能和mysql-connector-java-5.1.41-bin.jar的包匹配,换了之后还是不行,求大神帮忙。项目配置如下:
spring-mybatis:
<context:component-scan base-package="com.supermark" />
<!-- 引入配置文件 -->
<bean id="propertyConfigurer"
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location" value="classpath:config/jdbc.properties" />
</bean>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
<property name="driverClassName" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
<!-- 初始化连接大小 -->
<property name="initialSize" value="${initialSize}"></property>
<!-- 连接池最大数量 -->
<property name="maxActive" value="${maxActive}"></property>
<!-- 连接池最大空闲 -->
<property name="maxIdle" value="${maxIdle}"></property>
<!-- 连接池最小空闲 -->
<property name="minIdle" value="${minIdle}"></property>
<!-- 获取连接最大等待时间 -->
<property name="maxWait" value="${maxWait}"></property>
</bean>
<!-- spring和MyBatis完美整合,不需要mybatis的配置映射文件 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<!-- 自动扫描mapping.xml文件 -->
<property name="mapperLocations" value="classpath:com/supermark/mapping/*.xml"></property>
</bean>
<!-- DAO接口所在包名,Spring会自动查找其下的类 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.supermark.mapper" />
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
</bean>
<!-- (事务管理)transaction manager, use JtaTransactionManager for global tx -->
<!-- 配置事务管理器 -->
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<!-- 注解方式配置事务 -->
<tx:annotation-driven transaction-manager="transactionManager" />
spring-mvc.xml
<!-- 开启注解模式 -->
<mvc:annotation-driven>
<mvc:message-converters>
<bean class="org.springframework.http.converter.StringHttpMessageConverter" />
<bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter" />
</mvc:message-converters>
</mvc:annotation-driven>
<!-- 自动引入注解的handlermapping类 -->
<context:annotation-config />
<!-- 指定需要扫描的包 -->
<context:component-scan base-package="com.supermark" />
<!-- 配置视图解析器 -->
<bean
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/" />
<property name="suffix" value=".jsp" />
</bean>
web.xml
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!-- 编码过滤器 中文乱码处理 -->
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<async-supported>true</async-supported>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- Spring监听器 -->
<!-- 防止Spring内存溢出监听器 -->
<listener>
<listener-class>org.springframework.web.util.IntrospectorCleanupListener</listener-class>
</listener>
<!-- Spring和mybatis的配置文件 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:config/spring-mybatis.xml</param-value>
</context-param>
<!-- Spring MVC servlet -->
<servlet>
<servlet-name>SpringMVC</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:config/spring-mvc.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
<async-supported>true</async-supported>
</servlet>
<servlet-mapping>
<servlet-name>SpringMVC</servlet-name> <!-- 此处可以可以配置成*.do,对应struts的后缀习惯 -->
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<welcome-file-list>
<welcome-file>/index.jsp</welcome-file>
</welcome-file-list>
<!-- 配置SESSION超时,单位是分钟 -->
<session-config>
<session-timeout>15</session-timeout>
</session-config>
CodeMapper.xml
<mapper namespace="com.supermark.mapper.ICodeMapper">
<resultMap type="com.supermark.entity.CodeInfo" id="codeId">
<id column="codeId" property="codeId" />
<result column="codePhone" property="codePhone"/>
<result column="codeTime" property="codeTime"/>
<result column="codeNumber" property="codeNumber"/>
</resultMap>
<!-- 插入短信验证记录 -->
<insert id="inserCodeInfo" parameterType="com.supermark.entity.CodeInfo" useGeneratedKeys="true" keyProperty="codeId">
insert into codeInfo(codePhone,codeTime,codeNumber) values(${codePhone}, ${codeTime}, ${codeNumber})
</insert>
<!-- 查询当前号码与当前时间验证的次数 -->
<select id="selectQueryByPhoneTime" resultType="int">
select IFNULL((select codeNumber from codeInfo where codePhone = #{phone, jdbcType=VARCHAR} and codeTime = #{codeTime, jdbcType=VARCHAR}) ,0);
</select>
<!-- 修改当前号码与当前时间验证的次数-->
<update id="updateQueryByCodeNumber">
update codeInfo set codeNumber = codeNumber + 1 where codePhone = #{phone, jdbcType=VARCHAR} and codeTime = #{codeTime, jdbcType=VARCHAR}
</update>
ICodeMapper.java
public interface ICodeMapper {
public int inserCodeInfo(CodeInfo code);
public int selectQueryByPhoneTime(@Param("phone")String phone, @Param("codeTime")String codeTime);
public int updateQueryByCodeNumber(@Param("phone")String phone, @Param("codeTime")String codeTime);
}
controller
@RequestMapping("codeSMS")
@ResponseBody
public String codeSMSRegister(HttpServletRequest request,
HttpServletResponse response,String name, String phone)throws ApiException{
String codeTime;
SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
codeTime = sdf.format(new Date());
int num = codeservice.selectQueryByPhoneTime(phone, codeTime);
if(num >= 3){
return "-1";
}else if(num == 0){
codeservice.inserCodeInfo(new CodeInfo("", phone, codeTime, 1));
return HttpRequestUtil.codeSMS(request, response, name,
RandomCode.randCodeSMSData(request, response), phone);
}else{
codeservice.updateQueryByCodeNumber(phone, codeTime);
return HttpRequestUtil.codeSMS(request, response, name,
RandomCode.randCodeSMSData(request, response), phone);
}
}
- java ssm web项目报 Unknown system variable 'tx_read_only'错 在线等 急
- java连接数据库报错Unknown system variable 'tx_read_only'
- Unknown system variable 'tx_read_only'
- Unknown system variable 'tx_read_only'
- java.sql.SQLException: Unknown system variable 'tx_read_only'
- Mysql连接报错:Unknown system variable 'language'
- java.sql.SQLException: Unknown system variable 'language'
- java.sql.SQLException: Unknown system variable 'language'
- java.sql.SQLException: Unknown system variable 'language'
- Unknown system variable 'language'
- Unknown system variable 'lower_case_table_names'”
- Unknown system variable 'language'
- ASP.NET,急,急,急,在线等
- mysql java.sql.SQLException: Unknown system variable 'language'
- mysql连接错误java.sql.SQLException: Unknown system variable 'language'
- mysql java.sql.SQLException: Unknown system variable 'language
- mysql java.sql.SQLException: Unknown system variable 'language'
- mysql java.sql.SQLException: Unknown system variable 'language
- Hadoop系列之DistributedCache用法
- qt实现串口,UDP,TCP与嵌入式通信上位机软件
- opencv实现Sobel 算子
- 使用hexo搭建github.io博客
- mysql分表
- java ssm web项目报 Unknown system variable 'tx_read_only'错 在线等 急
- C++中cout输出十六进制数
- 关于使用vs2012学习《head first c# 第三版》第一章中遇到问题及解决方案
- 利用Service组件播放音乐的案例.txt
- 饭卡 hdu2546
- 一个UML图的例子
- 简单的遍历拓展
- 软件测试第三节课总结
- 分布式系统事务一致性解决方案