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="30000"
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 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="10000"
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
