1201error01
[default][2020-12-01 10:00:29,648][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[insert into 1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, MEMO, OPERATOR_ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?)] execute error.
java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1167)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1257)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at com.primeton.ext.infra.connection.StatementWrapper.executeBatch(StatementWrapper.java:210)
at com.primeton.das.entity.impl.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:49)
at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at com.primeton.das.entity.impl.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at com.primeton.das.entity.impl.hibernate.impl.SessionImpl.flush(SessionImpl.java:1021)
at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:120)
at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:226)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.invokePojo0(addOOperator_biz.java:177)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.__choiceinvokePojo0(addOOperator_biz.java:409)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.__invokeBiz(addOOperator_biz.java:360)
at com.primeton.eos.ooperatorbiz.addOOperator_biz._invoke(addOOperator_biz.java:266)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.invoke(addOOperator_biz.java:313)
at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
at com.sun.proxy.$Proxy38.invoke(Unknown Source)
at com.primeton.eos.OOperatorMaintain_flow.subprocess2(OOperatorMaintain_flow.java:1076)
at com.primeton.eos.OOperatorMaintain_flow._insertSubmit(OOperatorMaintain_flow.java:1305)
at com.primeton.eos.OOperatorMaintain_flow._view0(OOperatorMaintain_flow.java:1618)
at com.primeton.eos.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1678)
at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:327)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)
... 74 more
[default][2020-12-01 10:00:29,651][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
[default][2020-12-01 10:00:29,652][ERROR][com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener:301] Could not synchronize database state with session. Could not execute JDBC batch update
[FlowName=com.primeton.eos.ooperatorbiz.addOOperator.biz][activity name=insertEntity][activity id=invokePojo0][exception=ErrCode: 24000040
Message: 新增一条记录失败. 事务回滚.]
[default][2020-12-01 10:00:29,654][ERROR][com.primeton.access.client.impl.skeleton.ServiceEngine:38]
ErrCode: 24000040
Message: 新增一条记录失败. 事务回滚.
at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:232)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.invokePojo0(addOOperator_biz.java:177)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.__choiceinvokePojo0(addOOperator_biz.java:409)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.__invokeBiz(addOOperator_biz.java:360)
at com.primeton.eos.ooperatorbiz.addOOperator_biz._invoke(addOOperator_biz.java:266)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.invoke(addOOperator_biz.java:313)
at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
at com.sun.proxy.$Proxy38.invoke(Unknown Source)
at com.primeton.eos.OOperatorMaintain_flow.subprocess2(OOperatorMaintain_flow.java:1076)
at com.primeton.eos.OOperatorMaintain_flow._insertSubmit(OOperatorMaintain_flow.java:1305)
at com.primeton.eos.OOperatorMaintain_flow._view0(OOperatorMaintain_flow.java:1618)
at com.primeton.eos.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1678)
at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:327)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:662)
Caused by: ErrCode: 14101017
Message: SQL语法错误(Could not execute JDBC batch update)
at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:150)
at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:123)
at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:226)
... 61 more
Caused by: com.primeton.das.entity.impl.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at com.primeton.das.entity.impl.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at com.primeton.das.entity.impl.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:264)
at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at com.primeton.das.entity.impl.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at com.primeton.das.entity.impl.hibernate.impl.SessionImpl.flush(SessionImpl.java:1021)
at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:120)
... 62 more
Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1167)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1257)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at com.primeton.ext.infra.connection.StatementWrapper.executeBatch(StatementWrapper.java:210)
at com.primeton.das.entity.impl.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:49)
at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
... 68 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)
... 74 more
[FlowName=com.primeton.eos.OOperatorMaintain.flow][activity name=addOOperator][activity id=subprocess2][exception=ErrCode: 24000040
Message: 新增一条记录失败. 事务回滚.]
[default][2020-12-01 10:00:29,656][ERROR][com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor:371] error [com.primeton.eos.OOperatorMaintain.flow?_flowKey=9ddca8f3-1c59-4d69-8185-f2fe3f5ceca9.null]
ErrCode: 24000040
Message: 新增一条记录失败. 事务回滚.
at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:232)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.invokePojo0(addOOperator_biz.java:177)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.__choiceinvokePojo0(addOOperator_biz.java:409)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.__invokeBiz(addOOperator_biz.java:360)
at com.primeton.eos.ooperatorbiz.addOOperator_biz._invoke(addOOperator_biz.java:266)
at com.primeton.eos.ooperatorbiz.addOOperator_biz.invoke(addOOperator_biz.java:313)
at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
at com.sun.proxy.$Proxy38.invoke(Unknown Source)
at com.primeton.eos.OOperatorMaintain_flow.subprocess2(OOperatorMaintain_flow.java:1076)
at com.primeton.eos.OOperatorMaintain_flow._insertSubmit(OOperatorMaintain_flow.java:1305)
at com.primeton.eos.OOperatorMaintain_flow._view0(OOperatorMaintain_flow.java:1618)
at com.primeton.eos.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1678)
at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:327)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:662)
Caused by: ErrCode: 14101017
Message: SQL语法错误(Could not execute JDBC batch update)
at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:150)
at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:123)
at com.eos.foundation.database.DatabaseUtil.insertEntity(DatabaseUtil.java:226)
... 61 more
Caused by: com.primeton.das.entity.impl.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
at com.primeton.das.entity.impl.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at com.primeton.das.entity.impl.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:264)
at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:235)
at com.primeton.das.entity.impl.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:139)
at com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at com.primeton.das.entity.impl.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at com.primeton.das.entity.impl.hibernate.impl.SessionImpl.flush(SessionImpl.java:1021)
at com.primeton.das.entity.impl.DASSessionImpl.insertEntity(DASSessionImpl.java:120)
... 62 more
Caused by: java.sql.BatchUpdateException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1167)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1257)
at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at com.primeton.ext.infra.connection.StatementWrapper.executeBatch(StatementWrapper.java:210)
at com.primeton.das.entity.impl.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:49)
at com.primeton.das.entity.impl.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:254)
... 68 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator (USER_ID, USER_NAME, GENDER, POSTCODE, ADDRESS, PHONE, EMAIL, ME...' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)
... 74 more
[BPS Process Server][2020-12-01 10:00:36,408][INFO] Timer trig first:180000 3000
1201error02
报错节点
02 主从表功能一步完成
右键点击左侧"资源管理器"视图中,已创建的(project)项目中的(com.primeton.eos)构件包节点,选择[功能向导/主从表维护向导]菜单,如下图所示。
选择数据实体,还是选择刚才那个OOperator实体,我们会发现这个时候可以选择从表实体了,如下图所示。
我们进行查询条件的设置,如下图所示。
小技巧:queryform配置查询条件 EOS Studio提供了一个queryform的查询表单向导,如果查询的实体建立了n->1的关联关系,我们是可以选择关联实体的字段做为查询条件的,例如在上图中,我们可以设置"oOrg."开头的属性做为查询条件。通过这个方式我们轻松的实现了简单的join查询。
填好了查询条件字段后,单击<下一步>按钮,我们进入结果集的设置界面,我们可以通过下图中的 按钮来添加关联实体的属性"oOrg.orgName",这样结果集中就会显示操作员所在机构了。
后续的步骤中我们只需要点击<下一步>按钮即可。直到最后选择生成文件的目录,为了不和原来程序冲突,我们选择的包是"com.primeton.eos1",页面资源目录是"operator1",如下图所示。
我们通过http://127.0.0.1:8080/eos-default/com.primeton.eos1.OOperatorMaintain.flow查看运行结果。
查询界面如下:
录入界面如下:
到这里我们就了解了原来快速开发:单表增删改查、实现关联表操作、实现从表操作实现的功能特性全部可以通过功能向导来实现。让大家辛辛苦苦做了这么多步骤,原来向导都能够实现,虽然大家忙了一阵,但是可以通过前面的步骤了解到EOS编程的基本思路,也希望你能通过学习体验到编程的快乐。
小技巧:编程关键技巧 EOS提供了一个可视化的流程编程,改变了传统的编程模式。在编程过程中一定要记住下面的要点。 逻辑程序:流程体现逻辑,尽可能理清程序逻辑,定义出参数和变量,你就可以通过"自定义"库快速实现功能。 JSP页面:界面的代码占用了大量的开发时间,所以在设计时需要统一规划好"显示属性",然后借用"组合控件"向导以及"功能向导"可以将大量的程序框架生成出来,然后只要在程序框架上进行调整就可以加快程序开发进度。
报错日志
[BPS Process Server][2020-12-01 16:41:35,947][INFO] Timer trig first:180000 3000
[default][2020-12-01 16:44:04,098][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[select count(*) eos_row_count from ( select this_.OPERATOR_ID as OPERATOR1_84_2_, this_.USER_ID as USER2_84_2_, this_.USER_NAME as USER3_84_2_, this_.BIRTHDAY as BIRTHDAY84_2_, this_.GENDER as GENDER84_2_, this_.POSTCODE as POSTCODE84_2_, this_.ADDRESS as ADDRESS84_2_, this_.PHONE as PHONE84_2_, this_.EMAIL as EMAIL84_2_, this_.MEMO as MEMO84_2_, this_.oOrg as oOrg84_2_, oorg2_.ORG_ID as ORG1_85_0_, oorg2_.ORG_NAME as ORG2_85_0_, oorg2_.ORG_CODE as ORG3_85_0_, oorg2_.ORG_ADDRESS as ORG4_85_0_, oorg2_.ORG_SEQ as ORG5_85_0_, oorg2_.PARENT_ORG_ID as PARENT6_85_0_, oorg3_.ORG_ID as ORG1_85_1_, oorg3_.ORG_NAME as ORG2_85_1_, oorg3_.ORG_CODE as ORG3_85_1_, oorg3_.ORG_ADDRESS as ORG4_85_1_, oorg3_.ORG_SEQ as ORG5_85_1_, oorg3_.PARENT_ORG_ID as PARENT6_85_1_ from 1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID left outer join o_org oorg3_ on oorg2_.PARENT_ORG_ID=oorg3_.ORG_ID) table_] execute error.
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.primeton.ext.infra.connection.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:110)
at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:479)
at com.primeton.das.entity.impl.DASSessionImpl.count(DASSessionImpl.java:558)
at com.eos.foundation.database.DatabaseUtil.count(DatabaseUtil.java:987)
at com.eos.foundation.database.Pagination.doQuery(Pagination.java:485)
at com.eos.foundation.database.Pagination.doQueryPageCond(Pagination.java:515)
at com.eos.foundation.database.DatabaseExt.queryEntitiesByCriteriaEntityWithPage(DatabaseExt.java:441)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invokePojo0(queryOOperators_biz.java:210)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__choiceinvokePojo0(queryOOperators_biz.java:424)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__invokeBiz(queryOOperators_biz.java:370)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz._invoke(queryOOperators_biz.java:256)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invoke(queryOOperators_biz.java:321)
at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
at com.sun.proxy.$Proxy38.invoke(Unknown Source)
at com.primeton.eos1.OOperatorMaintain_flow.subprocess0(OOperatorMaintain_flow.java:324)
at com.primeton.eos1.OOperatorMaintain_flow._pageQuery(OOperatorMaintain_flow.java:454)
at com.primeton.eos1.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1635)
at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:325)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:662)
[FlowName=com.primeton.eos1.ooperatorbiz.queryOOperators.biz][activity name=queryEntitiesByCriteriaEntityWithPage][activity id=invokePojo0][exception=ErrCode: 14101000
Message: 未知异常(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1)]
[default][2020-12-01 16:44:04,120][ERROR][com.primeton.access.client.impl.skeleton.ServiceEngine:38]
ErrCode: 14101000
Message: 未知异常(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1)
at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:169)
at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:497)
at com.primeton.das.entity.impl.DASSessionImpl.count(DASSessionImpl.java:558)
at com.eos.foundation.database.DatabaseUtil.count(DatabaseUtil.java:987)
at com.eos.foundation.database.Pagination.doQuery(Pagination.java:485)
at com.eos.foundation.database.Pagination.doQueryPageCond(Pagination.java:515)
at com.eos.foundation.database.DatabaseExt.queryEntitiesByCriteriaEntityWithPage(DatabaseExt.java:441)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invokePojo0(queryOOperators_biz.java:210)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__choiceinvokePojo0(queryOOperators_biz.java:424)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__invokeBiz(queryOOperators_biz.java:370)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz._invoke(queryOOperators_biz.java:256)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invoke(queryOOperators_biz.java:321)
at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
at com.sun.proxy.$Proxy38.invoke(Unknown Source)
at com.primeton.eos1.OOperatorMaintain_flow.subprocess0(OOperatorMaintain_flow.java:324)
at com.primeton.eos1.OOperatorMaintain_flow._pageQuery(OOperatorMaintain_flow.java:454)
at com.primeton.eos1.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1635)
at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:325)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.primeton.ext.infra.connection.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:110)
at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:479)
... 65 more
[FlowName=com.primeton.eos1.OOperatorMaintain.flow][activity name=queryOOperators][activity id=subprocess0][exception=ErrCode: 14101000
Message: 未知异常(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1)]
[default][2020-12-01 16:44:04,122][ERROR][com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor:371] error [com.primeton.eos1.OOperatorMaintain.flow?_flowKey=bcf9ec3c-e84d-42b8-abc4-d244fb0710cd.null]
ErrCode: 14101000
Message: 未知异常(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1)
at com.primeton.das.entity.impl.exception.DASExceptionHelper.convert(DASExceptionHelper.java:169)
at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:497)
at com.primeton.das.entity.impl.DASSessionImpl.count(DASSessionImpl.java:558)
at com.eos.foundation.database.DatabaseUtil.count(DatabaseUtil.java:987)
at com.eos.foundation.database.Pagination.doQuery(Pagination.java:485)
at com.eos.foundation.database.Pagination.doQueryPageCond(Pagination.java:515)
at com.eos.foundation.database.DatabaseExt.queryEntitiesByCriteriaEntityWithPage(DatabaseExt.java:441)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invokePojo0(queryOOperators_biz.java:210)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__choiceinvokePojo0(queryOOperators_biz.java:424)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.__invokeBiz(queryOOperators_biz.java:370)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz._invoke(queryOOperators_biz.java:256)
at com.primeton.eos1.ooperatorbiz.queryOOperators_biz.invoke(queryOOperators_biz.java:321)
at com.primeton.engine.core.impl.process.BLProxy.invoke(BLProxy.java:223)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:112)
at com.primeton.engine.component.impl.OperationAccessor.invoke(OperationAccessor.java:80)
at com.primeton.ext.engine.component.Operation.invoke(Operation.java:100)
at com.primeton.engine.component.impl.LogicCompoment.invoke(LogicCompoment.java:183)
at com.primeton.access.client.impl.skeleton.BizLogicReceiveTarget.invoke(BizLogicReceiveTarget.java:50)
at com.primeton.access.client.impl.skeleton.ServiceEngine.receive(ServiceEngine.java:36)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invokeService(DefaultServiceSkeleton.java:130)
at com.primeton.access.client.impl.skeleton.DefaultServiceSkeleton.invoke(DefaultServiceSkeleton.java:32)
at com.primeton.access.client.impl.ClientMessageInterceptor.invoke(ClientMessageInterceptor.java:57)
at com.primeton.system.aop.impl.HandlerInvoker.invoke(HandlerInvoker.java:60)
at com.primeton.system.aop.impl.JdkProxyUtil$JdkInvocationHandlerWrapper.invoke(JdkProxyUtil.java:53)
at com.sun.proxy.$Proxy38.invoke(Unknown Source)
at com.primeton.eos1.OOperatorMaintain_flow.subprocess0(OOperatorMaintain_flow.java:324)
at com.primeton.eos1.OOperatorMaintain_flow._pageQuery(OOperatorMaintain_flow.java:454)
at com.primeton.eos1.OOperatorMaintain_flow.process(OOperatorMaintain_flow.java:1635)
at com.primeton.engine.core.impl.process.PageflowInstance.process(PageflowInstance.java:325)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.doProcess(AbstractPageFlowProcessor.java:330)
at com.primeton.ext.engine.core.processor.AbstractPageFlowProcessor.process(AbstractPageFlowProcessor.java:112)
at com.primeton.access.http.impl.ProcessorWebInterceptor.doIntercept(ProcessorWebInterceptor.java:105)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.authorization.impl.AccessedHttpResourceFilter.doIntercept(AccessedHttpResourceFilter.java:131)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.UserLoginCheckedFilter.doIntercept(UserLoginCheckedFilter.java:124)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.FunctionWebInterceptor.doIntercept(FunctionWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at org.gocom.components.coframe.auth.intercepter.UserLoginWebInterceptor.doIntercept(UserLoginWebInterceptor.java:84)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpRefererWebInterceptor.doIntercept(HttpRefererWebInterceptor.java:47)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.security.HttpSecurityWebInterceptor.doIntercept(HttpSecurityWebInterceptor.java:40)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.access.http.impl.WebI18NInterceptor.doIntercept(WebI18NInterceptor.java:64)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.primeton.sca.host.webapp.SCAWebServiceServletFilter.doIntercept(SCAWebServiceServletFilter.java:133)
at com.primeton.access.http.impl.WebInterceptorChainImpl.doIntercept(WebInterceptorChainImpl.java:56)
at com.eos.access.http.InterceptorFilter.doFilter(InterceptorFilter.java:120)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:662)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '1.o_operator this_ left outer join o_org oorg2_ on this_.oOrg=oorg2_.ORG_ID l...' at line 1
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.primeton.ext.infra.connection.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:110)
at com.primeton.das.entity.impl.DASSessionImpl.countBySubQuery(DASSessionImpl.java:479)
... 65 more
1202error01
下面操作文档的HTML代码,其中,引入的JS(nui.js)路径【src=“common/nui/nui.js” 】
<!DOCTYPE html />
<html>
<head>
<title>Hello NUI!</title>
<!-NUI->
<script src="common/nui/nui.js" type="text/javascript"></script>
</head>
<body>
<input id="helloBtn" class="nui-button" text="Hello" onclick="onHelloClick"/>
<script type="text/javascript">
function onHelloClick(e){
var button = e.sender;
nui.alert("Hello NUI!");
}
</script>
</body>
</html>
在工作空间导入的现成页面可以正常展示,引入的JS路径【<%@include file="/nui/common.jsp"%> 】和【
<link id="css_skin" rel="stylesheet" type="text/css"
href="<%=contextPath%>/coframe/tools/skins/skin1/style.css" />
】完整代码如下:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@page pageEncoding="UTF-8"%>
<%@include file="/nui/common.jsp"%>
<link id="css_skin" rel="stylesheet" type="text/css"
href="<%=contextPath%>/coframe/tools/skins/skin1/style.css" />
<html>
<!--
- Author(s): JFree
- Date: 2013-03-19 17:01:14
- Description:
-->
<head>
<title>Hello, world!</title>
</head>
<body >
<input id="helloBtn" class="nui-button" text="Hello" onclick="onHelloClick"/>
<script type="text/javascript">
function onHelloClick(e) {
var button = e.sender;
nui.alert("Hello NUI!");
}
</script>
</body>
</html>
其中【/nui/common.jsp】引入了操作文档的JS文件(nui.js)代码如下:
<%
String contextPath=request.getContextPath();
%>
<script type="text/javascript" src="<%=contextPath%>/common/nui/nui.js"></script>
<script>
$(function(){
nui.context='<%=contextPath %>'
})
</script>
上面代码中 request.getContextPath();是获取站点根路径,就是webContent(MyEclipse中是webRoot),但是在此路径下不存在【/common/nui/nui.js】文件,网络关于此函数【request.getContextPath();】介绍: 点击此处查看360文档.
或: 点击此处查看博客园文档.