tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Igor" <ia_...@ukr.net>
Subject Re: Failed JDBC connection hangs Tomcat
Date Tue, 01 Feb 2005 14:10:04 GMT
Hello!

I am referring to JTDS 1.0.
I think, that the problem is in net.sourceforge.jtds.jdbc.SharedSocket 
class: it should set timeout for socket, otherwise
methods getNetPacket and sendNetPacket may hang.

Igor

----- Original Message ----- 
From: "Arthur D'Alessandro" <art.dalessandro@gmail.com>
To: "Tomcat Users List" <tomcat-user@jakarta.apache.org>; "Hari Mailvaganam" 
<hariubc@gmail.com>
Cc: "Igor" <ia_rud@ukr.net>
Sent: Tuesday, February 01, 2005 3:40 PM
Subject: Re: Failed JDBC connection hangs Tomcat


> What version of the JTDS are you referring to, I know they recently
> released 1.0 code...
>
>
> On Sun, 30 Jan 2005 20:06:07 -0800, Hari Mailvaganam <hariubc@gmail.com> 
> wrote:
>> The JTDS driver can cause the hanging you described - this has occured
>> in a test we did on Win 2k, SQL Server 2k, 1.5 JDK.
>>
>> reagrds,
>>
>> Hari Mailvaganam
>>
>>
>> On Sun, 30 Jan 2005 08:39:50 +0200, Igor <ia_rud@ukr.net> wrote:
>> > We have the same problem, that described in
>> >
>> > http://www.mail-archive.com/tomcat-user@jakarta.apache.org/msg58799.html
>> >
>> > There is ServletContextListener in our application, that schedule two 
>> > tasks for repeated fixed rate execution on context initialization 
>> > (Timer.scheduleAtFixedRate).
>> >
>> > First task is executed every minute. It queries MS SQL server, second 
>> > task is executed every hour.
>> >
>> > If MS SQL server goes down, first task tries to use connection to 
>> > database.
>> > After this Tomcat may hang: when user tries to download a page, he or 
>> > her will wait for a long time (more that 1 day).
>> >
>> > At the same time second taks (that is executed every hour) works as it 
>> > was expected: there are corresponding entries in log file.
>> >
>> > First task is executed in separate thread, and I do not understand how 
>> > can it hang whole tomcat (at least one context).
>> >
>> > We use JDK 1.5, tomcat 5.0.28. The same problem was on 1.4.2. Both for 
>> > MS and JTDS drivers :-(
>> >
>> > Does somebody know how can I prevent tomcat from hang in such 
>> > situations?
>> >
>> > Thank you in advance,
>> > Igor
>> >
>> > ---------------------------------------------------------------------
>> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>> >
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>>
>>
>
>
> -- 
> -Art D'Alessandro
>
> 


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message