                        课程
                    
                        /后端开发
                        
                            /Java
                        
                        /使用java构建和维护接口自动化测试框架

post请求发生错误500错误

1. http://localhost:8080/Imooc/访问正常

2. mysql服务已启，除了配置文件的数据库root密码和老师的不一样其他都是一样的。

3. 为什么请求的时候会报500的错误？

慕姐8417444

2018-06-04

源自：使用java构建和维护接口自动化测试框架 2-1

关注问题我要回答

9076

操作

收起

2 回答

莫名路过
2018-08-30

不如去百度一下500错误的意思，代码出错了

0 回复有任何疑惑可以回复我~

收起回答

慕姐8417444 提问者
2018-06-04

Mon Jun 04 19:35:38 CST 2018

HTTP/1.1 500 Internal Server Error

<html><head><title>Apache Tomcat/7.0.88 - Error report</title><style></style> </head><body><h1>HTTP Status 500 - org.hibernate.exception.GenericJDBCException: Cannot open connection</h1><HR size="1" noshade="noshade">type Exception reportmessage org.hibernate.exception.GenericJDBCException: Cannot open connectiondescription The server encountered an internal error that prevented it from fulfilling this request.exception <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>root cause <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>root cause <pre>java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

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.checkErrorPacket(MysqlIO.java:935)

com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4101)

com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1300)

com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2337)

com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2370)

com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2154)

com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)

com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)

sun.reflect.GeneratedConstructorAccessor10.newInstance(Unknown Source)

sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

java.lang.reflect.Constructor.newInstance(Constructor.java:423)

com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:381)

com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)

java.sql.DriverManager.getConnection(DriverManager.java:664)

java.sql.DriverManager.getConnection(DriverManager.java:208)

org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)

org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)