AI 助理
备案控制台
开发者社区 > 数据库 > 正文

优炫数据库，数据集sql定义 执行时，druid 库报错

数据集定义语句：

select GROUP_CONCAT(name SEPARATOR ',') from tuser

jar版本：druid-1.2.11.jar

日志报错信息：

##|2024-10-11 11:59:14.265|INFO|javax.enterprise.system.std|_ThreadID=102;_ThreadName=httpWorkerThread-18080-4|2024-10-11 11:59:14,264 64554326 WARN  [httpWorkerThread-18080-4] (SQLUtils.java:354) com.alibaba.druid.sql.SQLUtils - rowFormat error
com.alibaba.druid.sql.parser.ParserException: syntax error, expect ), actual IDENTIFIER pos 34, line 1, column 26, token IDENTIFIER SEPARATOR
        at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:4562) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLExprParser.methodRest(SQLExprParser.java:1912) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:6231) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:1052) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:462) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:61) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLStatementParser.parseSelect(SQLStatementParser.java:4341) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:200) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:101) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.SQLUtils.format(SQLUtils.java:351) [druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.SQLUtils.format(SQLUtils.java:344) [druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.SQLUtils.format(SQLUtils.java:332) [druid-1.2.11.jar:1.2.11]
        at com.apex.util.SQLUtil.format(SQLUtil.java:653) [classes/:?]
        at com.apex.form.helper.AbstractTransOperateExecuter.querySQL(AbstractTransOperateExecuter.java:376) [classes/:?]
        at com.apex.form.helper.OracleTransOperateExecuter.execQuery(OracleTransOperateExecuter.java:102) [classes/:?]
        at com.apex.form.TransBuilder.getRowSet(TransBuilder.java:164) [classes/:?]
        at com.apex.form.context.QueryAccessMode.getRowset(QueryAccessMode.java:56) [classes/:?]
        at com.apex.form.context.AbstractPageModeContext.query(AbstractPageModeContext.java:282) [classes/:?]
        at com.apex.form.context.AbstractPageModeContext.query(AbstractPageModeContext.java:260) [classes/:?]
        at com.apex.form.context.AbstractPageModeContext.getRsRecord(AbstractPageModeContext.java:380) [classes/:?]
        at com.apex.livebos.ui.react.context.ReactQueryMode.process(ReactQueryMode.java:44) [classes/:?]
        at com.apex.form.ui.ServletProcessor.forwardPageModeContext(ServletProcessor.java:133) [classes/:?]
        at com.apex.form.ui.ServletProcessor.processPageModeContext(ServletProcessor.java:112) [classes/:?]
        at com.apexinfo.livecloud.server.core.livebos.servlet.UIProcessor.doGet(UIProcessor.java:65) [apexinfo-livecloud-server-core.jar:1.0.0.2024.09.29.17.39.03]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:630) [javaee.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:737) [javaee.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:229) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.security.LBSecurityFilterProxy.doFilter(LBSecurityFilterProxy.java:52) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.system.metrics.servlet.DefaultWebMvcMetricFilter.doFilter(DefaultWebMvcMetricFilter.java:65) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.abs.filters.CompressionFilter.doFilter(CompressionFilter.java:75) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.form.servlet.LogonFilter.doFilter(LogonFilter.java:240) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.bes.enterprise.web.websocket.server.WsFilter.doFilter(WsFilter.java:48) [bes-websocket.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apexinfo.livecloud.server.plugins.product.liveid.client.filter.ClientFilter.doFilter(ClientFilter.java:44) [apexinfo-livecloud-server-plugins-product-liveidclient.jar:1.0.0.2024.09.23.16.57.13]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apexinfo.livecloud.server.core.web.filter.FirstFilter.doFilter(FirstFilter.java:110) [apexinfo-livecloud-server-core.jar:1.0.0.2024.09.29.17.39.03]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.clustersupport.redis.session.SessionFilterProxy.doFilter(SessionFilterProxy.java:30) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultWrapperValve.invoke(DefaultWrapperValve.java:194) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultContextValve.invoke(DefaultContextValve.java:92) [bes-engine.jar:?]
        at com.bes.enterprise.webext.BesContextCleanupValve.invoke(BesContextCleanupValve.java:50) [bes-ee-integration.jar:?]
        at com.bes.enterprise.webext.BESAppservValve.invoke(BESAppservValve.java:41) [bes-ee-integration.jar:?]
        at com.bes.enterprise.webtier.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultHostValve.invoke(DefaultHostValve.java:136) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.valves.ErrorReportValve.invoke(ErrorReportValve.java:77) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultEngineValve.invoke(DefaultEngineValve.java:83) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) [bes-engine.jar:?]
        at com.bes.enterprise.web.crane.http11.Http11Processor.service(Http11Processor.java:671) [V9.5.5.6210.006.jar:?]
        at com.bes.enterprise.web.crane.AbstractProcessorLight.process(AbstractProcessorLight.java:61) [bes-webtier-coyote.jar:?]
        at com.bes.enterprise.web.crane.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:815) [bes-webtier-coyote.jar:?]
        at com.bes.enterprise.web.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732) [V9.5.5.6210.005.jar:?]
        at com.bes.enterprise.web.util.net.SocketProcessorBase.run(SocketProcessorBase.java:47) [bes-webtier-coyote.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_371]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_371]
        at com.bes.enterprise.web.util.threads.WorkThread$WrappingRunnable.run(WorkThread.java:57) [bes-webtier-util.jar:?]
        at java.lang.Thread.run(Thread.java:750) [?:1.8.0_371]
