In the BugParade, bug #4113225 (at
http://developer.java.sun.com/developer/bugParade/bugs/4113225.html) details
what I believe to be your problem - concurrent access of ODBC crashes the
server. There is even sample code to reproduce the problem. Sun's
evaluation - Not supported, not to be fixed, use commercial.
Also, while JDK 1.1.6 does run on 2000, Sun only recommends using
the JDK 1.1.8 on Windows 2000 (and only JDK 1.1.8_007 on Pentium IV), if you
are going to use JDK 1.1.x. (I couldn't find any specific warnings but did
find a few bugs in the Bug Parade).
So, I would suggest change your database drivers. I believe that
there is a free software effort at freetds.org and I would like to plug the
drivers we use from inetsoftware.de (we use it without any problems). I
would also suggest upgrading your JDK to 1.1.8. I would not use MySQL in
place of SQL Server. If you must leave SQL Server, try PostgreSQL. (MySQL
doesn't pass the ACID test, which causes all sorts of problems for people
worried about data consistency and integrity)
Randy
> -----Original Message-----
> From: Andy C [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 12, 2001 7:30 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Fed up to the back teeth with tomcat !!!
>
>
> Many Many thanks for that, I'll get to it right away.
>
> Andy
>
>
>
> ----- Original Message -----
> From: "Sandy McPherson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, April 12, 2001 11:48 AM
> Subject: Re: Fed up to the back teeth with tomcat !!!
>
>
> >
> >
> > Andy C wrote:
> >
> > > ----- Original Message -----
> > > From: "Sandy McPherson" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
>
> > Here's a concrete suggestion to improve your debugging....
> >
> > Your users are probably seeing the stack trace you yourself
> want to see,
> > so set up an error page which writes any exceptions to a
> log file and
> > possibly mails the exceptions thrown in the production
> system to you. In
> > each servlet you should do a catch( Throwable ex ) around
> the servlet
> > body and report the exception before re-throwing the it.
> >
> > I have attached a tag class which you can hack about to acheive the
> > desired effect. I have hacked out most of the stuff specific to my
> > environment, so it may not work "out of the box". I guess
> you can figure
> > out what should go in the TLD.
> >
> > The mail is probably a luxury, but it will wake up your operators!
> >
> >
>
>