jpress连接不上mysql_今天用jpress架网站,数据库连不上

在尝试安装第三方程序的数据库部分时遇到了一个错误,具体表现为使用mysql驱动执行批量更新操作时抛出了BatchUpdateException,提示未知字符集'utf8mb4'。尝试将mysql驱动回退到5.5之前的版本,但问题仍然存在。博主提到以前使用其他版本驱动连接数据库没有问题。解决方案可能涉及检查数据库配置、JDBC连接字符串或者数据库版本与驱动的兼容性。
摘要由CSDN通过智能技术生成

数据库 mysql

网站程序是第三方程序,安装数据库时报了异常,

2016-10-24 00:15:17

[ERROR]-[Thread: http-nio-8080-exec-2]-[io.jpress.install.InstallController.step2()]: InstallController step2 is erro

java.sql.BatchUpdateException: Unknown character set: 'utf8mb4'

at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:1184)

at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:2596)

at com.alibaba.druid.filter.FilterAdapter.statement_executeBatch(FilterAdapter.java:2474)

at com.alibaba.druid.filter.FilterEventAdapter.statement_executeBatch(FilterEventAdapter.java:279)

at com.alibaba.druid.filter.FilterChainImpl.statement_executeBatch(FilterChainImpl.java:2594)

at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeBatch(StatementProxyImpl.java:192)

at com.alibaba.druid.pool.DruidPooledStatement.executeBatch(DruidPooledStatement.java:568)

at io.jpress.install.InstallUtils.executeBatchSql(InstallUtils.java:172)

at io.jpress.install.InstallUtils.createJpressDatabase(InstallUtils.java:117)

at io.jpress.install.InstallController.step2(InstallController.java:81)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.jfinal.aop.Invocation.invoke(Invocation.java:73)

at io.jpress.install.InstallInterceptor.intercept(InstallInterceptor.java:36)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at io.jpress.core.interceptor.HookInterceptor.intercept(HookInterceptor.java:34)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at io.jpress.interceptor.AdminInterceptor.intercept(AdminInterceptor.java:36)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at io.jpress.interceptor.GlobelInterceptor.intercept(GlobelInterceptor.java:33)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at io.jpress.core.interceptor.JI18nInterceptor.intercept(JI18nInterceptor.java:48)

at com.jfinal.aop.Invocation.invoke(Invocation.java:67)

at com.jfinal.core.ActionHandler.handle(ActionHandler.java:74)

at io.jpress.core.MyDruidStatViewHandler.handle(MyDruidStatViewHandler.java:43)

at io.jpress.core.cache.ActionCacheHandler.handle(ActionCacheHandler.java:40)

at io.jpress.core.JHandler.handle(JHandler.java:81)

at io.jpress.core.cache.ActionCacheHandler.handle(ActionCacheHandler.java:40)

at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72)

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

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

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:784)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:802)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

按照别人的说法是 mysql 驱动 5.5 以后改成 utf8mb4编码了

我就把驱动改成了mysql5.5 更早版本的驱动,可是问题依旧。

况且 我以前自己写程序用任意版本的驱动连接数据库好好滴额。我这应该怎么做,

请各位大神赐教。。。。。小弟谢过了、

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值