ode-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Milinda Pathirage <milinda.pathir...@gmail.com>
Subject Re: Does ode accept 10 threads at the same time? org.apache.ode.scheduler.simple.DatabaseException
Date Mon, 07 Sep 2009 11:12:13 GMT
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
<ricardo.selecta@gmail.com>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.SinglePoolConnectionInterceptor@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 Inc.; http://wso2.com
E-mail: milinda@wso2.com, milinda.pathirage@gmail.com
Blog: http://mpathirage.com

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message