Not totally clear on how many threads are actually running concurrently, but the data source has a default of MAX 20 connections, so it is quite likely that you would get this error since you will have used up all the connections.
//Nicholas --- Magesh Prabhu <[EMAIL PROTECTED]> wrote: > Hi Guys, > > In order to test the concurrency in my system, I > created a Threaded standalone application and tried > to invoke a Stateless Session Bean concurrently 100 > times. > > What the Session Bean does is fairly simple, It > calls an entiry bean which in turn searches for the > primary key in the database. If there is'nt one, it > creates a new record. > > When I executed my threaded applicatoin, I got the > following Exception stack trace. > Can somebody explain be about this 'No > ManagedConnections Available!'. Am I missing > something in the way I have configured my > datasource. > > My datasource configuration is : > <datasources> > <local-tx-datasource> > <jndi-name>OracleDS</jndi-name> > > <connection-url>jdbc:oracle:thin:@193.16.18.142:1521:testdb</connection-url> > > <driver-class>oracle.jdbc.driver.OracleDriver</driver-class> > <user-name>dev</user-name> > <password>dev</password> > > <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> > </local-tx-datasource> > > </datasources> > > Environment: jboss-3.2.1_tomcat-4.1.24, Oracle > 8.1.6, Jdk 1.4.1_01 > > Thanx in advance, > Magesh > > EXCEPTION STACK: > > org.jboss.util.NestedSQLException: No > ManagedConnections Available!; - nested throwable: > (javax.resource.ResourceException: No > ManagedConnections Available!) > at > org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106) > at > com.pindartech.imageprocessing.manager.requestpersistencemanager.RequestBean.getConnection(RequestBean.java:690) > at > com.pindartech.imageprocessing.manager.requestpersistencemanager.RequestBean.ejbFindByPrimaryKey(RequestBean.java:460) > at > sun.reflect.GeneratedMethodAccessor521.invoke(Unknown > Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:578) > at > org.jboss.ejb.plugins.BMPPersistenceManager.findEntity(BMPPersistenceManager.java:316) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:301) > at > org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:627) > at > sun.reflect.GeneratedMethodAccessor520.invoke(Unknown > Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:998) > at > org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:188) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215) > at > org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:88) > at > org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:91) > at > org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:61) > at > org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:28) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:88) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:74) > at > org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:92) > at > org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:120) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:93) > at > org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:477) > at > org.jboss.ejb.Container.invoke(Container.java:694) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:272) > at > org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110) > at $Proxy263.findByPrimaryKey(Unknown Source) > at > com.pindartech.imageprocessing.manager.requestpersistencemanager.RequestDBManager.findRequestByRequestID(RequestDBManager.java:53) > at > com.pindartech.imageprocessing.manager.requestpersistencemanager.RequestPersistenceManagerBean.findRequestByRequestID(RequestPersistenceManagerBean.java:98) > at > sun.reflect.GeneratedMethodAccessor544.invoke(Unknown > Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:629) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186) > at > org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) > at > org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322) > at > org.jboss.ejb.Container.invoke(Container.java:674) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:353) > at > org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83) > at $Proxy295.findRequestByRequestID(Unknown Source) > at > com.pindartech.imageprocessing.manager.requestcontroller.RequestControllerBean.findRequestByRequestID(RequestControllerBean.java:387) > at > com.pindartech.imageprocessing.manager.requestcontroller.RequestControllerBean.processRequest(RequestControllerBean.java:67) > at > sun.reflect.GeneratedMethodAccessor542.invoke(Unknown > Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:629) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186) > at > org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:243) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104) > at > org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:117) > at > org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) > at > org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) > at > org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:322) > at > org.jboss.ejb.Container.invoke(Container.java:674) > at > org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:353) > at > org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:83) > at $Proxy294.processRequest(Unknown Source) > at > com.pindartech.imageprocessing.manager.requestreceiver.RequestReceiverBean.received(RequestReceiverBean.java:110) > at > sun.reflect.GeneratedMethodAccessor526.invoke(Unknown > Source) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:324) > at > org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:629) > at > org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186) > at > org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72) > at > org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84) > at > org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:296) > at > org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:104) > === message truncated === ===== Nicholas Whitehead Home: (973) 377 9335 Cell: (201) 615 2716 [EMAIL PROTECTED] Get Your News From The Crowbar: http://crowbar.dnsalias.com:443/crowbar/ ------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here: http://www.vmware.com/wl/offer/345/0 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user