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 Inc.; http://wso2.com E-mail: [email protected], [email protected] Blog: http://mpathirage.com
