数据库 MariaDB 10.11.3
企业网盘 查看全部文件时抛出
[SQL] 纯文本查看 复制代码 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' {prepstmnt 1887663807 SELECT t0.xid FROM FILE_FOLDER2 t0 WHERE (t0.xperson = ? AND t0.xstatus = ? AND t0.xsuperior = ?)} [code=1267, state=HY000]
详细报错日志如下
org.apache.openjpa.persistence.PersistenceException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' {prepstmnt 1818637464 SELECT t0.xid FROM FILE_FOLDER2 t0 WHERE (t0.xperson = ? AND t0.xstatus = ? AND t0.xsuperior = ?)} [code=1267, state=HY000]
at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5326) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:162) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2235) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:42) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~[openjpa-3.2.2.jar:3.2.2]
at com.x.file.assemble.control.factory.Folder2Factory.listTopWithPerson(Folder2Factory.java:37) ~[classes/:?]
at com.x.file.assemble.control.jaxrs.folder2.ActionListTop.execute(ActionListTop.java:23) ~[classes/:?]
at com.x.file.assemble.control.jaxrs.folder2.Folder2Action.listTop(Folder2Action.java:118) ~[classes/:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) ~[jaxrs-ri-2.35.jar:2.35.]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1633) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at com.x.base.core.project.jaxrs.CipherManagerUserJaxrsFilter.doFilter(CipherManagerUserJaxrsFilter.java:51) ~[x_base_core_project.jar:?]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:114) ~[druid-1.2.14.jar:?]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:561) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:766) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at java.lang.Thread.run(Thread.java:834) ~[?:?]
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' {prepstmnt 1818637464 SELECT t0.xid FROM FILE_FOLDER2 t0 WHERE (t0.xperson = ? AND t0.xstatus = ? AND t0.xsuperior = ?)} [code=1267, state=HY000]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1171) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1870) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:531) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:423) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:477) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:259) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:248) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~[openjpa-3.2.2.jar:3.2.2]
... 80 more
| 
[信息未更新]
