Hello!
I sent answer to tomcat users yesterday, but it seems not to be accepted ...
So I am sending it once more ...
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" <[EMAIL PROTECTED]>
To: "Tomcat Users List" <[email protected]>; "Hari
Mailvaganam" <[EMAIL PROTECTED]>
Cc: "Igor" <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> wrote:
> We have the same problem, that described in
>
> http://www.mail-archive.com/[email protected]/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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
-Art D'Alessandro
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
