java.sql.SQLException：无法检索转换只读状态服务器错误 [英] java.sql.SQLException: Could not retrieve transation read-only status server error
本文介绍了java.sql.SQLException：无法检索转换只读状态服务器错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
嘿伙计们，
我需要知道以下错误以及我如何修复此错误。我试图卸载并安装我的sql server（6.0.3）的最新版本但是没有用。任何人都可以指导我解决这个问题吗？这是代码错误
Hey guys,
I need to know the following error and how I fix this error. I tried to uninstall and install latest version of my sql server (6.0.3) but did not work. Can anyone guide me to fix this problem? here is the code error
Using CATALINA_BASE: "C:\tomcat"
Using CATALINA_HOME: "C:\tomcat"
Using CATALINA_TMPDIR: "C:\tomcat\temp"
Using JRE_HOME: "C:\Program Files\Java\jdk1.7.0_45"
Using CLASSPATH: "C:\tomcat\bin\bootstrap.jar;C:\tomcat\bin\tomcat-juli.jar"
Jan 21, 2014 1:48:21 PM org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.29 using APR version 1.4.8.
Jan 21, 2014 1:48:22 PM org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
Jan 21, 2014 1:48:23 PM org.apache.catalina.core.AprLifecycleListener initializeSSL
INFO: OpenSSL successfully initialized (OpenSSL 1.0.1e 11 Feb 2013)
Jan 21, 2014 1:48:24 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-apr-8080"]
Jan 21, 2014 1:48:24 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-apr-8009"]
Jan 21, 2014 1:48:24 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3870 ms
Jan 21, 2014 1:48:24 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Jan 21, 2014 1:48:24 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.47
Jan 21, 2014 1:48:24 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor C:\tomcat\conf\Catalina\localhost\E-Learning.xml
Jan 21, 2014 1:48:27 PM org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor C:\tomcat\conf\Catalina\localhost\JavaEE_UOC.xml
Jan 21, 2014 1:48:28 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat\webapps\docs
Jan 21, 2014 1:48:28 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat\webapps\examples
Jan 21, 2014 1:48:30 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat\webapps\host-manager
Jan 21, 2014 1:48:30 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat\webapps\manager
Jan 21, 2014 1:48:31 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory C:\tomcat\webapps\ROOT
Jan 21, 2014 1:48:31 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-apr-8080"]
Jan 21, 2014 1:48:31 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-apr-8009"]
Jan 21, 2014 1:48:31 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 6708 ms
admin a001 123
admina001123
admina001123
inside LoginDetail
Welcome
Connected
SELECT * FROM user WHERE user_id='a001' and password='123' and user_position='admin'
a001 123 admin
admina001123
Inside addUser
ml 123 a002 admin
Inside rs.adduser
Inside search
Welcome
Connected
a002
false
======
null
===Inside rs.adduser
false
Inside save
Welcome
Connected
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:3936)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3907)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2408)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
at com.uoc.elearning.dao.userDAOImpl.save(userDAOImpl.java:125)
at com.uoc.elearning.service.userServiceImpl.adduser(userServiceImpl.java:45)
at com.uoc.elearning.web.userControllerServlet.addUser(userControllerServlet.java:170)
at com.uoc.elearning.web.userControllerServlet.doPost(userControllerServlet.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2430)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2419)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
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:4187)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)
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:2809)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2758)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1612)
at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3930)
... 30 more
public void save(user u) {
//throw new UnsupportedOperationException("Not supported yet."); //To change body of generated methods, choose Tools | Templates.
System.out.println("Inside save");
Connection conn = null;
PreparedStatement ptmt= null;
try {
conn = getConnection();
String queryString = "INSERT INTO user (user_id, password, user_position, name) VALUES(?,?,?,?)";
ptmt = conn.prepareStatement(queryString);
ptmt.setString(1,u.getid());
ptmt.setString(2,u.getpwrd());
ptmt.setString(3,u.getuserposition());
ptmt.setString(4,u.getUname());
int result = ptmt.executeUpdate();
System.out.println("result :" + result);
}
catch (Exception ex) {
ex.printStackTrace();
}
finally {
try {
ptmt.close();
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
推荐答案
AbstractConnectionHandler.process（AbstractProtocol.java： 603 ）
at org.apache.tomcat.util.net.AprEndpoint
AbstractConnectionHandler.process(AbstractProtocol.java:603) at org.apache.tomcat.util.net.AprEndpoint
SocketProcessor.doRun（AprEndpoint.java： 2430 ）
at org.apache.tomcat.util.net.AprEndpoint
SocketProcessor.doRun(AprEndpoint.java:2430) at org.apache.tomcat.util.net.AprEndpoint
SocketProcessor.run（AprEndpoint.java：< span class =code-digit> 2419 ）
at java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java: 1145 ）
at java.util.concurrent.ThreadPoolExecutor
SocketProcessor.run(AprEndpoint.java:2419) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor
这篇关于java.sql.SQLException：无法检索转换只读状态服务器错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
