The database schema changed slightly yesterday (addition of the PIPED_ID
column). Maven2 doesn't handle this very well, so the recommendation is to
1) clean everything in your local checkout, 2) remove any Ode artifacts from
your local Maven2 repository and 3) Rebuild using "mvn install". That
should do the trick.
alex
On 3/2/07, Luca Clementi <[EMAIL PROTECTED]> wrote:
Hi all,
I tryied to compile and install the latest head of the ODE (yesterday
the 1st of March) on serviceMix 3.1.
Following the suggestion circulated on the ODE mailing list few days
ago everything worked fine (I changed the persistency layer with
hibernate).
But when I try to invoke the process I get the following which still
seems related to the persistency layer.
Caused by: java.sql.SQLException: 'PIPED_ID' is not a column in table or
VTI 'SA.BPEL_MESSAGE_EXCHANGE'.
Below the stack trace.
Any clue??
Luca
-----------------------------------------------------------------
--------------------------------------------------------------------------------------------
WARN - JDBCExceptionReporter - SQL Error: 20000, SQLState: 42X14
ERROR - JDBCExceptionReporter - 'PIPED_ID' is not a column in
table or VTI 'SA.BPEL_MESSAGE_EXCHANGE'.
ERROR - AbstractFlushingEventListener - Could not synchronize database
state with session
org.hibernate.exception.SQLGrammarException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HMessageExchange]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
:65)
at
org.hibernate.exception.JDBCExceptionHelper.convert(
JDBCExceptionHelper.java:43)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(
AbstractEntityPersister.java:2078)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(
AbstractEntityPersister.java:2427)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java
:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
AbstractFlushingEventListener.java:296)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(
DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java
:356)
at
org.hibernate.transaction.CacheSynchronization.beforeCompletion(
CacheSynchronization.java:59)
at
org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(
TransactionImpl.java:515)
at
org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(
TransactionImpl.java:399)
at
org.apache.geronimo.transaction.manager.TransactionImpl.commit(
TransactionImpl.java:256)
at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(
TransactionManagerImpl.java:264)
at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:269)
at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:147)
at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(
JbiMessageExchangeEventRouter.java:47)
at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java
:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: 'PIPED_ID' is not a column in table or
VTI 'SA.BPEL_MESSAGE_EXCHANGE'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException
(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.opentools.minerva.jdbc.ConnectionInPool.prepareStatement(
ConnectionInPool.java:613)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(
AbstractBatcher.java:442)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java
:93)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java
:86)
at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(
AbstractBatcher.java:171)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(
AbstractEntityPersister.java:2048)
... 24 more
WARN - Transaction - Unexpected exception from
beforeCompletion; transaction will roll back
org.hibernate.exception.SQLGrammarException: could not insert:
[org.apache.ode.daohib.bpel.hobj.HMessageExchange]
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java
:65)
at
org.hibernate.exception.JDBCExceptionHelper.convert(
JDBCExceptionHelper.java:43)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(
AbstractEntityPersister.java:2078)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(
AbstractEntityPersister.java:2427)
at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java
:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)
at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)
at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
AbstractFlushingEventListener.java:296)
at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(
DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java
:356)
at
org.hibernate.transaction.CacheSynchronization.beforeCompletion(
CacheSynchronization.java:59)
at
org.apache.geronimo.transaction.manager.TransactionImpl.beforeCompletion(
TransactionImpl.java:515)
at
org.apache.geronimo.transaction.manager.TransactionImpl.beforePrepare(
TransactionImpl.java:399)
at
org.apache.geronimo.transaction.manager.TransactionImpl.commit(
TransactionImpl.java:256)
at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(
TransactionManagerImpl.java:264)
at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:269)
at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:147)
at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(
JbiMessageExchangeEventRouter.java:47)
at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java
:675)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: 'PIPED_ID' is not a column in table or
VTI 'SA.BPEL_MESSAGE_EXCHANGE'.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException
(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown
Source)
at
org.opentools.minerva.jdbc.ConnectionInPool.prepareStatement(
ConnectionInPool.java:613)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(
AbstractBatcher.java:442)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java
:93)
at
org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java
:86)
at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(
AbstractBatcher.java:171)
at
org.hibernate.persister.entity.AbstractEntityPersister.insert(
AbstractEntityPersister.java:2048)
... 24 more
ERROR - OdeService - Error invoking ODE.
javax.transaction.RollbackException: Unable to commit: transaction
marked for rollback
at
org.apache.geronimo.transaction.manager.TransactionImpl.commit(
TransactionImpl.java:270)
at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(
TransactionManagerImpl.java:264)
at org.apache.ode.jbi.OdeService.invokeOde(OdeService.java:269)
at
org.apache.ode.jbi.OdeService.onJbiMessageExchange(OdeService.java:147)
at
org.apache.ode.jbi.JbiMessageExchangeEventRouter.onJbiMessageExchange(
JbiMessageExchangeEventRouter.java:47)
at org.apache.ode.jbi.Receiver$1.run(Receiver.java:190)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:417)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(
ThreadPoolExecutor.java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java
:675)
at java.lang.Thread.run(Thread.java:595)
WARN - jetty - EXCEPTION
javax.servlet.ServletException: Failed to process request:
java.lang.Exception: Unknown Error
at
org.apache.servicemix.http.HttpBridgeServlet.doPost(HttpBridgeServlet.java
:79)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:356)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(
ContextHandlerCollection.java:149)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java
:123)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
at org.mortbay.jetty.Server.handle(Server.java:269)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java
:333)
at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java
:270)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java
:475)
WARN - jetty - Nested in
javax.servlet.ServletException: Failed to process request:
java.lang.Exception: Unknown Error:
java.lang.Exception: Unknown Error
at
org.apache.servicemix.http.processors.ConsumerProcessor.process(
ConsumerProcessor.java:216)
at
org.apache.servicemix.http.HttpBridgeServlet.doPost(HttpBridgeServlet.java
:71)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:356)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(
ContextHandlerCollection.java:149)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java
:123)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
at org.mortbay.jetty.Server.handle(Server.java:269)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java
:333)
at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java
:270)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java
:475)
WARN - jetty - /TestService/:
java.lang.Exception: Unknown Error
at
org.apache.servicemix.http.processors.ConsumerProcessor.process(
ConsumerProcessor.java:216)
at
org.apache.servicemix.http.HttpBridgeServlet.doPost(HttpBridgeServlet.java
:71)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:356)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(
ContextHandlerCollection.java:149)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java
:123)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
at org.mortbay.jetty.Server.handle(Server.java:269)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java
:333)
at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java
:270)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java
:475)
WARN - jetty - /TestService/
java.lang.Exception: Unknown Error
at
org.apache.servicemix.http.processors.ConsumerProcessor.process(
ConsumerProcessor.java:216)
at
org.apache.servicemix.http.HttpBridgeServlet.doPost(HttpBridgeServlet.java
:71)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:356)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(
ContextHandlerCollection.java:149)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java
:123)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
at org.mortbay.jetty.Server.handle(Server.java:269)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java
:333)
at
org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java
:270)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java
:475)
