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 36 0
0 条回答
写回答
取消 提交回答
问答分类：
Java druid SQL 安全 前端开发 NoSQL Redis 数据库 日志服务
问答标签：
数据库sql SQL报错 数据库报错 数据集SQL SQL库
问答地址：
开发者社区 > 数据库 > 问答

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

相关问答
阿里云数据库如何定义“一站式全链路数据管理与服务”？
39
1
0
druid解析hive数据库sql不支持set
18
0
0
在selectDB中，同一个sql查询中可以有多个库吗？
39
1
0
在OceanBase数据库中，ocp在配置告警通道时选择手机号，这个接收人字段是怎么定义的？
32
1
0
Flink现在是直接通过sql作业里的同步模版就能实现两个库之间的实时数据同步么？
28
1
0
在Flink CDC中，Flink-cdc 支持 国产-优炫数据库么？
63
1
0
大数据计算MaxCompute有没有sql可以查看库内所有表，是否是分区表呢？
30
1
0
2021年Gartner云数据库管理系统魔力象限的市场定义有何变化？
38
1
0
在大屏里面想用通用标题来显示数据库里面的数据，已经选择好了数据源，请问SQL命令行应该怎么填写？
34
0
0
数据集在Quick BI中并不直接等同于物理数据库中的表吗？
47
0
0

数据库

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

我要提问

热门讨论

热门文章

  • Google当年发表的“三驾马车”具体是指什么？
    5713
  • RDS，DRDS，REDIS，ADS，ODPS之间的联系和区别是什么？
    8447
  • 你印象最深的一道SQL题目是什么？
    4842
  • redis查看某个前缀键值数量
    3814
  • PolarDB分区表中，多少条记录适合创建一个分区？
    442
  • 阿里云数据库PolarDB和MySQL有什么区别？
    897
  • 数据合并指的是什么？
    126
  • 什么是多租户？
    1466
  • mysqlmysql 5.1.73不支持utf8mb4怎么办
    2541
  • 逻辑存储和物理存储各代表什么？区别是什么？
    632
    • 展开全部
  • 德哥的PostgreSQL私房菜 - 史上最屌PG资料合集
    57102
  • redis4.0、codis、阿里云redis 3种redis集群对比分析
    41562
  • NoSQL最新现状和趋势：云NoSQL数据库将成重要增长引擎
    38455
  • 什么场景应该用 MongoDB ？
    56797
  • PostgreSQL 如何实现批量更新、删除、插入
    54770
  • MongoDB Sharded cluster架构原理
    41478
  • PostgreSQL upsert功能(insert on conflict do)的用法
    47442
  • Linux 性能诊断 perf使用指南
    48134
  • PostgreSQL 9种索引的原理和应用场景
    52416
  • PostgreSQL 如何潇洒的处理每天上百TB的数据增量
    38493
    • 展开全部

    相关课程

    更多
  • 数据库的前世今生
    3068
    2
    去学习
  • 数据库核心概念
    1737
    7
    去学习
  • 从传统数据库到云数据库演进
    638
    1
    去学习
  • 数据库常见问题排查
    437
    2
    去学习
  • 数据库及SQL/MySQL基础
    6966
    22
    去学习
  • 高校精品课-西安交通大学 -数据库理论与技术
    497
    9
    去学习

    • 相关文章

  • 【Azure Redis】部署在AKS中的应用，连接Redis高频率出现timeout问题
  • 关于Claude国内能用吗？回答是：能用！
  • Open Interpreter：AI 赋能终端！在终端中对话AI模型进行编程，通过运行代码来完成各种计算机操作任务
  • 《探秘程序崩溃：核心转储（Core Dump）分析全攻略》
  • 《深度解析：死锁的“前世今生”与防范之道》

    • 相关电子书

    更多
    • DTCC 2022大会集锦《云原生一站式数据库技术与实践》 立即下载
    阿里云瑶池数据库精要2022版 立即下载
    2022 DTCC-阿里云一站式数据库上云最佳实践 立即下载

    相关实验场景

    更多
  • 数据库实验室挑战任务-高级任务
    4273
    1.0小时
    去实验
  • 数据库实验室挑战任务-中级任务
    4063
    1.0小时
    去实验
  • 数据库实验室挑战任务-初级任务
    6536
    1.0小时
    去实验
  • 阿里云数据库产品实验室
    1674
    1.0小时
    去实验
  • MongoDB数据库入门
    2815
    2.0小时
    去实验
  • 使用DAS实现数据库自动扩容和回缩
    163
    1.0小时
    去实验