ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthieu Riou" <matthieu.r...@gmail.com>
Subject Re: Running Ode using an external database (MySql)
Date Thu, 21 Jun 2007 14:03:45 GMT
Hi Rene,

Would you make sure that the lib directory of the ODE webapp only contains
an axis2-kernel-intalio-1.1.1b.jar and no axis2-kernel-x.x.x.jar ?

Thanks,
Matthieu

On 6/21/07, René Bos <r.bos@pagelink.nl> wrote:
>
> Something went wrong with the attachment of my previous message, here it
> is:
>
> INFO: Starting Coyote HTTP/1.1 on http-8080
> 20-jun-2007 10:39:40 org.apache.jk.common.ChannelSocket init
> INFO: JK: ajp13 listening on /0.0.0.0:8009
> 20-jun-2007 10:39:40 org.apache.jk.server.JkMain start
> INFO: Jk running ID=0 time=0/120  config=null
> 20-jun-2007 10:39:41 org.apache.catalina.storeconfig.StoreLoader load
> INFO: Find registry server-registry.xml at classpath resource
> DEBUG - GeronimoLog.debug(66) | Checking for Operation using WSAAction :
> urn:anonOutInOp
> 10:39:41,144 DEBUG [ODEAxisDispatcher] Checking for Operation using
> WSAAction : urn:anonOutInOp
> DEBUG - GeronimoLog.debug(66) | Checking for Operation using SOAP message
> body's first child's local name : initiate
> 10:39:41,164 DEBUG [ODEAxisDispatcher] Checking for Operation using SOAP
> message body's first child's local name : initiate
> DEBUG - GeronimoLog.debug(66) | Found operation
> org.apache.axis2.description.InOutAxisOperation@6399ae
> 10:39:41,164 DEBUG [ODEAxisDispatcher] Found operation
> org.apache.axis2.description.InOutAxisOperation@6399ae
> 20-jun-2007 10:39:41 org.apache.catalina.startup.Catalina start
> INFO: Server startup in 22209 ms
> DEBUG - GeronimoLog.debug(66) | Received request message for Test_T-
> Rex.initiate
> 10:39:41,234 DEBUG [ODEMessageReceiver] Received request message for
> Test_T-Rex.initiate
> DEBUG - GeronimoLog.debug(66) | Starting transaction.
> 10:39:41,244 DEBUG [ODEService] Starting transaction.
> DEBUG - GeronimoLog.debug(66) | Routed: svcQname {
> http://Test_T-Rex.wsdl}Test_T-RexService --> BpelProcess[{
> http://Test_T-Rex}Test_T-Rex-5]
> 10:39:41,254 DEBUG [BpelEngineImpl] Routed: svcQname {
> http://Test_T-Rex.wsdl}Test_T-RexService --> BpelProcess[{
> http://Test_T-Rex}Test_T-Rex-5]
> DEBUG - GeronimoLog.trace(54) |
> Mex[hqejbhcnphr2d5prdws2vv].setPortOp(PortType: name={
> http://Test_T-Rex.wsdl}Test_T-RexPortType
> Operation: name=initiate
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}initiateRequest
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string
> Operation: name=taskCompleted3
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}taskCompletedRequest
> Part: name=userID
> typeName={http://www.w3.org/2001/XMLSchema}int
> Part: name=chosenCompletionValue
> typeName={http://www.w3.org/2001/XMLSchema}string
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Part: name=feedback
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string
> Operation: name=taskCompleted4
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}taskCompletedRequest
> Part: name=userID
> typeName={http://www.w3.org/2001/XMLSchema}int
> Part: name=chosenCompletionValue
> typeName={http://www.w3.org/2001/XMLSchema}string
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Part: name=feedback
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string,Operation: name=initiate
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}initiateRequest
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string)
> 10:39:41,295 DEBUG [MessageExchangeImpl]
> Mex[hqejbhcnphr2d5prdws2vv].setPortOp(PortType: name={
> http://Test_T-Rex.wsdl}Test_T-RexPortType
> Operation: name=initiate
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}initiateRequest
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string
> Operation: name=taskCompleted3
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}taskCompletedRequest
> Part: name=userID
> typeName={http://www.w3.org/2001/XMLSchema}int
> Part: name=chosenCompletionValue
> typeName={http://www.w3.org/2001/XMLSchema}string
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Part: name=feedback
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string
> Operation: name=taskCompleted4
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}taskCompletedRequest
> Part: name=userID
> typeName={http://www.w3.org/2001/XMLSchema}int
> Part: name=chosenCompletionValue
> typeName={http://www.w3.org/2001/XMLSchema}string
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Part: name=feedback
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string,Operation: name=initiate
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}initiateRequest
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string)
> DEBUG - GeronimoLog.debug(66) | ODE routed to operation Operation:
> name=initiate
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}initiateRequest
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string from service {
> http://Test_T-Rex.wsdl}Test_T-RexService
> 10:39:41,475 DEBUG [ODEService] ODE routed to operation Operation:
> name=initiate
> style=REQUEST_RESPONSE,1
> Input: name=null
> Message: name={http://Test_T-Rex.wsdl}initiateRequest
> Part: name=processInstanceID
> typeName={http://www.w3.org/2001/XMLSchema}string
> Output: name=null
> Message: name={http://Test_T-Rex.wsdl}userReplyMessage
> Part: name=return
> typeName={http://www.w3.org/2001/XMLSchema}string from service {
> http://Test_T-Rex.wsdl}Test_T-RexService
> DEBUG - GeronimoLog.debug(66) | Invoking ODE using MEX
> {MyRoleMex#hqejbhcnphr2d5prdws2vv [Client hqejbhcnphr2d5prdws2vu] calling {
> http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> 10:39:41,535 DEBUG [ODEService] Invoking ODE using MEX
> {MyRoleMex#hqejbhcnphr2d5prdws2vv [Client hqejbhcnphr2d5prdws2vu] calling {
> http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> DEBUG - GeronimoLog.debug(66) | Message content:  <?xml version="1.0"
> encoding="UTF-8"?>
> <message><processInstanceID xmlns:ns1="http://Test_T-Rex.wsdl"
> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/
> ">Test_T-Rex1182328778</processInstanceID></message>
> 10:39:41,535 DEBUG [ODEService] Message content:  <?xml version="1.0"
> encoding="UTF-8"?>
> <message><processInstanceID xmlns:ns1="http://Test_T-Rex.wsdl"
> xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/
> ">Test_T-Rex1182328778</processInstanceID></message>
> DEBUG - GeronimoLog.debug(66) | Routed: svcQname {
> http://Test_T-Rex.wsdl}Test_T-RexService --> BpelProcess[{
> http://Test_T-Rex}Test_T-Rex-5]
> 10:39:41,555 DEBUG [BpelEngineImpl] Routed: svcQname {
> http://Test_T-Rex.wsdl}Test_T-RexService --> BpelProcess[{
> http://Test_T-Rex}Test_T-Rex-5]
> DEBUG - GeronimoLog.debug(66) | invoke() EPR= null ==> BpelProcess[{
> http://Test_T-Rex}Test_T-Rex-5]
> 10:39:41,565 DEBUG [MyRoleMessageExchangeImpl] invoke() EPR= null ==>
> BpelProcess[{http://Test_T-Rex}Test_T-Rex-5]
> DEBUG - GeronimoLog.debug(66) | Commiting ODE MEX
> {MyRoleMex#hqejbhcnphr2d5prdws2vv [Client hqejbhcnphr2d5prdws2vu] calling {
> http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> 10:39:41,665 DEBUG [ODEService] Commiting ODE MEX
> {MyRoleMex#hqejbhcnphr2d5prdws2vv [Client hqejbhcnphr2d5prdws2vu] calling {
> http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> DEBUG - GeronimoLog.debug(66) | Commiting transaction.
> 10:39:41,665 DEBUG [ODEService] Commiting transaction.
> ERROR - GeronimoLog.error(104) | Timeout or execution error when waiting
> for response to MEX {MyRoleMex#hqejbhcnphr2d5prdws2vv [Client
> hqejbhcnphr2d5prdws2vu] calling {
> http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> java.util.concurrent.TimeoutException: Message excha
> nge
> org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@1dd8664timed out
when waiting for a response!
> 10:41:43,037 ERROR [ODEService] Timeout or execution error when waiting
> for response to MEX {MyRoleMex#hqejbhcnphr2d5prdws2vv [Client
> hqejbhcnphr2d5prdws2vu] calling {
> http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> java.util.concurrent.TimeoutException: Message exchan
> ge
> org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@1dd8664timed out
when waiting for a response!
> ERROR - GeronimoLog.error(108) | Servlet.service() for servlet AxisServlet
> threw exception
> java.lang.NullPointerException
>         at
> org.apache.axis2.engine.AxisEngine.extractFaultInformationFromMessageContext
> (AxisEngine.java:353)
>         at org.apache.axis2.engine.AxisEngine.createFaultMessageContext(
> AxisEngine.java:249)
>         at org.apache.axis2.transport.http.AxisServlet.handleFault(
> AxisServlet.java:317)
>         at org.apache.axis2.transport.http.AxisServlet.doPost(
> AxisServlet.java:277)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:213)
>         at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:178)
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:126)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:105)
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107)
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:148)
>         at org.apache.coyote.http11.Http11Processor.process(
> Http11Processor.java:869)
>         at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:664)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
> 10:41:43,498 ERROR [[AxisServlet]] Servlet.service() for servlet
> AxisServlet threw exception
> java.lang.NullPointerException
>         at
> org.apache.axis2.engine.AxisEngine.extractFaultInformationFromMessageContext
> (AxisEngine.java:353)
>         at org.apache.axis2.engine.AxisEngine.createFaultMessageContext(
> AxisEngine.java:249)
>         at org.apache.axis2.transport.http.AxisServlet.handleFault(
> AxisServlet.java:317)
>         at org.apache.axis2.transport.http.AxisServlet.doPost(
> AxisServlet.java:277)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:213)
>         at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:178)
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:126)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:105)
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107)
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:148)
>         at org.apache.coyote.http11.Http11Processor.process(
> Http11Processor.java:869)
>         at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:664)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
> ERROR - GeronimoLog.error(108) | Servlet.service() for servlet jsp threw
> exception
> java.lang.IllegalStateException: getOutputStream() has already been called
> for this response
>         at org.apache.catalina.connector.Response.getWriter(Response.java
> :599)
>         at org.apache.catalina.connector.ResponseFacade.getWriter(
> ResponseFacade.java:195)
>         at org.apache.jasper.runtime.JspWriterImpl.initOut(
> JspWriterImpl.java:124)
>         at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(
> JspWriterImpl.java:117)
>         at org.apache.jasper.runtime.PageContextImpl.release(
> PageContextImpl.java:182)
>         at
> org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(
> JspFactoryImpl.java:115)
>         at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(
> JspFactoryImpl.java:75)
>         at org.apache.jsp.axis2_002dweb.Error.error500_jsp._jspService
> (error500_jsp.java:97)
>         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java
> :97)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.apache.jasper.servlet.JspServletWrapper.service(
> JspServletWrapper.java:334)
>         at org.apache.jasper.servlet.JspServlet.serviceJspFile(
> JspServlet.java:314)
>         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java
> :264)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173)
>         at org.apache.catalina.core.ApplicationDispatcher.invoke(
> ApplicationDispatcher.java:672)
>         at org.apache.catalina.core.ApplicationDispatcher.processRequest(
> ApplicationDispatcher.java:465)
>         at org.apache.catalina.core.ApplicationDispatcher.doForward(
> ApplicationDispatcher.java:398)
>         at org.apache.catalina.core.ApplicationDispatcher.forward(
> ApplicationDispatcher.java:301)
>         at org.apache.catalina.core.StandardHostValve.custom(
> StandardHostValve.java:363)
>         at org.apache.catalina.core.StandardHostValve.status(
> StandardHostValve.java:284)
>         at org.apache.catalina.core.StandardHostValve.throwable(
> StandardHostValve.java:228)
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:134)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:105)
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107)
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:148)
>         at org.apache.coyote.http11.Http11Processor.process(
> Http11Processor.java:869)
>         at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:664)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
> 10:41:44,369 ERROR [[jsp]] Servlet.service() for servlet jsp threw
> exception
> java.lang.IllegalStateException: getOutputStream() has already been called
> for this response
>         at org.apache.catalina.connector.Response.getWriter(Response.java
> :599)
>         at org.apache.catalina.connector.ResponseFacade.getWriter(
> ResponseFacade.java:195)
>         at org.apache.jasper.runtime.JspWriterImpl.initOut(
> JspWriterImpl.java:124)
>         at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(
> JspWriterImpl.java:117)
>         at org.apache.jasper.runtime.PageContextImpl.release(
> PageContextImpl.java:182)
>         at
> org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(
> JspFactoryImpl.java:115)
>         at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(
> JspFactoryImpl.java:75)
>         at org.apache.jsp.axis2_002dweb.Error.error500_jsp._jspService
> (error500_jsp.java:97)
>         at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java
> :97)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at org.apache.jasper.servlet.JspServletWrapper.service(
> JspServletWrapper.java:334)
>         at org.apache.jasper.servlet.JspServlet.serviceJspFile(
> JspServlet.java:314)
>         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java
> :264)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:252)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:173)
>         at org.apache.catalina.core.ApplicationDispatcher.invoke(
> ApplicationDispatcher.java:672)
>         at org.apache.catalina.core.ApplicationDispatcher.processRequest(
> ApplicationDispatcher.java:465)
>         at org.apache.catalina.core.ApplicationDispatcher.doForward(
> ApplicationDispatcher.java:398)
>         at org.apache.catalina.core.ApplicationDispatcher.forward(
> ApplicationDispatcher.java:301)
>         at org.apache.catalina.core.StandardHostValve.custom(
> StandardHostValve.java:363)
>         at org.apache.catalina.core.StandardHostValve.status(
> StandardHostValve.java:284)
>         at org.apache.catalina.core.StandardHostValve.throwable(
> StandardHostValve.java:228)
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:134)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:105)
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:107)
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:148)
>         at org.apache.coyote.http11.Http11Processor.process(
> Http11Processor.java:869)
>         at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> (Http11BaseProtocol.java:664)
>         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> PoolTcpEndpoint.java:527)
>         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> LeaderFollowerWorkerThread.java:80)
>         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
> ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
>
> -----Original Message-----
> From: René Bos [mailto:r.bos@pagelink.nl]
> Sent: woensdag 20 juni 2007 10:44
> To: ode-user@incubator.apache.org
> Subject: RE: Running Ode using an external database (MySql)
>
> Hi,
>
> Just did a new build from SVN, but the log looks the same for me! Maybe I
> overlooked something...
>
> I attached the lastest log.
>
> René
>
> -----Original Message-----
> From: Matthieu Riou [mailto:matthieu.riou@gmail.com]
> Sent: dinsdag 19 juni 2007 20:53
> To: ode-user@incubator.apache.org
> Subject: Re: Running Ode using an external database (MySql)
>
> Hi Rene,
>
> Sorry for the late reply, we're having some issues with bugs in Axis2
> 1.1.1(and
> 1.2 as well actually) that prevent seeing the original problem that caused
> a
> fault. I've changed the build to use a patched version of axis2-kernel
> that
> solves this problems. So could you rebuild ODE from the trunk and try
> again?
> This way we'll know exactly what's wrong instead of trying to shoot in the
> dark.
>
> Thanks,
> Matthieu
>
> On 6/18/07, René Bos <r.bos@pagelink.nl> wrote:
> >
> > Hi,
> >
> >
> >
> > I just had time to work on the external (MySQL) database connection.
> >
> > As you said I made the ode-axis2.properties file with the following
> > contents:
> >
> >
> >
> > ode-axis2.db.mode=EXTERNAL
> >
> > ode-axis2.db.ext.dataSource=java:comp/env/jdbc/OdeDB
> >
> >
> >
> > I placed a file mysql-connector-java-5.0.6-bin.jar in the
> > <TOMCAT_INSTALL_DIR>\common\libs dir.
> >
> >
> >
> > In <TOMCAT_INSTALL_DIR>\conf\Catalina\localhost I added a file named
> > ode.xml with the following contents:
> >
> >
> >
> > <Context path="/Ode" docBase="ode" debug="5"
> > reloadable="true"                       crossContext="true">
> >
> >             <Resource name="jdbc/OdeDB"
> >
> auth="Container"                                                                    
   type="
