In that case I believe the message is correct and appropriate. If the db server really hangs, fix your sql. If it just takes a really long time you might consider making a separate pool for these long computations with a timeout several times longer than the length of the computation.
david jencks On 2003.02.21 05:01 Kristian Köhler wrote: > Hi Bernie > > > can you tell me the name of the driver JAR and driver class. We're > using > > JBoss 3.0.5 with Oracle 8i and have these kinds of problems frequently. > > It was an Inetsoftware Oracle Driver. > The problem occurred in the following szenario: > > A "complex" SQL Statement gets executed on the DB Server. > The Server runs up to 100% workload and stays there "forever". > The Server continued running but did not release its connections. > > Kristian > > -- > Orientation in Objects GmbH > http://www.oio.de > > > -----Ursprüngliche Nachricht----- > > Von: Kristian Köhler [mailto:[EMAIL PROTECTED]] > > Gesendet: Freitag, 21. Februar 2003 09:47 > > An: [EMAIL PROTECTED] > > Betreff: AW: [JBoss-user] ManagedConnections Available! > > > > > > Which DB Driver do you use? > > We had similar problems with an Oracle Driver. > > Are you sure your Driver works correct? > > > > Kristian > > > > -- > > Orientation in Objects GmbH > > http://www.oio.de > > > > > -----Ursprüngliche Nachricht----- > > > Von: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED]]Im Auftrag von nfs_ > nfs > > > Gesendet: Freitag, 21. Februar 2003 09:22 > > > An: [EMAIL PROTECTED] > > > Betreff: Re: [JBoss-user] ManagedConnections Available! > > > > > > > > > Hi Alex Loubyansky, > > > > > > Thanks for your response i am starting my website and having > > problem with > > > this managed connection,and also closing all the connections > > > result set and > > > statements,but still getting this error sometimes.I need urgent help. > > > > > > My website URL :http://www.thesoftwareobjects.com > > > email :[EMAIL PROTECTED],[EMAIL PROTECTED] > > > > > > Thanks again. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >From: Alex Loubyansky <[EMAIL PROTECTED]> > > > >Reply-To: [EMAIL PROTECTED] > > > >To: nfs_ nfs <[EMAIL PROTECTED]> > > > >Subject: Re: [JBoss-user] ManagedConnections Available! > > > >Date: Fri, 21 Feb 2003 09:12:17 +0200 > > > > > > > >This means there are no more available connections in the pool. > > > >Make sure you properly handle them, i.e. closing them correctly. > Also > > > >more info about what you are doing would give more response. > > > > > > > >alex > > > > > > > >Friday, February 21, 2003, 7:17:40 AM, nfs_ nfs wrote: > > > >nn> Hi all, > > > >nn> Anyone knows why this error "HTTP ERROR: 500 SQL Exception while > > > >getting DB > > > >nn> connection : org.jboss.util.NestedSQLException: No > > ManagedConnections > > > >nn> Available!; - nested throwable: > > (javax.resource.ResourceException: No > > > >nn> ManagedConnections Available!)" > > > > > > > >nn> showing up ?,if this error is for database connection than > > > do i have to > > > >nn> specify the limit of database connection in JBoss ?. > > > > > > > > > > > >nn> Thanks in advance. > > > > > > > > > > > > > > > > > > > >------------------------------------------------------- > > > >This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > > > >The most comprehensive and flexible code editor you can use. > > > >Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day > Trial. > > > >www.slickedit.com/sourceforge > > > >_______________________________________________ > > > >JBoss-user mailing list > > > >[EMAIL PROTECTED] > > > >https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > _________________________________________________________________ > > > The new MSN 8: smart spam protection and 2 months FREE* > > > http://join.msn.com/?page=features/junkmail > > > > > > > > > > > > ------------------------------------------------------- > > > This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > > > The most comprehensive and flexible code editor you can use. > > > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day > Trial. > > > www.slickedit.com/sourceforge > > > _______________________________________________ > > > JBoss-user mailing list > > > [EMAIL PROTECTED] > > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > > The most comprehensive and flexible code editor you can use. > > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. > > www.slickedit.com/sourceforge > > _______________________________________________ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > This e-mail and any attachment is for authorised use by the > > intended recipient(s) only. It may contain proprietary material, > > confidential information and/or be subject to legal privilege. > > It should not be copied, disclosed to, retained or used by, any > > other party. If you are not an intended recipient then please > > promptly delete this e-mail and any attachment and all copies and > > inform the sender. Thank you. > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > > The most comprehensive and flexible code editor you can use. > > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. > > www.slickedit.com/sourceforge > > _______________________________________________ > > JBoss-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. > The most comprehensive and flexible code editor you can use. > Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. > www.slickedit.com/sourceforge > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > ------------------------------------------------------- This SF.net email is sponsored by: SlickEdit Inc. Develop an edge. The most comprehensive and flexible code editor you can use. Code faster. C/C++, C#, Java, HTML, XML, many more. FREE 30-Day Trial. www.slickedit.com/sourceforge _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
