Mysql中关于Could not retrieve transation read-only status server
来源:互联网 发布:spss软件怎么用 编辑:程序博客网 时间:2024/05/16 23:52
在Myeclipse中报错:
Exception in thread "main" java.sql.SQLException: Could not retrieve transation read-only status server
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3939)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3910)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2410)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)
at dateTest.create(dateTest.java:33)
at dateTest.main(dateTest.java:13)
Caused by: java.sql.SQLException: Unknown system variable 'tx_read_only'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2761)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3933)
... 6 more
连接数据库书出现以上的错误,换了一些mysql不同版本的jar包就好了,这是mysql数据库与觉得不错版本的兼容问题,我电脑上安装的是mysql6.0,jdbc用的是5.1.6的版本,换了一下其他的就OK了。
- Mysql中关于Could not retrieve transation read-only status server
- Mysql中关于Could not retrieve transation read-only status server
- Mysql中关于Could not retrieve transation read-only status server
- Could not retrieve transation read-only status server
- Could not retrieve transation read-only status server
- 报错 Could not retrieve transation read-only status server
- Could not retrieve transation read-only status server
- Could not retrieve transation read-only status server
- Could not retrieve transation read-only status server错误
- mysql 报错Could not retrieve transation read-only status server
- java.sql.SQLException: Could not retrieve transation read-only status server
- Cause: java.sql.SQLException: Could not retrieve transation read-only status server
- 解决java.sql.SQLException: Could not retrieve transation read-only status server
- java.sql.SQLException: Could not retrieve transation read-only status server
- SSH环境mysql6.0报错Could not retrieve transation read-only status server
- 解决: ERROR JDBCExceptionReporter:78 - Could not retrieve transation read-only status server
- Could not retrieve transation read-only status server Query: insert into
- 数据库连接丢失,重连 Cause: java.sql.SQLException: Could not retrieve transation read-only status server
- 几大芯片商布局浮出水面
- Android中的PopupWindow详解-FenGKun
- 那么多技术,作为一个freshman,该学习什么?
- UML建模之时序图
- 软件工程导论学习-形式化说明技术
- Mysql中关于Could not retrieve transation read-only status server
- linux(ubutu)mysql的安装配置
- java继承的构造函数调用顺序
- OpenCv中使用Sobel算子
- Linux系统所有用户命令操作
- 数据库中的索引
- 软件体系架构模式在 J2EE 中的应用
- CPU与单片机的复位电路的作用及基本复位方式
- Linux C语言 格式化输出时间函数 strftime()