5.2.5arm版本，数据库想改成mysql5.7,一直没成功

yanshenhao 发表于 2020-12-16 17:03:45

1.node_127.0.0.1.json的data改为false
2.externalDataSources.json配成mysql后
3.重启o2server
4.登录报错，信息如下
java.lang.NullPointerException
   at com.x.program.center.jaxrs.distribute.BaseAction.getRandomAssemblesFrom(BaseAction.java:131)
   at com.x.program.center.jaxrs.distribute.BaseAction.getRandomAssembles(BaseAction.java:125)
   at com.x.program.center.jaxrs.distribute.ActionAssemble.execute(ActionAssemble.java:14)
   at com.x.program.center.jaxrs.distribute.DistributeAction.assemble(DistributeAction.java:34)
   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 org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
   at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
   at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
   at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143)
   at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
   at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
   at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
   at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
   at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
   at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
   at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
   at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
   at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
   at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
   at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
   at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
   at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
   at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
   at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
   at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
   at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
   at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
   at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617)
   at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
   at com.x.base.core.project.jaxrs.AnonymousCipherManagerUserJaxrsFilter.doFilter(AnonymousCipherManagerUserJaxrsFilter.java:26)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
   at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
   at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
   at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
   at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
   at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)
   at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
   at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
   at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
   at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)
   at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
   at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
   at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
   at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59)
   at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:767)
   at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
   at org.eclipse.jetty.server.Server.handle(Server.java:500)
   at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
   at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
   at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
   at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
   at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
   at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
   at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
   at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
   at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
   at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
   at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
   at java.lang.Thread.run(Thread.java:748)

yanshenhao 发表于 2020-12-16 17:52:49

库里出现58张表，就是控制台报错，
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
   at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
   at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
   at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
   at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
页面起不来，具体全部日志信息在root.docx里，各位大佬、管理员帮忙看看

论坛管理员 发表于 2020-12-17 11:18:28

您好：我们推荐Mysql8
不过5.7也是支持的。
不过有时候不同的驱动可能有差异性。建议您可以尝试一下切换驱动。
请看文档：https://www.yuque.com/o2oa/course/xuwlyp

yanshenhao 发表于 2020-12-17 16:21:16

谢谢亲回复，o2oa自带的驱动是8.0.15的(commons/ext里),换成5.1.47的试了一下，externalDataSources.json里加了"driverClassName" : "com.mysql.jdbc.Driver",但是现在运行./start_arm.sh反倒没有反应了，不报错，也没反应

论坛管理员 发表于 2020-12-18 10:56:32

您使用默认数据库的时候是好的吗？

论坛管理员 发表于 2020-12-18 11:22:51

还有我看到您报错1366
出错原因：检查数据库此字段的字符集与整理字符集是否与SQL语句传递数据的字符集相同；不相同则会引发MySQL1366错误。
感觉是您数据库本身的问题，建议您针对1366的错误，先处理一下！
比如：
https://www.cnblogs.com/exceptioneye/p/4850845.htm

页: [1]

藕粉社区's Archiver

5.2.5arm版本，数据库想改成mysql5.7,一直没成功