Re: JDBC Pool Disconnections
Hey, I'm using JTDS 1.2.5 It has proven to be more stable than the JDBC driver of microsoft, so we're using it. Thanks Hila 2011/4/7 Pid p...@pidster.com On 4/6/11 8: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. Which DB driver are you using? In my experience some of the jTDS driver variations have issues. p what do you mean validates it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Lists devli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1 initialSize=20 driverClassName=net.sourceforge.jtds.jdbc.Driver Add in testOnBorrow=true validationQuery=select 1 this ensures that if the DB closes a connection, the pool validates it best Filip - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
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
Re: JDBC Pool Disconnections
הילה wrote: What is RDBMS? An easy one, just my level : Relational DataBase Management System. As a further exercise, here is a list of essential acronyms which one is supposed to know in order to be recognised as a Real Tomcat Programmer (RTP) : JVM, J2EE, BIO, NIO, APR, JDBC, JMX, JNDI, CO2, HTTP, JSP, HTTPS, SSL, LOG4J, SSH, GC, UTF-8, JINI, SPNEGO, WWW, HTML, XML, AJP, OOM, CNFE, YMMV, AFAIK, REST, SOAP, HTMLX, SMTP, W3C, ASF, CGI, NoSQL, API, WAR, JAR, AAA. Trick question : one of the above is an intrus, is not mentioned anywhere in the Tomcat online documentation, and has arguably nothing to do at all with Tomcat or this support list. Which one ? - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
RE: JDBC Pool Disconnections
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
Re: JDBC Pool Disconnections
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 André, On 4/8/2011 7:33 AM, André Warnier wrote: הילה wrote: What is RDBMS? An easy one, just my level : Relational DataBase Management System. As a further exercise, here is a list of essential acronyms which one is supposed to know in order to be recognised as a Real Tomcat Programmer (RTP) : JVM, J2EE, BIO, NIO, APR, JDBC, JMX, JNDI, CO2, HTTP, JSP, HTTPS, SSL, LOG4J, SSH, GC, UTF-8, JINI, SPNEGO, WWW, HTML, XML, AJP, OOM, CNFE, YMMV, AFAIK, REST, SOAP, HTMLX, SMTP, W3C, ASF, CGI, NoSQL, API, WAR, JAR, AAA. You forgot WTF, and my favorite variation, OMGWTFBBQ. Trick question : one of the above is an intrus, is not mentioned anywhere in the Tomcat online documentation, and has arguably nothing to do at all with Tomcat or this support list. Which one ? RTP ;) - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk2fH1kACgkQ9CaO5/Lv0PC/gQCgwuRqes7LO0pg13OG3SAvrP7m ADQAnRTkb3afuw2WFk5TiiuBjGv1neml =2ROU -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
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
RE: JDBC Pool Disconnections
From: הילה [mailto:hilavalen...@gmail.com] Subject: Re: JDBC Pool Disconnections 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). A) Ignore anything Martin G posts - so much of it is irrelevant that it's a waste of time to wade through it. B) RDBMS = DB. The one you're using may have an extremely fast mechanism that can be used to determine the viability of the connection with minimal overhead. MySQL is the example cited by Chris S. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.
Re: JDBC Pool Disconnections
Thanks so.. SQL server 2008 is the one I'm using. :] 2011/4/8 Caldarale, Charles R chuck.caldar...@unisys.com From: הילה [mailto:hilavalen...@gmail.com] Subject: Re: JDBC Pool Disconnections 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). A) Ignore anything Martin G posts - so much of it is irrelevant that it's a waste of time to wade through it. B) RDBMS = DB. The one you're using may have an extremely fast mechanism that can be used to determine the viability of the connection with minimal overhead. MySQL is the example cited by Chris S. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers.
Re: JDBC Pool Disconnections
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 הילה, On 4/8/2011 11:04 AM, הילה wrote: so.. SQL server 2008 is the one I'm using. :] Some quick Googling didn't lead me to any resources on a fast ping that you could use as a validation query. You could always read the documentation for your JDBC driver. That's how I found out about MySQL's ping feature. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk2fK1oACgkQ9CaO5/Lv0PB9iQCdFX/KYzRCjGlWbxRvPXC5Ko3y gpsAoJEGkGgg0nedFZiAAD2RET1N8nyy =nhC8 -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
I think that if the disconnections will continue, I'll read just about anything to make it stop :] Thanks ;) 2011/4/8 Christopher Schultz ch...@christopherschultz.net -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 הילה, On 4/8/2011 11:04 AM, הילה wrote: so.. SQL server 2008 is the one I'm using. :] Some quick Googling didn't lead me to any resources on a fast ping that you could use as a validation query. You could always read the documentation for your JDBC driver. That's how I found out about MySQL's ping feature. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk2fK1oACgkQ9CaO5/Lv0PB9iQCdFX/KYzRCjGlWbxRvPXC5Ko3y gpsAoJEGkGgg0nedFZiAAD2RET1N8nyy =nhC8 -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
On 4/6/11 8: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. Which DB driver are you using? In my experience some of the jTDS driver variations have issues. p what do you mean validates it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Lists devli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1 initialSize=20 driverClassName=net.sourceforge.jtds.jdbc.Driver Add in testOnBorrow=true validationQuery=select 1 this ensures that if the DB closes a connection, the pool validates it best Filip - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org signature.asc Description: OpenPGP digital signature
Re: JDBC Pool Disconnections
On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1 initialSize=20 driverClassName=net.sourceforge.jtds.jdbc.Driver Add in testOnBorrow=true validationQuery=select 1 this ensures that if the DB closes a connection, the pool validates it best Filip - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
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 do you mean validates it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Lists devli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1 initialSize=20 driverClassName=net.sourceforge.jtds.jdbc.Driver Add in testOnBorrow=true validationQuery=select 1 this ensures that if the DB closes a connection, the pool validates it best Filip - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
validate == connection is open and working if they are worried about performance, there is a compromise that gets you best of both worlds testOnBorrow=true validationQuery=select 1 validationInterval=3 this ensures that in a high concurrency environment, the number of validations are limited Filip On 4/6/2011 1: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 do you mean validates it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Listsdevli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1 initialSize=20 driverClassName=net.sourceforge.jtds.jdbc.Driver Add in testOnBorrow=true validationQuery=select 1 this ensures that if the DB closes a connection, the pool validates it best Filip - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3555 - Release Date: 04/06/11 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
I wanted to add the last string as well, but they said to forget about it.. :] and they should know best however, if disconnections will continue (there are some right now) I'll try it anyway as for the connection validation = you said that if the DB closes a connection (why does it happen? can I prevent it?) than the pool is checking if the connection is open and working. and if not? i the DB closed the connection and it's not usable.. then what does the pool do? 2011/4/6 Filip Hanik - Dev Lists devli...@hanik.com validate == connection is open and working if they are worried about performance, there is a compromise that gets you best of both worlds testOnBorrow=true validationQuery=select 1 validationInterval=3 this ensures that in a high concurrency environment, the number of validations are limited Filip On 4/6/2011 1: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 do you mean validates it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Listsdevli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1 initialSize=20 driverClassName=net.sourceforge.jtds.jdbc.Driver Add in testOnBorrow=true validationQuery=select 1 this ensures that if the DB closes a connection, the pool validates it best Filip - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3555 - Release Date: 04/06/11 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
On 4/6/2011 1:54 PM, הילה wrote: I wanted to add the last string as well, but they said to forget about it.. :] and they should know best however, if disconnections will continue (there are some right now) I'll try it anyway as for the connection validation = you said that if the DB closes a connection (why does it happen? can I prevent it?) most common is that the DB times out an idle connection. A pool holds a connection open, the connection is not being used and the DB times it out. there are many examples, same thing if there is a network glitch, or the db is restarted. than the pool is checking if the connection is open and working. and if not? i the DB closed the connection and it's not usable.. then what does the pool do? if the pool doesn't check, then it doesn't do anything. if the pool check (testOnBorrow=true) and the test fails, it closes the old connection and opens a new one. Filip 2011/4/6 Filip Hanik - Dev Listsdevli...@hanik.com validate == connection is open and working if they are worried about performance, there is a compromise that gets you best of both worlds testOnBorrow=true validationQuery=select 1 validationInterval=3 this ensures that in a high concurrency environment, the number of validations are limited Filip On 4/6/2011 1: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 do you mean validates it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Listsdevli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1 initialSize=20 driverClassName=net.sourceforge.jtds.jdbc.Driver Add in testOnBorrow=true validationQuery=select 1 this ensures that if the DB closes a connection, the pool validates it best Filip - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3555 - Release Date: 04/06/11 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3555 - Release Date: 04/06/11 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
Got it. Thanks any other suggestions will be great (i'll add these string in a few days) 2011/4/6 Filip Hanik - Dev Lists devli...@hanik.com On 4/6/2011 1:54 PM, הילה wrote: I wanted to add the last string as well, but they said to forget about it.. :] and they should know best however, if disconnections will continue (there are some right now) I'll try it anyway as for the connection validation = you said that if the DB closes a connection (why does it happen? can I prevent it?) most common is that the DB times out an idle connection. A pool holds a connection open, the connection is not being used and the DB times it out. there are many examples, same thing if there is a network glitch, or the db is restarted. than the pool is checking if the connection is open and working. and if not? i the DB closed the connection and it's not usable.. then what does the pool do? if the pool doesn't check, then it doesn't do anything. if the pool check (testOnBorrow=true) and the test fails, it closes the old connection and opens a new one. Filip 2011/4/6 Filip Hanik - Dev Listsdevli...@hanik.com validate == connection is open and working if they are worried about performance, there is a compromise that gets you best of both worlds testOnBorrow=true validationQuery=select 1 validationInterval=3 this ensures that in a high concurrency environment, the number of validations are limited Filip On 4/6/2011 1: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 do you mean validates it? what does it do, exactly? Thanks Hila 2011/4/6 Filip Hanik - Dev Listsdevli...@hanik.com On 4/5/2011 7:31 AM, הילה wrote: name=jdbc/com/vstechnology/appname scope=Shareable type=javax.sql.Datasource url=jdbc:jtds:sqlserver://SQLServerName:1433/DBname;useCursors=false;sendStringParametersAsUnicode=false factory=org.apache.tomcat.jdbc.pool.DataSourceFactory maxActive=200 minIdle=0 maxIdle=10 maxWait=1 initialSize=20 driverClassName=net.sourceforge.jtds.jdbc.Driver Add in testOnBorrow=true validationQuery=select 1 this ensures that if the DB closes a connection, the pool validates it best Filip - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3555 - Release Date: 04/06/11 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1209 / Virus Database: 1500/3555 - Release Date: 04/06/11 - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: JDBC Pool Disconnections
-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