Click here to Skip to main content
15,868,141 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Java
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


Java
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();
             }
        }
    }
Posted
Updated 20-Jan-14 21:58pm
v2

1 solution

Quote:
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


This bug happens when more than one installation of a MySQL Server is installed, e.g. the previous installation was not completely removed. Another reason may be that the
MySQL Server 6 Branch was abandoned a long time ago and they recommend to use version 5.6[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900