|##
##|2024-10-11 11:59:14.266|INFO|javax.enterprise.system.std|_ThreadID=191;_ThreadName=LBEventListenersContainer2|2024-10-11 11:59:14,266 64554328 DEBUG [LBEventListenersContainer2] (ApexDao.java:865) com.apex.util.ApexDao - previous sql executed in 2 ms.
|##
##|2024-10-11 11:59:14.267|INFO|javax.enterprise.system.std|_ThreadID=102;_ThreadName=httpWorkerThread-18080-4|2024-10-11 11:59:14,266 64554328 ERROR [httpWorkerThread-18080-4] (OracleTransOperateExecuter.java:108) com.apex.form.helper.OracleTransOperateExecuter - com.apex.util.DAOException: syntax error, expect ), actual IDENTIFIER pos 34, line 1, column 26, token IDENTIFIER SEPARATOR
com.apex.util.DAOException: syntax error, expect ), actual IDENTIFIER pos 34, line 1, column 26, token IDENTIFIER SEPARATOR
        at com.apex.form.helper.SQLQueryDao.getRowCount(SQLQueryDao.java:145) ~[classes/:?]
        at com.apex.util.ApexDao.getRowSet(ApexDao.java:630) ~[ApexUtil-6.0.1.jar:?]
        at com.apex.form.AbsDao.getRowSet(AbsDao.java:80) ~[classes/:?]
        at com.apex.form.helper.SQLQueryDao.getRowSet(SQLQueryDao.java:58) ~[classes/:?]
        at com.apex.form.helper.AbstractTransOperateExecuter.querySQL(AbstractTransOperateExecuter.java:408) ~[classes/:?]
        at com.apex.form.helper.OracleTransOperateExecuter.execQuery(OracleTransOperateExecuter.java:102) [classes/:?]
        at com.apex.form.TransBuilder.getRowSet(TransBuilder.java:164) [classes/:?]
        at com.apex.form.context.QueryAccessMode.getRowset(QueryAccessMode.java:56) [classes/:?]
        at com.apex.form.context.AbstractPageModeContext.query(AbstractPageModeContext.java:282) [classes/:?]
        at com.apex.form.context.AbstractPageModeContext.query(AbstractPageModeContext.java:260) [classes/:?]
        at com.apex.form.context.AbstractPageModeContext.getRsRecord(AbstractPageModeContext.java:380) [classes/:?]
        at com.apex.livebos.ui.react.context.ReactQueryMode.process(ReactQueryMode.java:44) [classes/:?]
        at com.apex.form.ui.ServletProcessor.forwardPageModeContext(ServletProcessor.java:133) [classes/:?]
        at com.apex.form.ui.ServletProcessor.processPageModeContext(ServletProcessor.java:112) [classes/:?]
        at com.apexinfo.livecloud.server.core.livebos.servlet.UIProcessor.doGet(UIProcessor.java:65) [apexinfo-livecloud-server-core.jar:1.0.0.2024.09.29.17.39.03]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:630) [javaee.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:737) [javaee.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:229) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.security.LBSecurityFilterProxy.doFilter(LBSecurityFilterProxy.java:52) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.system.metrics.servlet.DefaultWebMvcMetricFilter.doFilter(DefaultWebMvcMetricFilter.java:65) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.abs.filters.CompressionFilter.doFilter(CompressionFilter.java:75) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.form.servlet.LogonFilter.doFilter(LogonFilter.java:240) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.bes.enterprise.web.websocket.server.WsFilter.doFilter(WsFilter.java:48) [bes-websocket.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apexinfo.livecloud.server.plugins.product.liveid.client.filter.ClientFilter.doFilter(ClientFilter.java:44) [apexinfo-livecloud-server-plugins-product-liveidclient.jar:1.0.0.2024.09.23.16.57.13]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apexinfo.livecloud.server.core.web.filter.FirstFilter.doFilter(FirstFilter.java:110) [apexinfo-livecloud-server-core.jar:1.0.0.2024.09.29.17.39.03]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.clustersupport.redis.session.SessionFilterProxy.doFilter(SessionFilterProxy.java:30) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultWrapperValve.invoke(DefaultWrapperValve.java:194) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultContextValve.invoke(DefaultContextValve.java:92) [bes-engine.jar:?]
        at com.bes.enterprise.webext.BesContextCleanupValve.invoke(BesContextCleanupValve.java:50) [bes-ee-integration.jar:?]
        at com.bes.enterprise.webext.BESAppservValve.invoke(BESAppservValve.java:41) [bes-ee-integration.jar:?]
        at com.bes.enterprise.webtier.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultHostValve.invoke(DefaultHostValve.java:136) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.valves.ErrorReportValve.invoke(ErrorReportValve.java:77) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultEngineValve.invoke(DefaultEngineValve.java:83) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) [bes-engine.jar:?]
        at com.bes.enterprise.web.crane.http11.Http11Processor.service(Http11Processor.java:671) [V9.5.5.6210.006.jar:?]
        at com.bes.enterprise.web.crane.AbstractProcessorLight.process(AbstractProcessorLight.java:61) [bes-webtier-coyote.jar:?]
        at com.bes.enterprise.web.crane.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:815) [bes-webtier-coyote.jar:?]
        at com.bes.enterprise.web.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732) [V9.5.5.6210.005.jar:?]
        at com.bes.enterprise.web.util.net.SocketProcessorBase.run(SocketProcessorBase.java:47) [bes-webtier-coyote.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_371]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_371]
        at com.bes.enterprise.web.util.threads.WorkThread$WrappingRunnable.run(WorkThread.java:57) [bes-webtier-util.jar:?]
        at java.lang.Thread.run(Thread.java:750) [?:1.8.0_371]
Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, expect ), actual IDENTIFIER pos 34, line 1, column 26, token IDENTIFIER SEPARATOR
        at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:4562) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLExprParser.methodRest(SQLExprParser.java:1912) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:6231) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:1052) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLSelectParser.query(SQLSelectParser.java:462) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:61) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQLStatementParser.parseSelect(SQLStatementParser.java:4341) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.parser.SQ|##
