Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4FECCCF0.5050106@poonam.org>
Date: Fri, 29 Jun 2012 03:00:24 +0530
From: Kiran Badi <kiran@poonam.org>
Organization: www.poonam.org
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:13.0) Gecko/20120614 Thunderbird/13.0.1
MIME-Version: 1.0
To: users@tomcat.apache.org
Subject: Re: Tomcat DBCP Connection pool issue
References: <4FE94468.6060601@poonam.org>
 <4FEA143F.7020105@christopherschultz.net> <4FEA44C1.8060806@poonam.org>
 <4FEB2120.9010609@christopherschultz.net>
In-Reply-To: <4FEB2120.9010609@christopherschultz.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 6/27/2012 8:35 PM, Christopher Schultz wrote:
> 100 active db connections sounds like a lot. Do you really need to
> support 100 simultaneous connections to your database? Can your
> database support that many connections with active queries from each?
> Do you have a cluster? Remember that each member in the cluster will
> therefore open a maximum of 100 connections to your database. 10
> cluster members means 1000 simultaneous connections.
to begin with I am targetting 1000 users at any time.I know this is too 
much to dream off.But again let me try for that.

I will enable abondered detection settings.Thanks for bringing to notice.

There's no time like the present: this problem will only get worse
over time.

I had written a bunch of DAO  classes sometimes back,but there was bug in DB design(for one functionality,I forgot to relate tables properly) and after fixing that I somehow forgot to to use model 2 design(again my bad its hard to wire the brain to work this way when you can just make easy calls and then present data to the client and yet do MVC) and started working  old way and due to this db calls went into the servlet.For other module I am fixing this and will make action servlet which will read request uri and then do the appropriate action.I have almost visualised,inserts and deletes.Trying to find the way to see how to make edit work.I have around 10 images and around 10 fields which I need to perists somewhere before final insert.

God bless me.


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