> > javax.sql.DataSource"
> >
> >                         maxActive="100" maxIdle="30" maxWait="10000"
> >
> >                         username="username"
> >
> password="password"                                                                 
driverClassName="
> > com.mysql.jdbc.Driver"
> >
> >
> url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"
> > validationQuery="select count(*) from ode_process"/>
> >
> > </Context>
> >
> >
> >
> > But with this I get the following:
> >
> >
> >
> > DEBUG - GeronimoLog.debug(66) | Invoking ODE using MEX
> > {MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client hqejbhcnphr2cxfe0gxg1r]
> calling {
> > http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initiate(...)}
> >
> > 10:59:37,852 DEBUG [ODEService] Invoking ODE using MEX
> > {MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client hqejbhcnphr2cxfe0gxg1r]
> calling {
> > http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initiate(...)}
> >
> > DEBUG - GeronimoLog.debug(66) | Message content:  <?xml version="1.0"
> > encoding="UTF-8"?>
> >
> > <message><processInstanceID xmlns:ns1="http://OPM_modifyObject.wsdl"
> > xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/
> ">OPM_modifyObject-1182157173</processInstanceID><userID
> > xmlns:ns1="http://OPM_modifyObject.wsdl" xm
> >
> > k xmlns:ns1="http://OPM_modifyObject.wsdl" xmlns:soapenv="
> > http://schemas.xmlsoap.org/soap/envelope/">Vet gaaf
> > man</feedback></message>
> >
> > 10:59:37,852 DEBUG [ODEService] Message content:  <?xml version="1.0"
> > encoding="UTF-8"?>
> >
> > <message><processInstanceID xmlns:ns1="http://OPM_modifyObject.wsdl"
> > xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/
> ">OPM_modifyObject-1182157173</processInstanceID><userID
> > xmlns:ns1="http://OPM_modifyObject.wsdl" xm
> >
> > k xmlns:ns1="http://OPM_modifyObject.wsdl" xmlns:soapenv="
> > http://schemas.xmlsoap.org/soap/envelope/">Vet gaaf
> > man</feedback></message>
> >
> > DEBUG - GeronimoLog.debug(66) | Routed: svcQname {
> > http://OPM_modifyObject.wsdl}OPM_modifyObjectService --> BpelProcess[{
> > http://OPM_modifyObject}OPM_modifyObject-4]
> >
> > 10:59:37,872 DEBUG [BpelEngineImpl] Routed: svcQname {
> > http://OPM_modifyObject.wsdl}OPM_modifyObjectService --> BpelProcess[{
> > http://OPM_modifyObject}OPM_modifyObject-4]
> >
> > DEBUG - GeronimoLog.debug(66) | invoke() EPR= null ==> BpelProcess[{
> > http://OPM_modifyObject}OPM_modifyObject-4]
> >
> > 10:59:37,882 DEBUG [MyRoleMessageExchangeImpl] invoke() EPR= null ==>
> > BpelProcess[{http://OPM_modifyObject}OPM_modifyObject-4]
> >
> > DEBUG - GeronimoLog.debug(66) | Commiting ODE MEX
> > {MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client hqejbhcnphr2cxfe0gxg1r]
> calling {
> > http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initiate(...)}
> >
> > 10:59:38,073 DEBUG [ODEService] Commiting ODE MEX
> > {MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client hqejbhcnphr2cxfe0gxg1r]
> calling {
> > http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initiate(...)}
> >
> > DEBUG - GeronimoLog.debug(66) | Commiting transaction.
> >
> > 10:59:38,073 DEBUG [ODEService] Commiting transaction.
> >
> > ERROR - GeronimoLog.error(104) | Timeout or execution error when waiting
> > for response to MEX {MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client
> > hqejbhcnphr2cxfe0gxg1r] calling {
> > http://OPM_modifyObject.wsdl}OPM_modifyObjectService.init
> >
> > he.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@23d87f timed
> > out when waiting for a response!
> >
> > 11:01:38,516 ERROR [ODEService] Timeout or execution error when waiting
> > for response to MEX {MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client
> > hqejbhcnphr2cxfe0gxg1r] calling {
> > http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initi
> >
> > e.ode.bpel.engine.MyRoleMessageExchangeImpl$ResponseFuture@23d87f timed
> > out when waiting for a response!
> >
> > ERROR - GeronimoLog.error(108) | Servlet.service() for servlet
> AxisServlet
> > threw exception
> >
> > java.lang.NullPointerException
> >
> >         at
> >
> org.apache.axis2.engine.AxisEngine.extractFaultInformationFromMessageContext
> > (AxisEngine.java:353)
> >
> >         at org.apache.axis2.engine.AxisEngine.createFaultMessageContext(
> > AxisEngine.java:249)
> >
> >         at org.apache.axis2.transport.http.AxisServlet.handleFault(
> > AxisServlet.java:317)
> >
> >         at org.apache.axis2.transport.http.AxisServlet.doPost(
> > AxisServlet.java:277)
> >
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> >
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > ApplicationFilterChain.java:252)
> >
> >         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:173)
> >
> >         at org.apache.catalina.core.StandardWrapperValve.invoke(
> > StandardWrapperValve.java:213)
> >
> >         at org.apache.catalina.core.StandardContextValve.invoke(
> > StandardContextValve.java:178)
> >
> >         at org.apache.catalina.core.StandardHostValve.invoke(
> > StandardHostValve.java:126)
> >
> >         at org.apache.catalina.valves.ErrorReportValve.invoke(
> > ErrorReportValve.java:105)
> >
> >         at org.apache.catalina.core.StandardEngineValve.invoke(
> > StandardEngineValve.java:107)
> >
> >         at org.apache.catalina.connector.CoyoteAdapter.service(
> > CoyoteAdapter.java:148)
> >
> >         at org.apache.coyote.http11.Http11Processor.process(
> > Http11Processor.java:869)
> >
> >         at
> >
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> > (Http11BaseProtocol.java:664)
> >
> >         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> > PoolTcpEndpoint.java:527)
> >
> >         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> > LeaderFollowerWorkerThread.java:80)
> >
> >         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (
> > ThreadPool.java:684)
> >
> >         at java.lang.Thread.run(Thread.java:595)
> >
> > 11:01:38,626 ERROR [[AxisServlet]] Servlet.service() for servlet
> > AxisServlet threw exception
> >
> > java.lang.NullPointerException
> >
> >         at
> >
> org.apache.axis2.engine.AxisEngine.extractFaultInformationFromMessageContext
> > (AxisEngine.java:353)
> >
> >         at org.apache.axis2.engine.AxisEngine.createFaultMessageContext(
> > AxisEngine.java:249)
> >
> >         at org.apache.axis2.transport.http.AxisServlet.handleFault(
> > AxisServlet.java:317)
> >
> >         at org.apache.axis2.transport.http.AxisServlet.doPost(
> > AxisServlet.java:277)
> >
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> >
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > ApplicationFilterChain.java:252)
> >
> >         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:173)
> >
> >         at org.apache.catalina.core.StandardWrapperValve.invoke(
> > StandardWrapperValve.java:213)
> >
> >         at org.apache.catalina.core.StandardContextValve.invoke(
> > StandardContextValve.java:178)
> >
> >         at org.apache.catalina.core.StandardHostValve.invoke(
> > StandardHostValve.java:126)
> >
> >         at org.apache.catalina.valves.ErrorReportValve.invoke(
> > ErrorReportValve.java:105)
> >
> >         at org.apache.catalina.core.StandardEngineValve.invoke(
> > StandardEngineValve.java:107)
> >
> >         at org.apache.catalina.connector.CoyoteAdapter.service(
> > CoyoteAdapter.java:148)
> >
> >         at org.apache.coyote.http11.Http11Processor.process(
> > Http11Processor.java:869)
> >
> >         at
> >
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> > (Http11BaseProtocol.java:664)
> >
> >         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> > PoolTcpEndpoint.java:527)
> >
> >         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> > LeaderFollowerWorkerThread.java:80)
> >
> >         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (
> > ThreadPool.java:684)
> >
> >         at java.lang.Thread.run(Thread.java:595)
> >
> > ERROR - GeronimoLog.error(108) | Servlet.service() for servlet jsp threw
> > exception
> >
> > java.lang.IllegalStateException: getOutputStream() has already been
> called
> > for this response
> >
> >         at org.apache.catalina.connector.Response.getWriter(
> Response.java
> > :599)
> >
> >         at org.apache.catalina.connector.ResponseFacade.getWriter(
> > ResponseFacade.java:195)
> >
> >         at org.apache.jasper.runtime.JspWriterImpl.initOut(
> > JspWriterImpl.java:124)
> >
> >         at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(
> > JspWriterImpl.java:117)
> >
> >         at org.apache.jasper.runtime.PageContextImpl.release(
> > PageContextImpl.java:182)
> >
> >         at
> > org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(
> > JspFactoryImpl.java:115)
> >
> >         at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(
> > JspFactoryImpl.java:75)
> >
> >         at org.apache.jsp.axis2_002dweb.Error.error500_jsp._jspService
> > (error500_jsp.java:97)
> >
> >         at org.apache.jasper.runtime.HttpJspBase.service(
> HttpJspBase.java
> > :97)
> >
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >
> >         at org.apache.jasper.servlet.JspServletWrapper.service(
> > JspServletWrapper.java:334)
> >
> >         at org.apache.jasper.servlet.JspServlet.serviceJspFile(
> > JspServlet.java:314)
> >
> >         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java
> > :264)
> >
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > ApplicationFilterChain.java:252)
> >
> >         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:173)
> >
> >         at org.apache.catalina.core.ApplicationDispatcher.invoke(
> > ApplicationDispatcher.java:672)
> >
> >         at org.apache.catalina.core.ApplicationDispatcher.processRequest
> (
> > ApplicationDispatcher.java:465)
> >
> >         at org.apache.catalina.core.ApplicationDispatcher.doForward(
> > ApplicationDispatcher.java:398)
> >
> >         at org.apache.catalina.core.ApplicationDispatcher.forward(
> > ApplicationDispatcher.java:301)
> >
> >         at org.apache.catalina.core.StandardHostValve.custom(
> > StandardHostValve.java:363)
> >
> >         at org.apache.catalina.core.StandardHostValve.status(
> > StandardHostValve.java:284)
> >
> >         at org.apache.catalina.core.StandardHostValve.throwable(
> > StandardHostValve.java:228)
> >
> >         at org.apache.catalina.core.StandardHostValve.invoke(
> > StandardHostValve.java:134)
> >
> >         at org.apache.catalina.valves.ErrorReportValve.invoke(
> > ErrorReportValve.java:105)
> >
> >         at org.apache.catalina.core.StandardEngineValve.invoke(
> > StandardEngineValve.java:107)
> >
> >         at org.apache.catalina.connector.CoyoteAdapter.service(
> > CoyoteAdapter.java:148)
> >
> >         at org.apache.coyote.http11.Http11Processor.process(
> > Http11Processor.java:869)
> >
> >         at
> >
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> > (Http11BaseProtocol.java:664)
> >
> >         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> > PoolTcpEndpoint.java:527)
> >
> >         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> > LeaderFollowerWorkerThread.java:80)
> >
> >         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (
> > ThreadPool.java:684)
> >
> >         at java.lang.Thread.run(Thread.java:595)
> >
> > 11:01:39,307 ERROR [[jsp]] Servlet.service() for servlet jsp threw
> > exception
> >
> > java.lang.IllegalStateException: getOutputStream() has already been
> called
> > for this response
> >
> >         at org.apache.catalina.connector.Response.getWriter(
> Response.java
> > :599)
> >
> >         at org.apache.catalina.connector.ResponseFacade.getWriter(
> > ResponseFacade.java:195)
> >
> >         at org.apache.jasper.runtime.JspWriterImpl.initOut(
> > JspWriterImpl.java:124)
> >
> >         at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(
> > JspWriterImpl.java:117)
> >
> >         at org.apache.jasper.runtime.PageContextImpl.release(
> > PageContextImpl.java:182)
> >
> >         at
> > org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(
> > JspFactoryImpl.java:115)
> >
> >         at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(
> > JspFactoryImpl.java:75)
> >
> >         at org.apache.jsp.axis2_002dweb.Error.error500_jsp._jspService
> > (error500_jsp.java:97)
> >
> >         at org.apache.jasper.runtime.HttpJspBase.service(
> HttpJspBase.java
> > :97)
> >
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >
> >         at org.apache.jasper.servlet.JspServletWrapper.service(
> > JspServletWrapper.java:334)
> >
> >         at org.apache.jasper.servlet.JspServlet.serviceJspFile(
> > JspServlet.java:314)
> >
> >         at org.apache.jasper.servlet.JspServlet.service(JspServlet.java
> > :264)
> >
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> >
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> > ApplicationFilterChain.java:252)
> >
> >         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> > ApplicationFilterChain.java:173)
> >
> >         at org.apache.catalina.core.ApplicationDispatcher.invoke(
> > ApplicationDispatcher.java:672)
> >
> >         at org.apache.catalina.core.ApplicationDispatcher.processRequest
> (
> > ApplicationDispatcher.java:465)
> >
> >         at org.apache.catalina.core.ApplicationDispatcher.doForward(
> > ApplicationDispatcher.java:398)
> >
> >         at org.apache.catalina.core.ApplicationDispatcher.forward(
> > ApplicationDispatcher.java:301)
> >
> >         at org.apache.catalina.core.StandardHostValve.custom(
> > StandardHostValve.java:363)
> >
> >         at org.apache.catalina.core.StandardHostValve.status(
> > StandardHostValve.java:284)
> >
> >         at org.apache.catalina.core.StandardHostValve.throwable(
> > StandardHostValve.java:228)
> >
> >         at org.apache.catalina.core.StandardHostValve.invoke(
> > StandardHostValve.java:134)
> >
> >         at org.apache.catalina.valves.ErrorReportValve.invoke(
> > ErrorReportValve.java:105)
> >
> >         at org.apache.catalina.core.StandardEngineValve.invoke(
> > StandardEngineValve.java:107)
> >
> >         at org.apache.catalina.connector.CoyoteAdapter.service(
> > CoyoteAdapter.java:148)
> >
> >         at org.apache.coyote.http11.Http11Processor.process(
> > Http11Processor.java:869)
> >
> >         at
> >
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
> > (Http11BaseProtocol.java:664)
> >
> >         at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
> > PoolTcpEndpoint.java:527)
> >
> >         at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
> > LeaderFollowerWorkerThread.java:80)
> >
> >         at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (
> > ThreadPool.java:684)
> >
> >         at java.lang.Thread.run(Thread.java:595)
> >
> >
> >
> > The process I'm using worked fine with the internal database. The
> > deployment of the process was also OK. It was added to the external
> database
> > in the bpel_process table.
> >
> >
> >
> > In <TOMCAT_INSTALL_DIR>\webapps\ode\WEB_INF\web.xml I found the
> following
> > lines. As the say I uncommented them to for testing, but the  same error
> as
> > above.
> >
> > <!-- UNCOMMENT TO USE APPSERVER DATASOURCE -->
> >
> > <resource-ref>
> >
> >             <res-ref-name>jdbc/OdeDB</res-ref-name>
> >
> >             <res-type>javax.sql.DataSource</res-type>
> >
> >             <res-auth>Container</res-auth>
> >
> >             <res-sharing-scope>Shareable</res-sharing-scope>
> >
> > </resource-ref>
> >
> > <!--  UNCOMMENT TO USE APPSERVER DATASOURCE -->
> >
> >
> >
> > What can be wrong? I used the mysql.sql you provided.
> >
> >
> >
> > Thanks!
> >
> >             Rene
> >
> >
> >
> > ________________________________
> >
> > From: Matthieu Riou [mailto:matthieu.riou@gmail.com]
> > Sent: dinsdag 12 juni 2007 16:54
> > To: ode-user@incubator.apache.org
> > Subject: Re: Running Ode using an external database (MySql)
> >
> >
> >
> > Hi Michael,
> >
> > I've just cleaned that up a bit, there were a couple of issues there. So
> > to build the MySQL schema you just need to go into the
> dao-jpa-ojpa-derby
> > module and run 'rake build'. This should produce a schema for MySQL in
> the
> > target directory. Alternatively I've attached the result to this e-mail
> if
> > it's easier for you.
> >
> > Once MySQL is setup, you just need to configure ODE to use the
> datasource
> > you've configured in your application server. Just edit
> > ode-axis2.properties and set the 2 following properties:
> >
> > ode-axis2.db.mode=EXTERNAL
> > ode-axis2.db.ext.dataSource=java:comp/env/jdbc/MYDS
> >
> > That should be it. If you can write down the different steps you
> followed
> > to make this work with your application server, we'd be more than happy
> to
> > publish it as a small "how to" so others can reuse it :)
> >
> > Thanks,
> > Matthieu
> >
> > On 6/12/07, Michael Horwitz <mike.horwitz@gmail.com> wrote:
> >
> > Hi,
> >
> > There are various cryptic hints around the site that Ode can be run
> > against
> > an external database. I have been experiencing a few problems with the
> > Quartz scheduler not being able to get a connection to the embedded
> > database
> > when running asynchronous processes and would like to try running
> against
> > MySql to see if it will solve my problems. Are there any scripts
> available
> > to create the database?
> >
> > Thanks
> >
> > Mike Horwitz
> >
> >
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message