为了账号安全，请及时绑定邮箱和手机立即绑定

java.sql.SQLException: Unknown system variable 'tx_isolation'

首页 猿问 java.sql.SQLExcep...

java.sql.SQLException: Unknown system variable 'tx_isolation'

Java
玄米茶的夏天 2020-04-22 11:53:53
CDSpace中发送post接口，报java.sql.SQLException: Unknown system variable 'tx_isolation'Wed Apr 22 11:45:03 CST 2020HTTP/1.1 500 Internal Server Error<html><head><title>Apache Tomcat/7.0.73 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 500 - org.hibernate.exception.GenericJDBCException: Cannot open connection</h1><HR size="1" noshade="noshade"><p><b>type</b> Exception report</p><p><b>message</b> <u>org.hibernate.exception.GenericJDBCException: Cannot open connection</u></p><p><b>description</b> <u>The server encountered an internal error that prevented it from fulfilling this request.</u></p><p><b>exception</b> <pre>javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Cannot open connection org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:614) org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:202) com.imooc.DAO.StudentDAO.findStudent(StudentDAO.java:27) com.imooc.DAO.StudentDAO.find(StudentDAO.java:69) com.imooc.service.StudentService.doPost(StudentService.java:69) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</pre></p><p><b>root cause</b> <pre>org.hibernate.exception.GenericJDBCException: Cannot open connection org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547) org.hibernate.loader.Loader.doQuery(Loader.java:673) org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) org.hibernate.loader.Loader.loadEntity(Loader.java:1860) org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049) org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399) org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182) com.imooc.DAO.StudentDAO.findStudent(StudentDAO.java:27) com.imooc.DAO.StudentDAO.find(StudentDAO.java:69) com.imooc.service.StudentService.doPost(StudentService.java:69) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</pre></p><p><b>root cause</b> <pre>java.sql.SQLException: Unknown system variable 'tx_isolation' com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569) com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1521) com.mysql.jdbc.ConnectionImpl.getTransactionIsolation(ConnectionImpl.java:3173) org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:115) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547) org.hibernate.loader.Loader.doQuery(Loader.java:673) org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236) org.hibernate.loader.Loader.loadEntity(Loader.java:1860) org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48) org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42) org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3049) org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:399) org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375) org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139) org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195) org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103) org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878) org.hibernate.impl.SessionImpl.get(SessionImpl.java:815) org.hibernate.impl.SessionImpl.get(SessionImpl.java:808) org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:182) com.imooc.DAO.StudentDAO.findStudent(StudentDAO.java:27) com.imooc.DAO.StudentDAO.find(StudentDAO.java:69) com.imooc.service.StudentService.doPost(StudentService.java:69) javax.servlet.http.HttpServlet.service(HttpServlet.java:650) javax.servlet.http.HttpServlet.service(HttpServlet.java:731) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)</pre></p><p><b>note</b> <u>The full stack trace of the root cause is available in the Apache Tomcat/7.0.73 logs.</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/7.0.73</h3></body></html>
查看完整描述

目前暂无任何回答

  • 0 回答
  • 0 关注
  • 1538 浏览
慕课专栏
更多

添加回答

了解更多

举报

0/150
提交
取消
意见反馈 帮助中心 APP下载
官方微信