- 客户区域:
- 查看工单
回复: 2
WEB 中间件不能连接使用 utf8mb4 字符集的 MySQL 数据库
问题分类: |
产品: 金笛短信中间件WEB版
-
MySQL 版本 5.7。
WEB中间件系统日志如下:
69780 2017-11-29 03:45:48,421 [1755659748@qtp0-2] ERROR cn.sendsms.jdsmsserver.web.DataSourceAction - 连接数据库时失败
java.sql.SQLException: Unknown initial character set index '224' received from server. Initial client character set can be forced via the 'characterEncoding' property.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Connection.configureClientCharacterSet(Connection.java:2412)
at com.mysql.jdbc.Connection.initializePropsFromServer(Connection.java:4139)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2789)
at com.mysql.jdbc.Connection.<init>(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at cn.sendsms.jdsmsserver.web.DatabaseCreator.connect(Unknown Source)
at cn.sendsms.jdsmsserver.web.DatabaseCreator.initDataBase(Unknown Source)
at cn.sendsms.jdsmsserver.web.DataSourceAction.initDatabase(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at cn.sendsms.jdsmsserver.web.JDWebAction.invoke(Unknown Source)
at cn.sendsms.jdsmsserver.web.JDWebAction.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)
at org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:864)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:533)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:207)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:403)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)
at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:522)2673天23小时以前 IP地址: 103.37.140.10 -
王警宇2673天23小时以前 -
范敬成尊敬的客户您好:
通过分析您提交的日志分析,可能通过升级mysql jar包来解决,此包路径
为/JDSmsService-web366/lib/mysql-connector-java-5.0.8-bin.jar
请把mysql-connector-java-5.0.8-bin.jar替换成mysql官网上最新版本的jar包;
2673天23小时以前
王警宇