Hi Rene,
Sorry for the late reply, we're having some issues with bugs in Axis2 1.1.1(and
1.2 as well actually) that prevent seeing the original problem that caused a
fault. I've changed the build to use a patched version of axis2-kernel that
solves this problems. So could you rebuild ODE from the trunk and try again?
This way we'll know exactly what's wrong instead of trying to shoot in the
dark.
Thanks,
Matthieu
On 6/18/07, René Bos <[EMAIL PROTECTED]> wrote:
Hi,
I just had time to work on the external (MySQL) database connection.
As you said I made the ode-axis2.properties file with the following
contents:
ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/OdeDB
I placed a file mysql-connector-java-5.0.6-bin.jar in the
<TOMCAT_INSTALL_DIR>\common\libs dir.
In <TOMCAT_INSTALL_DIR>\conf\Catalina\localhost I added a file named
ode.xml with the following contents:
<Context path="/Ode" docBase="ode" debug="5"
reloadable="true" crossContext="true">
<Resource name="jdbc/OdeDB"
auth="Container"
type="
javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000"
username="username"
password="password"
driverClassName="
com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ode?autoReconnect=true"
validationQuery="select count(*) from ode_process"/>
</Context>
But with this I get the following:
DEBUG - GeronimoLog.debug(66) | Invoking ODE using MEX
{MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client hqejbhcnphr2cxfe0gxg1r] calling {
http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initiate(...)}
10:59:37,852 DEBUG [ODEService] Invoking ODE using MEX
{MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client hqejbhcnphr2cxfe0gxg1r] calling {
http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initiate(...)}
DEBUG - GeronimoLog.debug(66) | Message content: <?xml version="1.0"
encoding="UTF-8"?>
<message><processInstanceID xmlns:ns1="http://OPM_modifyObject.wsdl";
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";>OPM_modifyObject-1182157173</processInstanceID><userID
xmlns:ns1="http://OPM_modifyObject.wsdl"; xm
k xmlns:ns1="http://OPM_modifyObject.wsdl"; xmlns:soapenv="
http://schemas.xmlsoap.org/soap/envelope/";>Vet gaaf
man</feedback></message>
10:59:37,852 DEBUG [ODEService] Message content: <?xml version="1.0"
encoding="UTF-8"?>
<message><processInstanceID xmlns:ns1="http://OPM_modifyObject.wsdl";
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/";>OPM_modifyObject-1182157173</processInstanceID><userID
xmlns:ns1="http://OPM_modifyObject.wsdl"; xm
k xmlns:ns1="http://OPM_modifyObject.wsdl"; xmlns:soapenv="
http://schemas.xmlsoap.org/soap/envelope/";>Vet gaaf
man</feedback></message>
DEBUG - GeronimoLog.debug(66) | Routed: svcQname {
http://OPM_modifyObject.wsdl}OPM_modifyObjectService --> BpelProcess[{
http://OPM_modifyObject}OPM_modifyObject-4]
10:59:37,872 DEBUG [BpelEngineImpl] Routed: svcQname {
http://OPM_modifyObject.wsdl}OPM_modifyObjectService --> BpelProcess[{
http://OPM_modifyObject}OPM_modifyObject-4]
DEBUG - GeronimoLog.debug(66) | invoke() EPR= null ==> BpelProcess[{
http://OPM_modifyObject}OPM_modifyObject-4]
10:59:37,882 DEBUG [MyRoleMessageExchangeImpl] invoke() EPR= null ==>
BpelProcess[{http://OPM_modifyObject}OPM_modifyObject-4]
DEBUG - GeronimoLog.debug(66) | Commiting ODE MEX
{MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client hqejbhcnphr2cxfe0gxg1r] calling {
http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initiate(...)}
10:59:38,073 DEBUG [ODEService] Commiting ODE MEX
{MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client hqejbhcnphr2cxfe0gxg1r] calling {
http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initiate(...)}
DEBUG - GeronimoLog.debug(66) | Commiting transaction.
10:59:38,073 DEBUG [ODEService] Commiting transaction.
ERROR - GeronimoLog.error(104) | Timeout or execution error when waiting
for response to MEX {MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client
hqejbhcnphr2cxfe0gxg1r] calling {
http://OPM_modifyObject.wsdl}OPM_modifyObjectService.init
[EMAIL PROTECTED] timed
out when waiting for a response!
11:01:38,516 ERROR [ODEService] Timeout or execution error when waiting
for response to MEX {MyRoleMex#hqejbhcnphr2cxfe0gxg1s [Client
hqejbhcnphr2cxfe0gxg1r] calling {
http://OPM_modifyObject.wsdl}OPM_modifyObjectService.initi
[EMAIL PROTECTED] timed
out when waiting for a response!
ERROR - GeronimoLog.error(108) | Servlet.service() for servlet AxisServlet
threw exception
java.lang.NullPointerException
at
org.apache.axis2.engine.AxisEngine.extractFaultInformationFromMessageContext
(AxisEngine.java:353)
at org.apache.axis2.engine.AxisEngine.createFaultMessageContext(
AxisEngine.java:249)
at org.apache.axis2.transport.http.AxisServlet.handleFault(
AxisServlet.java:317)
at org.apache.axis2.transport.http.AxisServlet.doPost(
AxisServlet.java:277)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
11:01:38,626 ERROR [[AxisServlet]] Servlet.service() for servlet
AxisServlet threw exception
java.lang.NullPointerException
at
org.apache.axis2.engine.AxisEngine.extractFaultInformationFromMessageContext
(AxisEngine.java:353)
at org.apache.axis2.engine.AxisEngine.createFaultMessageContext(
AxisEngine.java:249)
at org.apache.axis2.transport.http.AxisServlet.handleFault(
AxisServlet.java:317)
at org.apache.axis2.transport.http.AxisServlet.doPost(
AxisServlet.java:277)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(
StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(
StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
ERROR - GeronimoLog.error(108) | Servlet.service() for servlet jsp threw
exception
java.lang.IllegalStateException: getOutputStream() has already been called
for this response
at org.apache.catalina.connector.Response.getWriter(Response.java
:599)
at org.apache.catalina.connector.ResponseFacade.getWriter(
ResponseFacade.java:195)
at org.apache.jasper.runtime.JspWriterImpl.initOut(
JspWriterImpl.java:124)
at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(
JspWriterImpl.java:117)
at org.apache.jasper.runtime.PageContextImpl.release(
PageContextImpl.java:182)
at
org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(
JspFactoryImpl.java:115)
at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(
JspFactoryImpl.java:75)
at org.apache.jsp.axis2_002dweb.Error.error500_jsp._jspService
(error500_jsp.java:97)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java
:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(
JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(
JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java
:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(
ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(
ApplicationDispatcher.java:465)
at org.apache.catalina.core.ApplicationDispatcher.doForward(
ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(
ApplicationDispatcher.java:301)
at org.apache.catalina.core.StandardHostValve.custom(
StandardHostValve.java:363)
at org.apache.catalina.core.StandardHostValve.status(
StandardHostValve.java:284)
at org.apache.catalina.core.StandardHostValve.throwable(
StandardHostValve.java:228)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:134)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
11:01:39,307 ERROR [[jsp]] Servlet.service() for servlet jsp threw
exception
java.lang.IllegalStateException: getOutputStream() has already been called
for this response
at org.apache.catalina.connector.Response.getWriter(Response.java
:599)
at org.apache.catalina.connector.ResponseFacade.getWriter(
ResponseFacade.java:195)
at org.apache.jasper.runtime.JspWriterImpl.initOut(
JspWriterImpl.java:124)
at org.apache.jasper.runtime.JspWriterImpl.flushBuffer(
JspWriterImpl.java:117)
at org.apache.jasper.runtime.PageContextImpl.release(
PageContextImpl.java:182)
at
org.apache.jasper.runtime.JspFactoryImpl.internalReleasePageContext(
JspFactoryImpl.java:115)
at org.apache.jasper.runtime.JspFactoryImpl.releasePageContext(
JspFactoryImpl.java:75)
at org.apache.jsp.axis2_002dweb.Error.error500_jsp._jspService
(error500_jsp.java:97)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java
:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(
JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(
JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java
:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(
ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(
ApplicationDispatcher.java:465)
at org.apache.catalina.core.ApplicationDispatcher.doForward(
ApplicationDispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(
ApplicationDispatcher.java:301)
at org.apache.catalina.core.StandardHostValve.custom(
StandardHostValve.java:363)
at org.apache.catalina.core.StandardHostValve.status(
StandardHostValve.java:284)
at org.apache.catalina.core.StandardHostValve.throwable(
StandardHostValve.java:228)
at org.apache.catalina.core.StandardHostValve.invoke(
StandardHostValve.java:134)
at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(
StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(
CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(
Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection
(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(
PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(
LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(
ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
The process I'm using worked fine with the internal database. The
deployment of the process was also OK. It was added to the external database
in the bpel_process table.
In <TOMCAT_INSTALL_DIR>\webapps\ode\WEB_INF\web.xml I found the following
lines. As the say I uncommented them to for testing, but the same error as
above.
<!-- UNCOMMENT TO USE APPSERVER DATASOURCE -->
<resource-ref>
<res-ref-name>jdbc/OdeDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
<!-- UNCOMMENT TO USE APPSERVER DATASOURCE -->
What can be wrong? I used the mysql.sql you provided.
Thanks!
Rene
________________________________
From: Matthieu Riou [mailto:[EMAIL PROTECTED]
Sent: dinsdag 12 juni 2007 16:54
To: [email protected]
Subject: Re: Running Ode using an external database (MySql)
Hi Michael,
I've just cleaned that up a bit, there were a couple of issues there. So
to build the MySQL schema you just need to go into the dao-jpa-ojpa-derby
module and run 'rake build'. This should produce a schema for MySQL in the
target directory. Alternatively I've attached the result to this e-mail if
it's easier for you.
Once MySQL is setup, you just need to configure ODE to use the datasource
you've configured in your application server. Just edit
ode-axis2.properties and set the 2 following properties:
ode-axis2.db.mode=EXTERNAL
ode-axis2.db.ext.dataSource=java:comp/env/jdbc/MYDS
That should be it. If you can write down the different steps you followed
to make this work with your application server, we'd be more than happy to
publish it as a small "how to" so others can reuse it :)
Thanks,
Matthieu
On 6/12/07, Michael Horwitz <[EMAIL PROTECTED]> wrote:
Hi,
There are various cryptic hints around the site that Ode can be run
against
an external database. I have been experiencing a few problems with the
Quartz scheduler not being able to get a connection to the embedded
database
when running asynchronous processes and would like to try running against
MySql to see if it will solve my problems. Are there any scripts available
to create the database?
Thanks
Mike Horwitz
