tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parsons Technical Services" <parsonstechni...@earthlink.net>
Subject Re: Does JDBCRealm close connections?
Date Tue, 25 Jan 2005 05:44:03 GMT
In a quick scan of the source (4.1.30). The realm does not use pools. It 
opens the connection upon authentication. Then closes it right after. All in 
the same method.

There is a note about adding pooling, and this may be one reason why.

If you have a limit on the number of connection your dbengine can support 
then this may be the cause.

So for the last question, yes, it would keep opening the needed connections 
for logins. But it closes them promptly after retrieval of the data.

Doug


----- Original Message ----- 
From: "Stephen Charles Huey" <stephenhuey@fastmail.fm>
To: "Tomcat User" <tomcat-user@jakarta.apache.org>
Sent: Monday, January 24, 2005 9:55 PM
Subject: Does JDBCRealm close connections?


> Hey there--just wondering if JDBCRealm with Tomcat 4 ever closes
> connections it opens...I'm assuming it can open up more than one
> connection to the database if traffic gets heavy (because we think we're
> seeing that, though it's hard to tell for sure).  If so, when does it go
> about closing those connections?  I was reading about it here:
> http://jakarta.apache.org/tomcat/tomcat-4.0-doc/realm-howto.html#JDBCRealm
>
> We're trying to debug a nasty problem, and we're wondering if a couple
> hundred folks try to log in at the same time and there are only about
> that many database connections that can be pooled (and a bunch of the db
> connections are already in use by the web app), then does JDBCRealm just
> keep opening up more and more connections to the database?
>
> Thanks,
> Stephen
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> 



---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message