##|2024-10-11 11:59:14.267|INFO|javax.enterprise.system.std|_ThreadID=102;_ThreadName=httpWorkerThread-18080-4|LStatementParser.parseStatementList(SQLStatementParser.java:200) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:580) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:601) ~[druid-1.2.11.jar:1.2.11]
        at com.alibaba.druid.sql.PagerUtils.count(PagerUtils.java:38) ~[druid-1.2.11.jar:1.2.11]
        at com.apex.util.SQLUtil.count(SQLUtil.java:674) ~[classes/:?]
        at com.apex.form.helper.SQLQueryDao.getRowCount(SQLQueryDao.java:117) ~[classes/:?]
        ... 60 more
|##
##|2024-10-11 11:59:14.269|INFO|javax.enterprise.system.std|_ThreadID=102;_ThreadName=httpWorkerThread-18080-4|2024-10-11 11:59:14,268 64554330 DEBUG [httpWorkerThread-18080-4] (ServletUtil.java:1169) com.apex.form.servlet.ServletUtil - printException:查询出错[执行语句失败]
com.apex.form.context.PageContextException: 查询出错[执行语句失败]
        at com.apex.form.context.AbstractPageModeContext.query(AbstractPageModeContext.java:292) ~[classes/:?]
        at com.apex.form.context.AbstractPageModeContext.query(AbstractPageModeContext.java:260) ~[classes/:?]
        at com.apex.form.context.AbstractPageModeContext.getRsRecord(AbstractPageModeContext.java:380) ~[classes/:?]
        at com.apex.livebos.ui.react.context.ReactQueryMode.process(ReactQueryMode.java:44) ~[classes/:?]
        at com.apex.form.ui.ServletProcessor.forwardPageModeContext(ServletProcessor.java:133) ~[classes/:?]
        at com.apex.form.ui.ServletProcessor.processPageModeContext(ServletProcessor.java:112) ~[classes/:?]
        at com.apexinfo.livecloud.server.core.livebos.servlet.UIProcessor.doGet(UIProcessor.java:65) [apexinfo-livecloud-server-core.jar:1.0.0.2024.09.29.17.39.03]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:630) [javaee.jar:?]
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:737) [javaee.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:229) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.security.LBSecurityFilterProxy.doFilter(LBSecurityFilterProxy.java:52) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.system.metrics.servlet.DefaultWebMvcMetricFilter.doFilter(DefaultWebMvcMetricFilter.java:65) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.abs.filters.CompressionFilter.doFilter(CompressionFilter.java:75) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.form.servlet.LogonFilter.doFilter(LogonFilter.java:240) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.bes.enterprise.web.websocket.server.WsFilter.doFilter(WsFilter.java:48) [bes-websocket.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apexinfo.livecloud.server.plugins.product.liveid.client.filter.ClientFilter.doFilter(ClientFilter.java:44) [apexinfo-livecloud-server-plugins-product-liveidclient.jar:1.0.0.2024.09.23.16.57.13]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apexinfo.livecloud.server.core.web.filter.FirstFilter.doFilter(FirstFilter.java:110) [apexinfo-livecloud-server-core.jar:1.0.0.2024.09.29.17.39.03]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.apex.livebos.clustersupport.redis.session.SessionFilterProxy.doFilter(SessionFilterProxy.java:30) [classes/:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:191) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultWrapperValve.invoke(DefaultWrapperValve.java:194) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultContextValve.invoke(DefaultContextValve.java:92) [bes-engine.jar:?]
        at com.bes.enterprise.webext.BesContextCleanupValve.invoke(BesContextCleanupValve.java:50) [bes-ee-integration.jar:?]
        at com.bes.enterprise.webext.BESAppservValve.invoke(BESAppservValve.java:41) [bes-ee-integration.jar:?]
        at com.bes.enterprise.webtier.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultHostValve.invoke(DefaultHostValve.java:136) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.valves.ErrorReportValve.invoke(ErrorReportValve.java:77) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.core.DefaultEngineValve.invoke(DefaultEngineValve.java:83) [bes-engine.jar:?]
        at com.bes.enterprise.webtier.connector.CoyoteAdapter.service(CoyoteAdapter.java:349) [bes-engine.jar:?]
        at com.bes.enterprise.web.crane.http11.Http11Processor.service(Http11Processor.java:671) [V9.5.5.6210.006.jar:?]
        at com.bes.enterprise.web.crane.AbstractProcessorLight.process(AbstractProcessorLight.java:61) [bes-webtier-coyote.jar:?]
        at com.bes.enterprise.web.crane.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:815) [bes-webtier-coyote.jar:?]
        at com.bes.enterprise.web.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732) [V9.5.5.6210.005.jar:?]
        at com.bes.enterprise.web.util.net.SocketProcessorBase.run(SocketProcessorBase.java:47) [bes-webtier-coyote.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_371]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_371]
        at com.bes.enterprise.web.util.threads.WorkThread$WrappingRunnable.run(WorkThread.java:57) [bes-webtier-util.jar:?]
        at java.lang.Thread.run(Thread.java:750) [?:1.8.0_371]
