永洪社区
标题: 错误代码 110099999 [打印本页]
作者: 血斗神星 时间: 2023-9-24 21:00
标题: 错误代码 110099999
错误代码:110099999
数据集: '咖啡中国市场销售数据20230924205133-46' 执行用户: 'admin'
java.lang.Exception: 数据集: '咖啡中国市场销售数据20230924205133-46' 执行用户: 'admin'
原因: 执行SQL失败:“Unknown column '??' in 'field list'”
at g5.qry.queryPool.QueryRunnable2.init(QueryRunnable2.java:32)
at g5.qry.queryPool.QueryRunnable.run(QueryRunnable.java:76)
at g5.thread.ThreadPoolWithChecker$GThread.run0(ThreadPoolWithChecker.java:223)
at g5.thread.AbsThreadPool$PThread.run(AbsThreadPool.java:325)
错误代码:110099999
数据集: '咖啡中国市场销售数据20230924205133-46' 执行用户: 'admin'
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'test.????' doesn't exist
at jdk.internal.reflect.GeneratedConstructorAccessor526.newInstance(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:403)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1915)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2023)
at g5.qry.sql.proxy.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:28)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at g5.qry.sql.connection.proxy.statement.ProxyStatement$StatementInvocationHandler.invoke(ProxyStatement.java:417)
at com.sun.proxy.$Proxy37.executeQuery(Unknown Source)
at g5.qry.sql.connection.proxy.statement.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:32)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at g5.qry.sql.connection.proxy.statement.ProxyStatement$StatementInvocationHandler.invoke(ProxyStatement.java:417)
at com.sun.proxy.$Proxy38.executeQuery(Unknown Source)
at g5.qry.sql.connection.proxy.statement.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:32)
at jdk.internal.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at g5.qry.jdbc.JDBCExecutor$StatementInvocationHandler.invoke(JDBCExecutor.java:2223)
at com.sun.proxy.$Proxy45.executeQuery(Unknown Source)
at g5.qry.jdbc.JDBCExecutor.getRS(JDBCExecutor.java:1705)
at g5.qry.jdbc.JDBCExecutor.executeForMeta(JDBCExecutor.java:2128)
at g5.qry.jdbc.JDBCExecutor.customizeMetaCols(JDBCExecutor.java:586)
at g5.qry.jdbc.JDBCExecutor.metaColsQry(JDBCExecutor.java:493)
at g5.qry.jdbc.JDBCExecutor.metaCols(JDBCExecutor.java:83)
at g5.qry.sql.SQLQuery.metaCols(SQLQuery.java:79)
at g5.sv.qry.req.GetQryMetaReq.process0(GetQryMetaReq.java:97)
at g5.sv.Req.process(Req.java:57)
at g5.sv.qry.impl.QueryServiceImpl.process(QueryServiceImpl.java:207)
at g5.sv.qry.QueryProc.procReq(QueryProc.java:134)
at g5.sv.qry.QueryProc.service(QueryProc.java:62)
at g5.sv.ServletHelper.service(ServletHelper.java:122)
at g5.sv.PortalServlet.service(PortalServlet.java:1464)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1391)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:760)
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 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:536)
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:1589)
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1296)
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:1559)
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1211)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
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:386)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:560)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:378)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:268)
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.QueuedThreadPool.runJob(QueuedThreadPool.java:782)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:914)
at java.base/java.lang.Thread.run(Thread.java:834)
数据集: '咖啡中国市场销售数据20230924205133-46' 执行用户: 'admin'原因: 执行SQL失败:“Unknown column '??' in 'field list'”
Table 'test.????' doesn't exist
我想试着链接MySQL数据库中自己的表,为什么显示这个错误?我该怎么解决?
作者: yhdata_yzm 时间: 2023-9-24 21:00
你在数据源的url后边加这一部分,看起来是编码问题?useUnicode=true&characterEncoding=utf8
作者: yhdata_yzm 时间: 2023-9-25 09:52
你是把咖啡的数据导入你自己的数据库了?
看看数据库的编码是不是utf-8呢,
使用的用户是否有对应的权限
作者: 血斗神星 时间: 2023-9-25 09:55
我看下,我是用root账户登录的,我是在添加数据源那里添加了自己的MySQL数据库 字符集和排序规则是utf8mb4
utf8mb4_german2_ci
作者: yhdata_yzm 时间: 2023-9-25 09:57
root用户有这个表的权限吗
作者: 血斗神星 时间: 2023-9-25 11:44
有啊,我就这一个root管理员账户
作者: 血斗神星 时间: 2023-9-25 11:46
这个刷新数据不支持中文么??我看演示里面刷新数据的时候有中文啊( TдT)
作者: 血斗神星 时间: 2023-9-25 11:52
(, 下载次数: 66)