I saw something like this. Can you please put it in a spread sheet or send a image.
Thanks Milinda On Wed, Sep 9, 2009 at 6:57 PM, Ricardo Pereira <[email protected]>wrote: > Ok, thanks. > > Is it better now? The time is measured un miliseconds. The column "nr > clients" means the number of clients at the same time. > > nr clients Client 1 Client 2 Client 3 Client 4 Client 5 Client 6 > Client 7 Client 8 Client 9 Client 10 1 1471 2 > > 2367 > 2795 3 4125 4695 4930 4 2082 4079 3572 4440 > 5 6349 7546 5474 5193 5735 6 8004 7895 6385 7810 > 7232 7821 7 5803 14817 6711 3279 13987 6176 14519 8 67225 > 48365 62430 65197 57423 60281 59610 55120 9 4689 4674 91359 93934 > 72918 > 92163 91846 92255 94025 10 75327 88057 34761 84558 88647 18617 36859 > 64603 42752 > 39783 > > On Wed, Sep 9, 2009 at 1:59 PM, Milinda Pathirage < > [email protected]> wrote: > > > Hi Ricardo, > > > > there is a formatting issue in your statistics. Can reformat it and send. > > > > Thanks > > Milinda > > > > On Wed, Sep 9, 2009 at 6:27 PM, Milinda Pathirage < > > [email protected]> wrote: > > > > > Hi Ricardo, > > > > > > I am busy with a client issue. I'll get back to your problem ASAP. > > > > > > Thanks > > > Milinda > > > > > > > > > On Wed, Sep 9, 2009 at 5:22 PM, Ricardo Pereira < > > [email protected] > > > > wrote: > > > > > >> Hello Milinda, > > >> > > >> Sorry for asking i know you probably are busy, but are you still on > the > > >> case? > > >> > > >> > > >> Thanks, > > >> > > >> Ricardo > > >> On Tue, Sep 8, 2009 at 3:02 PM, Ricardo Pereira > > >> <[email protected]>wrote: > > >> > > >> > I suppose that the ode-axis2.properties file should be in the > > >> > \webapps\ode\WEB-INF\conf directory right? But that file isn't > there. > > >> There > > >> > is just one file that is axis2.xml. > > >> > > > >> > I have taking some statistics and watch this table. The left column > > >> shows > > >> > the number of clients at the same time. The other columns show the > > time > > >> in > > >> > miliseconds of the arrival of the response. The statistics of the > 10th > > >> > client was in one test that luckly theres was no problem with locks. > > The > > >> > invocation times are very high do you think that increasing the > > >> > ode-axis2.db.pool.max variable will avoid the locks problem and the > > high > > >> > times? > > >> > > > >> > Thanks > > >> > > > >> > > > >> > ODE 1 1471 2 2367 2795 3 4125 > > 4695 > > >> > 4930 4 2082 4079 3572 4440 5 6349 7546 > > 5474 > > >> > 5193 5735 6 8004 7895 6385 7810 7232 7821 7 5803 > > >> 14817 > > >> > 6711 3279 13987 6176 14519 8 67225 48365 62430 65197 57423 > > 60281 > > >> > 59610 55120 9 4689 4674 91359 93934 72918 92163 91846 92255 > 94025 > > >> > 10 75327 88057 34761 84558 88647 18617 36859 64603 42752 39783 > > >> > > > >> > > > >> > On Tue, Sep 8, 2009 at 11:36 AM, Milinda Pathirage < > > >> > [email protected]> wrote: > > >> > > > >> >> If you are using internal data source configuration, you can > increase > > >> the > > >> >> DB > > >> >> connection pool size using ode-axis2.db.pool.max property in > > >> >> ode-axis2.properties file. > > >> >> > > >> >> > > >> >> Thanks, > > >> >> Milinda > > >> >> > > >> >> On Tue, Sep 8, 2009 at 3:10 PM, Ricardo Pereira > > >> >> <[email protected]>wrote: > > >> >> > > >> >> > Hello Milinda, > > >> >> > > > >> >> > I think that increasing time out its not a good idea because with > > one > > >> >> > invocation the process ran in about 1,5s when i ran it using 9 > > >> >> invocations > > >> >> > it takes much more, about 80 secs. When I invoke it using 10 > > requests > > >> it > > >> >> > gives that Lock problems. I'm using this in a SOA so this > > >> transactions > > >> >> has > > >> >> > to be fast. > > >> >> > > > >> >> > The other sugestion you said can probably help but i don't know > how > > >> to > > >> >> > increase the number of connections of the connection pool. How > can > > i > > >> do > > >> >> it? > > >> >> > Do you have any more ideas? > > >> >> > > > >> >> > Thanks for your support > > >> >> > Ricardo > > >> >> > > > >> >> > On Tue, Sep 8, 2009 at 2:03 AM, Milinda Pathirage < > > >> >> > [email protected]> wrote: > > >> >> > > > >> >> > > Hi Ricardo, > > >> >> > > > > >> >> > > I didn't have time to look at your problem yesterday. I'll look > > at > > >> it > > >> >> > > today. > > >> >> > > It seems to me that it's a problem with JDBC connection pool. > > >> >> Application > > >> >> > > wait for 30000ms and no JDBC connection was available because > all > > >> the > > >> >> > > connections in the pool are checked out to other threads. You > can > > >> try > > >> >> to > > >> >> > > solve this by increasing time out or increasing number of > > >> connections > > >> >> in > > >> >> > > connection pool. > > >> >> > > > > >> >> > > Thanks > > >> >> > > Milinda > > >> >> > > > > >> >> > > On Mon, Sep 7, 2009 at 11:12 PM, Ricardo Pereira > > >> >> > > <[email protected]>wrote: > > >> >> > > > > >> >> > > > Milinda, i tried again to invoke the process using Jmeter. It > > >> seems > > >> >> to > > >> >> > be > > >> >> > > > some problem with the Locks, and now didn't give the database > > >> error > > >> >> > > > exception. The exception returned is below. I'm sending in > > attach > > >> >> the > > >> >> > log > > >> >> > > > file of this invocation. > > >> >> > > > > > >> >> > > > I don't know if I understood about the Derby DB. Could you me > > >> more > > >> >> > > precise? > > >> >> > > > > > >> >> > > > I apreciate your help > > >> >> > > > thanks > > >> >> > > > > > >> >> > > > PS: If you can't receive the log file in attach tell me a way > > to > > >> >> send > > >> >> > it > > >> >> > > to > > >> >> > > > you. > > >> >> > > > > > >> >> > > > <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope > > >> >> xmlns:soapenv=" > > >> >> > > > http://schemas.xmlsoap.org/soap/envelope/";> > > >> >> > > > <soapenv:Body> > > >> >> > > > <soapenv:Fault xmlns:soapenv=" > > >> >> http://incubator.apache.org/ode > > >> >> > "> > > >> >> > > > <faultcode>soapenv:Fault</faultcode> > > >> >> > > > <faultstring>Timeout or execution error when waiting > > for > > >> >> > response > > >> >> > > > to MEX {MyRoleMex#hqejbhcnphr4ko4i9c6o9i [Client > > >> >> > hqejbhcnphr4ko4i9c6o9h] > > >> >> > > > calling { > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL}actualizarIMIWSDLService.actualizarIMI(...)<http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29> > < > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > > > < > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > > > > >> < > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > >> > > > >> >> < > > >> >> > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > >> >> > > > >> >> > < > > >> >> > > > >> >> > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > >> >> > > > > >> >> > > < > > >> >> > > > > >> >> > > > >> >> > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > >> >> > > >} > > >> >> > > > java.util.concurrent.TimeoutException: Message exchange > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.bpel.engine.myrolemessageexchangeimpl$responsefut...@191e630timedout > > >> >> (120000 > > >> >> > ms) when waiting for a > > >> >> > > > > > >> >> > > > >> > response!</faultstring><detail><Exception>org.apache.ode.axis2.OdeFault: > > >> >> > > > Timeout or execution error when waiting for response to MEX > > >> >> > > > {MyRoleMex#hqejbhcnphr4ko4i9c6o9i [Client > > hqejbhcnphr4ko4i9c6o9h] > > >> >> > calling > > >> >> > > { > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL}actualizarIMIWSDLService.actualizarIMI(...)<http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29> > < > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > > > < > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > > > > >> < > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > >> > > > >> >> < > > >> >> > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > >> >> > > > >> >> > < > > >> >> > > > >> >> > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > >> >> > > > > >> >> > > < > > >> >> > > > > >> >> > > > >> >> > > >> > > > http://j2ee.netbeans.org/wsdl/ProcessosCadastrais/actualizarIMIWSDL%7DactualizarIMIWSDLService.actualizarIMI%28...%29 > > >> >> > > >} > > >> >> > > > java.util.concurrent.TimeoutException: Message exchange > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.bpel.engine.myrolemessageexchangeimpl$responsefut...@191e630timedout > > >> >> (120000 > > >> >> > ms) when waiting for a response!
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.ODEService.onAxisMessageExchange(ODEService.java:168)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:67)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:50)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96)
 > > >> >> > > > at > > >> >> > > > > >> org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120)
 > > >> >> > > > at > > >> >> > javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
 > > >> >> > > > at > > >> >> > javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 > > >> >> > > > at > > >> >> > > > > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 > > >> >> > > > at java.lang.Thread.run(Unknown Source)
 > > >> >> > > > > > >> >> > > </Exception></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope> > > >> >> > > > > > >> >> > > > On Mon, Sep 7, 2009 at 1:53 PM, Ricardo Pereira < > > >> >> > > [email protected] > > >> >> > > > > wrote: > > >> >> > > > > > >> >> > > >> Hi Milinda, > > >> >> > > >> > > >> >> > > >> the version is Apache ODE 1.3.2 > > >> >> > > >> > > >> >> > > >> > > >> >> > > >> On Mon, Sep 7, 2009 at 1:44 PM, Milinda Pathirage < > > >> >> > > >> [email protected]> wrote: > > >> >> > > >> > > >> >> > > >>> Hi Ricardo, > > >> >> > > >>> > > >> >> > > >>> Can you tell me the ODe version you used for the test. 1.3 > or > > >> >> trunk? > > >> >> > > >>> > > >> >> > > >>> Thanks, > > >> >> > > >>> Milinda > > >> >> > > >>> > > >> >> > > >>> On Mon, Sep 7, 2009 at 5:32 PM, Ricardo Pereira > > >> >> > > >>> <[email protected]>wrote: > > >> >> > > >>> > > >> >> > > >>> > No, i'm not using Derby DB, its just a process that > invokes > > a > > >> >> web > > >> >> > > >>> service. > > >> >> > > >>> > I > > >> >> > > >>> > tested the web service also with 10 requests with jmeter > > and > > >> the > > >> >> > > >>> responses > > >> >> > > >>> > were positive, no problem. When i send 10 requests to ODE > > it > > >> >> gives > > >> >> > > >>> these > > >> >> > > >>> > errors and the response of the process is below. > > >> >> > > >>> > > > >> >> > > >>> > Any idea? If you want more info, ask me. > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope > > >> >> > > xmlns:soapenv=" > > >> >> > > >>> > http://schemas.xmlsoap.org/soap/envelope/ > > >> >> > > >>> "><soapenv:Body><soapenv:Fault > > >> >> > > >>> > xmlns:java="java:package > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.bpel.iapi"><faultcode>java:org.apache.ode.bpel.iapi.ContextException</faultcode><faultstring>Database > > >> >> > > >>> > > > >> >> > > > error.</faultstring><detail><Exception>org.apache.ode.axis2.OdeFault: > > >> >> > > >>> > Database error.
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.ODEService.onAxisMessageExchange(ODEService.java:148)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:67)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:50)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96)
 > > >> >> > > >>> > at > > >> >> > > >>> > > >> >> > org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120)
 > > >> >> > > >>> > at > > >> >> > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
 > > >> >> > > >>> > at > > >> >> > > > javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
 > > >> >> > > >>> > at java.lang.Thread.run(Unknown Source)
 > > >> >> > > >>> > Caused by: org.apache.ode.bpel.iapi.ContextException: > > >> Database > > >> >> > > >>> error.
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:307)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:264)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:153)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.ODEService.onAxisMessageExchange(ODEService.java:128)
 > > >> >> > > >>> > ... 20 more
 > > >> >> > > >>> > Caused by: > > org.apache.ode.scheduler.simple.DatabaseException: > > >> >> > > >>> > java.sql.SQLException
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:155)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:288)
 > > >> >> > > >>> > ... 23 more
 > > >> >> > > >>> > Caused by: java.sql.SQLException
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:61)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.JdbcDelegate.getConnection(JdbcDelegate.java:248)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:138)
 > > >> >> > > >>> > ... 24 more
 > > >> >> > > >>> > Caused by: No ManagedConnections available within > > configured > > >> >> > blocking > > >> >> > > >>> > timeout ( 30000 [ms] ) for pool > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.singlepoolconnectionintercep...@1f06d35 > > >> >> > > >>> > 
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:88)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:87)
 > > >> >> > > >>> > at > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56)
 > > >> >> > > >>> > ... 26 more
 > > >> >> > > >>> > > > >> >> > > > > >> >> > > </Exception></detail></soapenv:Fault></soapenv:Body></soapenv:Envelope> > > >> >> > > >>> > > > >> >> > > >>> > On Mon, Sep 7, 2009 at 12:12 PM, Milinda Pathirage < > > >> >> > > >>> > [email protected]> wrote: > > >> >> > > >>> > > > >> >> > > >>> > > Hi Ricardo, > > >> >> > > >>> > > > > >> >> > > >>> > > Are you using embedded Derby DB for this test? > According > > to > > >> my > > >> >> > > >>> experience > > >> >> > > >>> > > embedded Derby database is not suitable for this type > of > > >> >> > scenarios. > > >> >> > > >>> It's > > >> >> > > >>> > > better to use external DB like MySQL for testing. Also > > it's > > >> >> > better > > >> >> > > to > > >> >> > > >>> use > > >> >> > > >>> > > data source support provide by your application server. > > >> >> > > >>> > > > > >> >> > > >>> > > Thanks > > >> >> > > >>> > > Milinda > > >> >> > > >>> > > > > >> >> > > >>> > > On Mon, Sep 7, 2009 at 3:11 PM, Ricardo Pereira > > >> >> > > >>> > > <[email protected]>wrote: > > >> >> > > >>> > > > > >> >> > > >>> > > > Hello, > > >> >> > > >>> > > > > > >> >> > > >>> > > > I'm using jmeter to send 10 request almost at the > same > > >> time > > >> >> to > > >> >> > > test > > >> >> > > >>> the > > >> >> > > >>> > > > scalability of a process deployed in ODE. > Unfortunately > > >> i'm > > >> >> > > getting > > >> >> > > >>> > these > > >> >> > > >>> > > > exceptions in the log. > > >> >> > > >>> > > > If i run the test in different times the process runs > > in > > >> >> about > > >> >> > 2 > > >> >> > > >>> secs. > > >> >> > > >>> > > > > > >> >> > > >>> > > > How can I make ODE accept 10 threads at the same > time? > > >> >> > > >>> > > > > > >> >> > > >>> > > > I hope for an answer as soon as you can please. > > >> >> > > >>> > > > > > >> >> > > >>> > > > Thank you very much for the support. > > >> >> > > >>> > > > Ricardo > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > ERROR - GeronimoLog.error(108) | Database error. > > >> >> > > >>> > > > org.apache.ode.scheduler.simple.DatabaseException: > > >> >> > > >>> > java.sql.SQLException > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:155) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:288) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.SimpleScheduler.schedulePersistedJob(SimpleScheduler.java:264) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.bpel.engine.MyRoleMessageExchangeImpl.invoke(MyRoleMessageExchangeImpl.java:153) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.ODEService.onAxisMessageExchange(ODEService.java:128) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:67) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.axis2.hooks.ODEMessageReceiver.invokeBusinessLogic(ODEMessageReceiver.java:50) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:96) > > >> >> > > >>> > > > at > > >> >> > > >>> > > org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:145) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:275) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > >> > org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:120) > > >> >> > > >>> > > > at > > >> >> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > > >> >> > > >>> > > > at > > >> >> > > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > >> >> > > > >> > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) > > >> >> > > >>> > > > at java.lang.Thread.run(Unknown Source) > > >> >> > > >>> > > > Caused by: java.sql.SQLException > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > >> >> > > > >> org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:61) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.JdbcDelegate.getConnection(JdbcDelegate.java:248) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.ode.scheduler.simple.JdbcDelegate.insertJob(JdbcDelegate.java:138) > > >> >> > > >>> > > > ... 24 more > > >> >> > > >>> > > > Caused by: No ManagedConnections available within > > >> configured > > >> >> > > >>> blocking > > >> >> > > >>> > > > timeout ( 30000 [ms] ) for pool > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.singlepoolconnectionintercep...@1f06d35 > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:88) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.getConnection(ConnectionHandleInterceptor.java:43) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > > > >> >> > > > >> >> > > >> > > > org.apache.geronimo.connector.outbound.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:87) > > >> >> > > >>> > > > at > > >> >> > > >>> > > > > > >> >> > > >>> > > >> >> > > > >> org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56) > > >> >> > > >>> > > > ... 26 more > > >> >> > > >>> > > > > > >> >> > > >>> > > > > >> >> > > >>> > > > > >> >> > > >>> > > > > >> >> > > >>> > > -- > > >> >> > > >>> > > Milinda Pathirage > > >> >> > > >>> > > Senior Software Engineer & Project Lead; WSO2 BPS; > > >> >> > > >>> http://wso2.org/bps > > >> >> > > >>> > > WSO2 <http://wso2.org/bps%0AWSO2> Inc.; > http://wso2.com > > >> >> > > >>> > > E-mail: [email protected], [email protected] > > >> >> > > >>> > > Blog: http://mpathirage.com > > >> >> > > >>> > > > > >> >> > > >>> > > > >> >> > > >>> > > >> >> > > >>> > > >> >> > > >>> > > >> >> > > >>> -- > > >> >> > > >>> Milinda Pathirage > > >> >> > > >>> Senior Software Engineer & Project Lead; WSO2 BPS; > > >> >> > > >>> http://wso2.org/bps > > >> >> > > >>> WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com > > >> >> > > >>> E-mail: [email protected], [email protected] > > >> >> > > >>> Blog: http://mpathirage.com > > >> >> > > >>> > > >> >> > > >> > > >> >> > > >> > > >> >> > > > > > >> >> > > > > >> >> > > > > >> >> > > -- > > >> >> > > Milinda Pathirage > > >> >> > > Senior Software Engineer & Project Lead; WSO2 BPS; > > >> >> http://wso2.org/bps > > >> >> > > WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com > > >> >> > > E-mail: [email protected], [email protected] > > >> >> > > Blog: http://mpathirage.com > > >> >> > > > > >> >> > > > >> >> > > >> >> > > >> >> > > >> >> -- > > >> >> Milinda Pathirage > > >> >> Senior Software Engineer & Product Manager WSO2 BPS; > > >> http://wso2.org/bps > > >> >> WSO2 Inc.; http://wso2.com > > >> >> E-mail: [email protected], [email protected] > > >> >> Web: http://mpathirage.com > > >> >> Blog: http://blog.mpathirage.com > > >> >> > > >> > > > >> > > > >> > > > > > > > > > > > > -- > > > Milinda Pathirage > > > Senior Software Engineer & Product Manager WSO2 BPS; > http://wso2.org/bps > > > WSO2 Inc.; http://wso2.com > > > E-mail: [email protected], [email protected] > > > Web: http://mpathirage.com > > > Blog: http://blog.mpathirage.com > > > > > > > > > > > -- > > Milinda Pathirage > > Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps > > WSO2 <http://wso2.org/bps%0AWSO2> Inc.; http://wso2.com > > E-mail: [email protected], [email protected] > > Web: http://mpathirage.com > > Blog: http://blog.mpathirage.com > > > -- Milinda Pathirage Senior Software Engineer & Product Manager WSO2 BPS; http://wso2.org/bps WSO2 Inc.; http://wso2.com E-mail: [email protected], [email protected] Web: http://mpathirage.com Blog: http://blog.mpathirage.com