Caused by: com.apex.form.context.DataAccessException: 查询出错[执行语句失败]
        at com.apex.form.context.QueryAccessMode.getRowset(QueryAccessMode.java:63) ~[classes/:?]
        at com.apex.form.context.AbstractPageModeContext.query(AbstractPageModeContext.java:282) ~[classes/:?]
        ... 52 more
Caused by: java.sql.SQLException: 执行语句失败
        at com.apex.form.helper.OracleTransOperateExecuter.execQuery(OracleTransOperateExecuter.java:109) ~[classes/:?]
        at com.apex.form.TransBuilder.getRowSet(TransBuilder.java:164) ~[classes/:?]
        at com.apex.form.context.QueryAccessMode.getRowset(QueryAccessMode.java:56) ~[classes/:?]
        at com.apex.form.context.AbstractPageModeContext.query(AbstractPageModeContext.java:282) ~[classes/:?]
        ... 52 more
|##
##|2024-10-11 11:59:14.269|INFO|javax.enterprise.system.std|_ThreadID=102;_ThreadName=httpWorkerThread-18080-4|2024-10-11 11:59:14,269 64554331 DEBUG [httpWorkerThread-18080-4] (ServletUtil.java:1138) com.apex.form.servlet.ServletUtil - printError:查询出错[执行语句失败]
|##

