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=
[EMAIL PROTECTED])
> 12:21:36,484 DEBUG [BpelProcess] >> handleWorkEvent(jobData=
[EMAIL PROTECTED])
> 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:[EMAIL PROTECTED]
> Sent: donderdag 21 juni 2007 16:36
> To: [email protected]
> 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 <[EMAIL PROTECTED]> 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:[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] 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] 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]
>>>> 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]
>>>> 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
>>>>
>>>>
>>>>
>>>>
>>>>
