3.0.2 is pretty old and I wouldn't promise anything about it:-) With recent versions at least it seems that this problem is really, despite users initial complaints, always caused by not closing connections. You could try running 3.0.7 (cvs) or porting to 3.2RC2 or cvs as an experiment since these versions will complain fairly loudly when they detect that you didn't close a connection.
These versions also have much better error handling when connections break, such as when the db server shuts down. You can also arrange to execute a test sql string to check the connection right before it is handed out from the pool. david jencks On 2003.02.26 11:30 "Finn, Michael" wrote: > This just happened here last night, in production as luck would have it. > > JBoss 3.0.2 > Oracle 8i server (9.x driver) > > I am getting the same exception: > Caught SQLException while getting user profile: > org.jboss.util.NestedSQLException: No ManagedConnections Available!; - > nested throwable: (javax.resource.ResourceException: No > ManagedConnections > Available!) > > I am (painfully) aware of all the leaks in Oracle's driver, and am very > diligent about closing connections, resultsets, statements, etc. > > How would a loss of connections (ie DB server reboot) manifest itself? > Same > error? > > Strangely, netstat shows no connections to the DB box. Ideas? > > Mike > > > > -----Original Message----- > From: Alex Loubyansky [mailto:[EMAIL PROTECTED] > Sent: Friday, February 21, 2003 2:12 AM > To: nfs_ nfs > Subject: Re: [JBoss-user] ManagedConnections Available! > > > 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 > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> > <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2655.35"> > <TITLE>RE: [JBoss-user] ManagedConnections Available!</TITLE> > </HEAD> > <BODY> > > <P><FONT SIZE=2>This just happened here last night, in production as luck > would have it. </FONT> > </P> > > <P><FONT SIZE=2>JBoss 3.0.2</FONT> > <BR><FONT SIZE=2>Oracle 8i server (9.x driver)</FONT> > </P> > > <P><FONT SIZE=2>I am getting the same exception:</FONT> > <BR><FONT SIZE=2>Caught SQLException while getting user profile: > org.jboss.util.NestedSQLException: No ManagedConnections Available!; - > nested throwable: (javax.resource.ResourceException: No > ManagedConnections Available!)</FONT></P> > > <P><FONT SIZE=2>I am (painfully) aware of all the leaks in Oracle's > driver, and am very diligent about closing connections, resultsets, > statements, etc.</FONT></P> > > <P><FONT SIZE=2>How would a loss of connections (ie DB server reboot) > manifest itself? Same error? </FONT> > </P> > > <P><FONT SIZE=2>Strangely, netstat shows no connections to the DB box. > Ideas?</FONT> > </P> > > <P><FONT SIZE=2>Mike</FONT> > </P> > <BR> > <BR> > > <P><FONT SIZE=2>-----Original Message-----</FONT> > <BR><FONT SIZE=2>From: Alex Loubyansky [<A > HREF="mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT> > <BR><FONT SIZE=2>Sent: Friday, February 21, 2003 2:12 AM</FONT> > <BR><FONT SIZE=2>To: nfs_ nfs</FONT> > <BR><FONT SIZE=2>Subject: Re: [JBoss-user] ManagedConnections > Available!</FONT> > </P> > <BR> > > <P><FONT SIZE=2>This means there are no more available connections in the > pool.</FONT> > <BR><FONT SIZE=2>Make sure you properly handle them, i.e. closing them > correctly. Also</FONT> > <BR><FONT SIZE=2>more info about what you are doing would give more > response.</FONT> > </P> > > <P><FONT SIZE=2>alex</FONT> > </P> > > <P><FONT SIZE=2>Friday, February 21, 2003, 7:17:40 AM, nfs_ nfs > wrote:</FONT> > <BR><FONT SIZE=2>nn> Hi all,</FONT> > <BR><FONT SIZE=2>nn> Anyone knows why this error "HTTP ERROR: 500 > SQL Exception while getting DB </FONT> > <BR><FONT SIZE=2>nn> connection : org.jboss.util.NestedSQLException: > No ManagedConnections </FONT> > <BR><FONT SIZE=2>nn> Available!; - nested throwable: > (javax.resource.ResourceException: No </FONT> > <BR><FONT SIZE=2>nn> ManagedConnections Available!)"</FONT> > </P> > > <P><FONT SIZE=2>nn> showing up ?,if this error is for database > connection than do i have to </FONT> > <BR><FONT SIZE=2>nn> specify the limit of database connection in JBoss > ?.</FONT> > </P> > <BR> > > <P><FONT SIZE=2>nn> Thanks in advance.</FONT> > </P> > <BR> > <BR> > <BR> > > <P><FONT SIZE=2>-------------------------------------------------------</FONT> > <BR><FONT SIZE=2>This SF.net email is sponsored by: SlickEdit Inc. > Develop an edge.</FONT> > <BR><FONT SIZE=2>The most comprehensive and flexible code editor you can > use.</FONT> > <BR><FONT SIZE=2>Code faster. C/C++, C#, Java, HTML, XML, many more. FREE > 30-Day Trial.</FONT> > <BR><FONT SIZE=2>www.slickedit.com/sourceforge</FONT> > <BR><FONT SIZE=2>_______________________________________________</FONT> > <BR><FONT SIZE=2>JBoss-user mailing list</FONT> > <BR><FONT SIZE=2>[EMAIL PROTECTED]</FONT> > <BR><FONT SIZE=2><A HREF="https://lists.sourceforge.net/lists/listinfo/jboss-user"; > TARGET="_blank">https://lists.sourceforge.net/lists/listinfo/jboss-user</A></FONT> > </P> > > </BODY> > </HTML> ------------------------------------------------------- This SF.net email is sponsored by: Scholarships for Techies! Can't afford IT training? All 2003 ictp students receive scholarships. Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more. www.ictp.com/training/sourceforge.asp _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
