tomcat连接mysql数据库拒绝_JDBC连接mysql数据库测试的时候可以连接上，但是在Tomcat里面就连接不上了，不知道为啥？...

最新推荐文章于 2023-04-27 16:35:17 发布

秋雨随云

最新推荐文章于 2023-04-27 16:35:17 发布

阅读量426

点赞数

文章标签： tomcat连接mysql数据库拒绝

本文链接：https://blog.csdn.net/weixin_31653453/article/details/113684729

版权

在尝试使用Tomcat连接MySQL数据库时遇到异常：'Unknown character set index for field '255' received from server.'，导致无法成功建立连接。错误出现在com.mysql.jdbc.Connection类的getCharsetNameForIndex方法中。问题可能与字符集设置有关，同时在Tomcat环境中出现NullPointerException，具体发生在mDao的findPaging方法。在独立Java文件测试时连接正常，但在Tomcat环境下出现错误，提示需要检查数据库配置、字符集设置以及应用上下文环境。

摘要由CSDN通过智能技术生成

java.sql.SQLException: Unknown character set index for field '255' received from server.

at com.mysql.jdbc.Connection.getCharsetNameForIndex(Connection.java:1679)

at com.mysql.jdbc.Field.(Field.java:161)

at com.mysql.jdbc.MysqlIO.unpackField(MysqlIO.java:510)

at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:285)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1325)

at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1224)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2248)

at com.mysql.jdbc.Connection.execSQL(Connection.java:2196)

at com.mysql.jdbc.Statement.executeQuery(Statement.java:1163)

at com.mysql.jdbc.Connection.loadServerVariables(Connection.java:3419)

at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:3254)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:1803)

at com.mysql.jdbc.Connection.(Connection.java:450)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)

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

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at com.bmd.util.DbUtil.(DbUtil.java:15)

at com.bmd.dao.mDao.findPaging(mDao.java:161)

at com.bmd.service.MessageServlet.doPost(MessageServlet.java:75)

at com.bmd.service.MessageServlet.doGet(MessageServlet.java:28)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at com.bmd.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:35)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)

at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:531)

at org.apache.jsp.index_jsp._jspService(index_jsp.java:129)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:444)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:386)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:330)