ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From René Bos <r...@rpsoft.nl>
Subject Re: Running Ode using an external database (MySql)
Date Wed, 27 Jun 2007 15:32:17 GMT
Do you have any idea to fix this?

René

René Bos schreef op 21-6-2007 16:46:
> I had all org.apache.ode logs on DEBUG except the .erp one. Turned that one also on, but no difference. 
>
> I tried without the external database, than this is logged at the point the timeout occurs.
>
> DEBUG - GeronimoLog.debug(66) | Invoking ODE using MEX {MyRoleMex#hqejbhcnphr2d950k7qbfs [Client hqejbhcnphr2d950k7qbfr] calling {http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> 12:21:35,443 DEBUG [ODEService] Invoking ODE using MEX {MyRoleMex#hqejbhcnphr2d950k7qbfs [Client hqejbhcnphr2d950k7qbfr] 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-Rex1182421295</processInstanceID></message>
> 12:21:35,443 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-Rex1182421295</processInstanceID></message>
> DEBUG - GeronimoLog.debug(66) | Routed: svcQname {http://Test_T-Rex.wsdl}Test_T-RexService --> BpelProcess[{http://Test_T-Rex}Test_T-Rex-2]
> 12:21:35,473 DEBUG [BpelEngineImpl] Routed: svcQname {http://Test_T-Rex.wsdl}Test_T-RexService --> BpelProcess[{http://Test_T-Rex}Test_T-Rex-2]
> DEBUG - GeronimoLog.debug(66) | invoke() EPR= null ==> BpelProcess[{http://Test_T-Rex}Test_T-Rex-2]
> 12:21:35,473 DEBUG [MyRoleMessageExchangeImpl] invoke() EPR= null ==> BpelProcess[{http://Test_T-Rex}Test_T-Rex-2]
> DEBUG - GeronimoLog.debug(66) | Commiting ODE MEX {MyRoleMex#hqejbhcnphr2d950k7qbfs [Client hqejbhcnphr2d950k7qbfr] calling {http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> 12:21:35,953 DEBUG [ODEService] Commiting ODE MEX {MyRoleMex#hqejbhcnphr2d950k7qbfs [Client hqejbhcnphr2d950k7qbfr] calling {http://Test_T-Rex.wsdl}Test_T-RexService.initiate(...)}
> DEBUG - GeronimoLog.debug(66) | Commiting transaction.
> 12:21:35,953 DEBUG [ODEService] Commiting transaction.
> DEBUG - GeronimoLog.debug(66) | >> handleWorkEvent(jobData=org.quartz.JobDataMap@a3ed9f)
> 12:21:36,484 DEBUG [BpelProcess] >> handleWorkEvent(jobData=org.quartz.JobDataMap@a3ed9f)
> DEBUG - GeronimoLog.debug(66) | InvokeInternal event for mexid hqejbhcnphr2d950k7qbfs
> 12:21:36,494 DEBUG [BpelProcess] InvokeInternal event for mexid hqejbhcnphr2d950k7qbfs
> DEBUG - GeronimoLog.trace(54) | >> {PartnerLinkRole-Test_T-RexLink.initiator on {http://Test_T-Rex.wsdl}Test_T-RexService:Test_T-RexPort}:inputMsgRcvd(messageExchange={MyRoleMex#hqejbhcnphr2d950k7qbfs [Client hqejbhcnphr2d950k7qbfr] calling {http://Aveleij
> nintranet_T-Rex.wsdl}Test_T-RexService.initiate(...)})
> 12:21:36,614 DEBUG [BpelProcess] >> {PartnerLinkRole-Test_T-RexLink.initiator on {http://Test_T-Rex.wsdl}Test_T-RexService:Test_T-RexPort}:inputMsgRcvd(messageExchange={MyRoleMex#hqejbhcnphr2d950k7qbfs [Client hqejbhcnphr2d950k7qbfr] calling {http://Avelei
> jnintranet_T-Rex.wsdl}Test_T-RexService.initiate(...)})
> DEBUG - GeronimoLog.trace(54) | Mex[hqejbhcnphr2d950k7qbfs].setPortOp(PortType: name={http://Test_T-Rex.wsdl}Test_T-RexPortType
>
> Maybe you can reproduce it by yourself? It is very simple to setup in Tomcat (I'm using tomcat..)
> Rene
>
> -----Original Message-----
> From: Matthieu Riou [mailto:matthieu.riou@gmail.com] 
> Sent: donderdag 21 juni 2007 16:36
> To: ode-user@incubator.apache.org
> Subject: Re: Running Ode using an external database (MySql)
>
> Okay. It's weird that you're still getting this NPE but anyway there's
> something wrong happening in the engine that prevents it from building the
> reply (and it then timeouts).
>
> Could you set the log category "org.apache.ode" to the debug log level? With
> more details regarding execution I might be able to guess what's going
> wrong. Given that the only difference is that you're running on MySQL I
> guess we get a database error but it's just really weird that it doesn't
> bubble up and appear in the logs.
>
> Matthieu
>
> On 6/21/07, René Bos <r.bos@pagelink.nl> wrote:
>   
>> 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:matthieu.riou@gmail.com]
>> Sent: donderdag 21 juni 2007 16:04
>> To: ode-user@incubator.apache.org
>> 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 <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@1dd8664timedout 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@1dd8664timedout 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@23d87ftimed
>>>> 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@23d87ftimed
>>>> 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