This is so strange... i switched to a commercial driver and deadlocks started to arise (hangs stopped)... i made some changes in the transaction logic and everything went fine... after talking with a JTDS developer I switched to JTDS again to force him to freeze so I could get some debug information for him.... now it doesn't hang anymore !!!! it has been running from yesterday afternoon (almost twenty hours) with full load and it has not presented any problems...
I'm just puzzled... On Wed, 2 Feb 2005 08:02:21 +0200, Igor <[EMAIL PROTECTED]> wrote: > 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" <tomcat-user@jakarta.apache.org>; "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/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: [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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
