Chris, Thanks for your regular guidance and valuable suggestions!
On Fri, Apr 11, 2014 at 11:33 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA256 > > Daniel, > > On 4/8/14, 6:36 AM, Daniel Mikusa wrote: > > On Apr 8, 2014, at 8:22 AM, Saurabh Saraswat > > <ssaras...@pivotalindia.com> wrote: > > > >> Dear Dan, > >> > >> Thanks for taking time to respond me. > >> > >> My updated Resource Tag is - > >> > >> <Resource name="jdbc/MaxDB" auth="Container" > >> type="javax.sql.DataSource" maxActive="100" maxIdle="30" > > > > As Chris mentioned, set maxActive 1 in your dev environment. That > > will help you find the problem more quickly. > > > >> maxWait="10000" username="usrname" password="password" > >> driverClassName="com.mysql.jdbc.Driver" > >> > >> > url="jdbc:MySQL://localhost:3306/MaxDB?zeroDateTimeBehavior=convertToNull" > >> > >> > validationQuery="Select 1" removeAbandoned="true" > >> removeAbandonedTimeout="1000" > > > > This is in seconds, so 1000 is 16.667 minutes, and is probably way > > to high. > > > Whoops! You're right. I'm used to everything being in ms. I apologize > for my post just now: it's seconds and you are correct. 4 days of > conference+drinking will do this to you ;) > I can understand :) I have done all changes suggested by you guys and the good news is that the problem has been solved. Now my application is running fine. > > > For the purposes of debugging, try something much lower like 10 > > seconds. That way you'll get feedback quick feedback. > > +1 > > >> I have also cross checked my code. I am closing the connection > >> properly in finally block. > > > > If you have not done so already, run something like FindBugs on > > your code. > > Absolutely. FindBugs is a great tool, even though there are sometimes > a lot of false-positives. Run it on your code (it's easy!) and start > with the highest-priority bugs that it finds. They are pretty much all > worth investigating. > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1 > Comment: GPGTools - http://gpgtools.org > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > > iQIcBAEBCAAGBQJTR4WaAAoJEBzwKT+lPKRYNskP/RQJlQONYDDNa3qokJUoicNr > 3zqPd9w6SSvEvZnNfwR6G5a8EI/bDr4xQoEqOQfNBv6QSHrWaEBWmSkQwT/qcVh5 > QMOCZ+QMtCCQVD9KtYEwwHJH2FSpv9jEiBVyiPV8Ik4hMOYhIMgcJd+C1qh4Hj7s > fAfUsJ0aSZxQqexwHADhtn5UZP6/y+2DZGRZ1YVcCXmV7aPV4ghB1Nj7rY0EOxXq > N6q1dt9SsxNXnzqx3xNyJw20qulTa+//B4DNSjpek87cCf+PGMr/M9qV3pqrDBv6 > uBIUDWhZXaVa1ilGvyWilr9HnxTUh6JGGQEEgFNfafjO6DDJLteLFsp334QKDX+K > QBp03mU7gOO7QwcEtQ49XBmzEgy1//f44m4q9uU3LyZYleT8YRs479us2gHXUbYB > iVFOz1kqdFZOL4234zTE7MHkDTSd1o5lwfrzjghT+2On3/nEDYlrsmmcPkBSaVw9 > XFYucvC8gXx0CLFlyaPoobwUbVF0qmjEH1Np31tiLCjXDdfsI/2Im1TZDPNCfFnv > mj7+FA/h6PXV/kSrSdICjW2H38YeWI7CovUwNm3KnfTiLPC9clpJUUxXCrQWqo/+ > z6gv7V0dMRso9lXBFKKh6tGosGC3Q4NPJeqyfDbLUd4lS4HvrwFn9GvJF7Y1xD/+ > cKIkLEYn3Njl7Xz9I4Cj > =W5a2 > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > > regards, Saurabh