Hi! I double checked it for you, but it isn't there. Only the patched kernel.
I also double checked the error, but it is the same as the one I posted. René -----Original Message----- From: Matthieu Riou [mailto:[EMAIL PROTECTED] Sent: donderdag 21 juni 2007 16:04 To: [email protected] Subject: Re: Running Ode using an external database (MySql) 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 <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > 10:39:41,164 DEBUG [ODEAxisDispatcher] Found operation > [EMAIL PROTECTED] > 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 > [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > Sent: woensdag 20 juni 2007 10:44 > To: [email protected] > 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:[EMAIL PROTECTED] > Sent: dinsdag 19 juni 2007 20:53 > To: [email protected] > 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 <[EMAIL PROTECTED]> 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 > > > > [EMAIL PROTECTED] 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 > > > > [EMAIL PROTECTED] 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:[EMAIL PROTECTED] > > Sent: dinsdag 12 juni 2007 16:54 > > To: [email protected] > > 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 <[EMAIL PROTECTED]> 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 > > > > > > > > >