展开
收起
kk7q5k3grsifc 2024-10-12 11:23:38 34 0
0 条回答
写回答
取消 提交回答
问答分类：
Java druid SQL 安全 前端开发 NoSQL Redis 数据库 日志服务
问答标签：
数据库sql SQL报错 数据库报错 数据集SQL SQL库
问答地址：
开发者社区 > 数据库 > 问答

版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

相关问答
阿里云数据库如何定义“一站式全链路数据管理与服务”？
39
1
0
druid解析hive数据库sql不支持set
17
0
0
PolarDB两个测试库，在执行同一个sql其中一个命中了索引，为什么另一个不能？
30
0
0
在OceanBase数据库中，ocp在配置告警通道时选择手机号，这个接收人字段是怎么定义的？
32
1
0
nacos数据库mysql帮忙给一份建库sql？
132
1
0
quick bi图表的数据集是SQL写的，写了一个变量，该变量期望不传的时候查全部，应该怎么操作？
29
0
0
云数据仓库ADB Spark SQL访问MaxCompute数据源-支持的库表操作
45
1
0
Flink现在是直接通过sql作业里的同步模版就能实现两个库之间的实时数据同步么？
28
1
0
大数据计算MaxCompute有没有sql可以查看库内所有表，是否是分区表呢？
29
1
0
在上面的 SQL 结构定义中，如何理解 sealed 接口的作用？
26
1
0

数据库

数据库领域前沿技术分享与交流

我要提问

热门讨论

热门文章

  • RDS，DRDS，REDIS，ADS，ODPS之间的联系和区别是什么？
    8433
  • Google当年发表的“三驾马车”具体是指什么？
    5697
  • 你印象最深的一道SQL题目是什么？
    4831
  • 阿里云数据库PolarDB和MySQL有什么区别？
    895
  • PolarDB分区表中，多少条记录适合创建一个分区？
    432
  • redis查看某个前缀键值数量
    3806
  • mysqlmysql 5.1.73不支持utf8mb4怎么办
    2541
  • 什么是多租户？
    1461
  • 有了RDS，为什么要有DRDS，DRDS的功能是什么？
    425
  • 数据合并指的是什么？
    118
    • 展开全部
  • ETCD系列之一：简介
    76737
  • 德哥的PostgreSQL私房菜 - 史上最屌PG资料合集
    57097
  • redis4.0、codis、阿里云redis 3种redis集群对比分析
    41560
  • NoSQL最新现状和趋势：云NoSQL数据库将成重要增长引擎
    38451
  • 什么场景应该用 MongoDB ？
    56794
  • PostgreSQL 如何实现批量更新、删除、插入
    54763
  • MongoDB Sharded cluster架构原理
    41475
  • Redis Stream——作为消息队列的典型应用场景
    34982
  • DRDS 数据恢复重磅发布，全方位保障您的数据安全
    31234
  • PostgreSQL upsert功能(insert on conflict do)的用法
    47439
    • 展开全部

    相关课程

    更多
  • 如何在 PolarDB-X 中优化慢 SQL
    130
    2
    去学习
  • SQL完全自学手册
    3871
    61
    去学习
  • SQL Server on Linux入门教程
    4392
    14
    去学习
  • SQL入门与实践
    11468
    6
    去学习
  • 数据库及SQL/MySQL基础
    6961
    22
    去学习
  • SQL进阶及查询
    2575
    25
    去学习

    • 相关文章

  • 一些处理浏览器兼容性问题的JavaScript库
  • 网络安全涨知识：基础网络攻防之DDoS攻击
  • 使用高防ip后源站IP暴露的解决办法
  • 今日 AI 开源｜共 4 项｜DeepSeek 推出新一代 AI 推理模型，实力比肩 OpenAI o1-preview！
  • ES6 中常用的新特性

    • 相关电子书

    更多
    • SQL Server 2017 立即下载
    GeoMesa on Spark SQL 立即下载
    原生SQL on Hadoop引擎- Apache HAWQ 2.x最新技术解密malili 立即下载

    相关实验场景

    更多
  • SQL的增删改查及函数应用
    1945
    2.0小时
    去实验
  • PolarDB MySQL自动SQL限流
    162
    1.0小时
    去实验
  • 如何开通SQL Server的专属集群
    141
    0.5小时
    去实验
  • 使用DAS实现数据库自动SQL优化
    190
    1.0小时
    去实验
  • 使用DAS实现数据库自动SQL限流
    143
    1.0小时
    去实验
  • 一小时快速掌握 SQL 语法
    68883
    1.0小时
    去实验