Thank you Alex,
That was the commons-httpclient version issue.
Now Ode deployed under JBoss with MySQL, invokes an external web service.
On Reply, It throws Hibernate Exception as below.
Then I deployed the HelloWorld2 example, which comes with Ode example.
Now Ode throws the same old NullPointerException? (Used as directed in Ode
web site).
Anybody tried ODE with JBoss and MySQL?
Thank you
Raja
------------------------------------------
[STDOUT] Hibernate: insert into BPEL_MESSAGE (MEX, TYPE, DATA,
INSERT_TIME, MLOCK) values (?, ?, ?, ?, ?)
[STDOUT] Hibernate: insert into LARGE_DATA (BIN_DATA, INSERT_TIME, MLOCK)
values (?, ?, ?)
[ExternalService] Unable to process response: Illegal attempt to associate
a collection with two open sessions
org.hibernate.HibernateException: Illegal attempt to associate a
collection with two open sessions
at
org.hibernate.collection.AbstractPersistentCollection.setCurrentSession(Ab
stractPersistentCollection.java:410)
at
org.hibernate.event.def.OnUpdateVisitor.processCollection(OnUpdateVisitor.
java:40)
at
org.hibernate.event.def.AbstractVisitor.processValue(AbstractVisitor.java:
101)
at
org.hibernate.event.def.AbstractVisitor.processValue(AbstractVisitor.java:
61)
at
org.hibernate.event.def.AbstractVisitor.processEntityPropertyValues(Abstra
ctVisitor.java:55)
at
org.hibernate.event.def.AbstractVisitor.process(AbstractVisitor.java:123)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performUpdate(Def
aultSaveOrUpdateEventListener.java:268)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsDetached(
DefaultSaveOrUpdateEventListener.java:217)
at
org.hibernate.event.def.DefaultUpdateEventListener.performSaveOrUpdate(Def
aultUpdateEventListener.java:33)
at
org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(De
faultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireUpdate(SessionImpl.java:564)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:552)
at org.hibernate.impl.SessionImpl.update(SessionImpl.java:544)
at
org.apache.ode.daohib.bpel.HibernateDao.update(HibernateDao.java:64)
at
org.apache.ode.daohib.bpel.MessageExchangeDaoImpl.setStatus(MessageExchang
eDaoImpl.java:82)
at
org.apache.ode.bpel.engine.MessageExchangeImpl.setStatus(MessageExchangeIm
pl.java:192)
at
org.apache.ode.bpel.engine.MessageExchangeImpl.setResponse(MessageExchange
Impl.java:181)
at
org.apache.ode.bpel.engine.PartnerRoleMessageExchangeImpl.reply(PartnerRol
eMessageExchangeImpl.java:68)
at
org.apache.ode.axis2.ExternalService$3.call(ExternalService.java:288)
at
org.apache.ode.axis2.ExternalService$3.call(ExternalService.java:270)
at
org.apache.ode.bpel.scheduler.quartz.QuartzSchedulerImpl.execTransaction(Q
uartzSchedulerImpl.java:243)
at
org.apache.ode.bpel.scheduler.quartz.QuartzSchedulerImpl$1.call(QuartzSche
dulerImpl.java:271)
at
java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:269)
at java.util.concurrent.FutureTask.run(FutureTask.java:123)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.
java:650)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java
:675)
at java.lang.Thread.run(Thread.java:595)
ERROR [ODEService] Timeout when waiting for response to MEX null
------------------------------------------
-----Original Message-----
From: Alex Boisvert [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 15, 2007 12:39 PM
To: [email protected]
Subject: Re: Ode with JBoss and MySQL
This exception:
java.lang.NoSuchMethodError:
org.apache.commons.httpclient.HttpConnectionManager.getParams
()Lorg/apache/commons/httpclient/params/HttpConnectionManagerParams;
indicates the wrong version of commons-httpclient in your Ode classloading
hierarchy. Make sure you have commons-httpclient-3.0.1.jar under
WEB-INF/lib and that your webapp classloader is configured to use this
version over the version shipped with JBoss.
alex
On 2/15/07, Raja Balasubramanian/MAXIMUS <[EMAIL PROTECTED]>
wrote:
>
> I forgot to include the stack trace.
> JBoss with MySQL Execution exception:
>
> ----------------------------------------------
> DEBUG [org.hibernate.SQL] insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
> MLOCK) values (?, ?, ?)
> INFO [STDOUT] Hibernate: insert into LARGE_DATA (BIN_DATA, INSERT_TIME,
> MLOCK) values (?, ?, ?)
> DEBUG [org.hibernate.id.IdentifierGeneratorFactory] Natively generated
> identity: 31
> DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close
> PreparedStatement (open PreparedStatements: 1, globally: 1)
> DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC
> connection
> DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [
> (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally:
> 0)]
> ERROR [org.apache.ode.axis2.ExternalService] Error sending message to
> Axis2 for ODE mex {PartnerRoleMex#2 [PID
> {http://sdc.maximus.com/Process1/SimpleProcess}SimpleProcess-1] calling
> [EMAIL PROTECTED](...)}
> java.lang.NoSuchMethodError:
>
org.apache.commons.httpclient.HttpConnectionManager.getParams()Lorg/apache
> /commons/httpclient/params/HttpConnectionManagerParams;
> at
>
org.apache.axis2.transport.http.AbstractHTTPSender.getHttpClient(AbstractH
> TTPSender.java:508)
> at
>
org.apache.axis2.transport.http.SOAPOverHTTPSender.send(SOAPOverHTTPSender
> .java:55)
> at
>
org.apache.axis2.transport.http.CommonsHTTPTransportSender.writeMessageWit
> hCommons(CommonsHTTPTransportSender.java:334)
> at
>
org.apache.axis2.transport.http.CommonsHTTPTransportSender.invoke(CommonsH
> TTPTransportSender.java:205)
> at org.apache.axis2.engine.AxisEngine.send(AxisEngine.java:670)
> at
>
org.apache.axis2.description.OutInAxisOperationClient.send(OutInAxisOperat
> ion.java:365)
> at
>
org.apache.axis2.description.OutInAxisOperationClient.execute(OutInAxisOpe
> ration.java:295)
> at
>
org.apache.ode.axis2.ExternalService$1.afterCompletion(ExternalService.jav
> a:134)
> at
>
org.apache.ode.bpel.scheduler.quartz.QuartzSchedulerImpl$2.afterCompletion
> (QuartzSchedulerImpl.java:385)
> at
>
org.jboss.tm.TransactionImpl.doAfterCompletion(TransactionImpl.java:1526)
> at
>
org.jboss.tm.TransactionImpl.completeTransaction(TransactionImpl.java:1198
> )
> at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:377)
> at org.jboss.tm.TxManager.commit(TxManager.java:240)
> at
>
org.apache.ode.axis2.ODEService.onAxisMessageExchange(ODEService.java:138)
> at
>
org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessa
> geReceiver.java:78)
> at
>
org.apache.ode.axis2.hooks.ODEMessageReceiver.receive(ODEMessageReceiver.j
> ava:53)
> at
org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:493)
> at
>
org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(
> HTTPTransportUtils.java:319)
> at
> org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:247)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:252)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:173)
> at
>
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.
> java:96)
> at
>
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicati
> onFilterChain.java:202)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilter
> Chain.java:173)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.
> java:213)
> at
>
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.
> java:178)
> at
>
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAsso
> ciationValve.java:175)
> at
>
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.jav
> a:74)
> at
>
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:1
> 26)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:1
> 05)
> at
>
org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnection
> Valve.java:156)
> at
>
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.ja
> va: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.proces
> sConnection(Http11BaseProtocol.java:664)
> at
>
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.j
> ava:527)
> at
>
org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerTh
> read.java:112)
> at java.lang.Thread.run(Thread.java:595)
> DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp:
> 11714971745
> ----------------------------------------------
>
> -----Original Message-----
> From: Raja Balasubramanian
> Sent: Thursday, February 15, 2007 11:35 AM
> To: [email protected]
> Subject: Ode with JBoss and MySQL
>
> Hello,
>
> Now I'm trying Ode with JBoss and MySQL.
> When I invoke a process, Ode throws exception says 'Error sending
message
> to Axis2 for ODE mex..'
> It's very strange that Ode behaves differently with different databases
> and different app servers.
> Here is the behavior of Ode with Different Appservers and Database
servers
> for a Process (Using the same process for all tests)
>
> 1. With Geronimo and MySQL, Works OK, but dead lock occurs when
> invoking the same process continuously.(Failed my load test)
>
> 2. With Geronimo and Oracle, dead lock occurs. (Jira issue
ODE-96)
>
> 3. With JBoss and Oracle, I'm not even able to start a process
> (NPE).
>
> 4. With JBoss and MySQL, I'm able to start a process, but the
> process is not contact a web service (Part of process). Stack
> trace follows.
>
> Could somebody guide me, which is the right App server and data base
> server combination for Ode, to get stable and reliable Ode runtime.
>
> Obviously I can't use Geronimo with Derby in any QA or Production
> environment.
> To Use ODE, which is the right environment?
>
> How is it possible to get a reliable and stable version of Ode, for a QA
> environment?
>
> Or Am I missing something in Ode settings?
> Somebody help me to get a stable Ode. Please.
>
> Thank you
> Raja
>