0 Replies Latest reply on Mar 26, 2013 6:35 AM by Zhao Lu

    jbpm5.4 use oracle11g

    Zhao Lu Newbie

           jbpm5.4 oracle11g, and jboss7.1.

      but,  Deployment of six components, would not find the from keyword error

       

      18:20:21,240 WARN  [org.jboss.jca.core.connectionmanager.listener.TxConnectionListener] (Thread-69) IJ000305: Connection error occured: org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@135ced[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@361595 connection handles=0 lastUse=1364293220114 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@f0c67 pool internal context=SemaphoreArrayListManagedConnectionPool@1f77497[pool=OracleTaskDSPool] xaResource=LocalXAResourceImpl@c2eb5b[connectionListener=135ced connectionManager=db3158 warned=false currentXid=null] txSync=null]: java.sql.SQLSyntaxErrorException: ORA-00923: Requirements FROM keyword not found

       

       

                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:853) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1882) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1847) [ojdbc6.jar:11.2.0.1.0]

                at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301) [ojdbc6.jar:11.2.0.1.0]

                at org.jboss.jca.adapters.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:74)

                at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:1151)

                at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:461)

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:507)

                at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:282)

                at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)

                at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)

                at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)

                at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)

                at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)

                at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)

                at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:276) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:297) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:169) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.extractPhysicalConnection(ConnectionProxyHandler.java:82) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at $Proxy35.prepareStatement(Unknown Source)          at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1739) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.loader.Loader.doQuery(Loader.java:828) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.loader.Loader.loadEntity(Loader.java:2058) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:82) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:72) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3697) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:439) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:420) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:204) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:251) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:148) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:954) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.internal.SessionImpl.get(SessionImpl.java:870) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.internal.SessionImpl.get(SessionImpl.java:863) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:795) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

                at org.hibernate.ejb.AbstractEntityManagerImpl.find(AbstractEntityManagerImpl.java:770) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]

                at org.jbpm.task.service.persistence.TaskPersistenceManager.findEntity(TaskPersistenceManager.java:212) [jbpm-human-task-core-5.4.0.Final.jar:5.4.0.Final]

                at org.jbpm.task.service.TaskServiceSession.addUserFromCallbackOperation(TaskServiceSession.java:1603) [jbpm-human-task-core-5.4.0.Final.jar:5.4.0.Final]

                at org.jbpm.task.service.TaskServiceSession.doCallbackUserOperation(TaskServiceSession.java:1226) [jbpm-human-task-core-5.4.0.Final.jar:5.4.0.Final]

                at org.jbpm.task.service.TaskServiceSession.getTasksOwned(TaskServiceSession.java:763) [jbpm-human-task-core-5.4.0.Final.jar:5.4.0.Final]

                at org.jbpm.task.service.TaskServerHandler.messageReceived(TaskServerHandler.java:309) [jbpm-human-task-core-5.4.0.Final.jar:5.4.0.Final]

                at org.jbpm.task.service.hornetq.HornetQTaskServerHandler.messageReceived(HornetQTaskServerHandler.java:43) [jbpm-human-task-hornetq-5.4.0.Final.jar:5.4.0.Final]

                at org.jbpm.task.service.hornetq.BaseHornetQTaskServer.run(BaseHornetQTaskServer.java:104) [jbpm-human-task-hornetq-5.4.0.Final.jar:5.4.0.Final]

                at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_24]