ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From René Bos <r....@pagelink.nl>
Subject RE: Running Ode using an external database (MySql)
Date Thu, 21 Jun 2007 10:54:56 GMT
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@1dd8664 timed 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@1dd8664 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)
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
View raw message