tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From הילה <hilavalen...@gmail.com>
Subject Re: JDBC Pool Disconnections
Date Wed, 06 Apr 2011 19:54:29 GMT
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 <devlists@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="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<devlists@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-unsubscribe@tomcat.apache.org
>>> For additional commands, e-mail: users-help@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-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message