go back for a sec.. last thing we talked about is adding the strings of validation query, validation interval and test on borrow, so the pool will know if the connections had been closed by DB or not, and respond accordingly. this one I understood :] so.. RDBMS? how is it connected to my case? (bare with me.. I was introduced to tomcat only a couple months ago).
Thanks Hila 2011/4/8 Martin Gainty <mgai...@hotmail.com> > > Relational Database Management System > > If you desire to implement a tag library which maps data entities into jsp > tag elements I would suggest Phillipe Poulards 'Active Tag' > http://ns.inria.fr/active-tags/rdbms/rdbms.html#N4000C7 > > Bon Chance! > Martin > ______________________________________________ > Note de déni et de confidentialité > Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le > destinataire prévu, nous te demandons avec bonté que pour satisfaire > informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie > de ceci est interdite. Ce message sert à l'information seulement et n'aura > pas n'importe quel effet légalement obligatoire. Étant donné que les email > peuvent facilement être sujets à la manipulation, nous ne pouvons accepter > aucune responsabilité pour le contenu fourni. > > > > > > From: hilavalen...@gmail.com > > Date: Fri, 8 Apr 2011 13:14:43 +0300 > > Subject: Re: JDBC Pool Disconnections > > To: users@tomcat.apache.org > > > > What is RDBMS? I tried to google it, but haven't quite figure it out. > > as mentioned, we're using SQL server 2008, latest SP. > > > > And I will add the strings of validationQuery and validationInterval. :] > > > > Thanks > > Hila > > > > > > 2011/4/7 Christopher Schultz <ch...@christopherschultz.net> > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > > Hash: SHA1 > > > > > > הילה, > > > > > > On 4/6/2011 3:36 PM, הילה wrote: > > > > I wanted to add it, bu the company that developed the application > > > > that runs on the tomcat, says that it affect performance and has > > > > issues. > > > > > > What is your RDBMS? If it happens to be MySQL, I know that they support > > > a "ping" query that is very fast. It's much better and faster than > > > spewing SQLExceptions into your log file. > > > > > > I would always recommend running with a validationQuery enabled, even > if > > > you have to set a validation interval to reduce the number of > > > validations that actually occur. > > > > > > - -chris > > > -----BEGIN PGP SIGNATURE----- > > > Version: GnuPG v1.4.10 (MingW32) > > > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > > > > > iEYEARECAAYFAk2c3tkACgkQ9CaO5/Lv0PBGyACgu1jH9svX+SbIU4ZrvUG63VRD > > > FnUAoLMOBchXqMmyQRJUHD/G3Dc4ijDP > > > =vpTh > > > -----END PGP SIGNATURE----- > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > > > For additional commands, e-mail: users-h...@tomcat.apache.org > > > > > > > >
