RE: [JBoss-user] ManagedConnections Available!

Finn, Michael Thu, 27 Feb 2003 06:21:03 -0800

Title: RE: [JBoss-user] ManagedConnections Available!

Yeah- I have done it (3.0.2 to 3.2RC2 and also to HEAD/4.0) in a dev environment (pretty simple). That's the easy part. Then comes formalized regression and load testing, and the act-of-congress tasks of making changes to production (we have 4 apps running on our JBoss prod instance - will be 9 by year's end).

Mike

-----Original Message-----
From: Corbin, James [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 2:42 PM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] ManagedConnections Available!

Michael,

I migrated a 2.4.4 installation to 3.2.0RC2 in half a day. It is really worth the time to upgrade.

J.D.

-----Original Message-----
From: Finn, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 12:04 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [JBoss-user] ManagedConnections Available!

David,

Yeah - we are going to go to 3.2 ASAP. We need it for jboss.net stuff, but it's a question of people resources for us at this point. Maybe we should go to 3.0.6/7 in the interim.

BTW - is there an MBean method I can invoke to give me connection counts in a given pool? It's probably staring me in the face, but I don't see it.

Mike

-----Original Message-----
From: David Jencks [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 26, 2003 12:03 PM
To: [EMAIL PROTECTED]
Subject: RE: [JBoss-user] ManagedConnections Available!

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>
>
> 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 [<A
> HREF=""mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]
> 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]
> <A HREF=""https://lists.sourceforge.net/lists/listinfo/jboss-user">https://lists.sourceforge.net/lists/listinfo/jboss-user"
> TARGET="_blank">https://lists.sourceforge.net/lists/listinfo/jboss-user</A>
> 
>
> </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
This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged.
The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be
aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received
this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.

RE: [JBoss-user] ManagedConnections Available!

Reply via email to