Re: Thanks: Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Andy C

- Original Message -
From: "Jeff Kilbride" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; "Andy C" [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2001 11:25 PM
Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
 Hi Andy,

 Did you ever post your configuration? I would be interested in what OS;
 Tomcat/Apache versions; JVM; DB backend and driver; whether or not you're

I have to admit that the configuration is a little complex, mostly because
of legacy
database and servlets left over from the JavaWebserver version.  Here goes
though:

Server is NT2000
Apache is  1.3.12 with mod_jk
Tomcat is 3.2.2.b2 (I upgraded from 3.2.1 in the hope it would fix the
problem.)
JVM is 1.1.6 (old version but it's the only one that would run a legacy
servlet)

Databases are:
mysql 3.23.28 (Handles all the main jsp stories)
SQL server V7 (Handles servlet requests for release dates)

JDBC bridge to mysql is mm-mysql-2.0.4
JDBC-ODBC bridge for SQL server (This could be the problem)

Hope this is of interest.

Andy C
Editor R2 Project
http://www.r2-dvd.org





RE: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Sandy McPherson

I have had no trouble with Apache and Tomcat running A MySQL database, the
mm JDBC library behaves itself impeccably. So I think the problem is as the
others have said not likely to lie in the JDBC not in Tomcat/Apache.

IMHO: before you go blaming something in public you should first identify
the problem lies actually with the product you are slagging. Perhaps you
should change your database to mysql!

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]
 On Behalf Of Fernando Padilla
 Sent: Thursday, April 12, 2001 6:33 AM
 To: [EMAIL PROTECTED]
 Subject: Re: Fed up to the back teeth with tomcat !!!



 Hmm, interesting..

 I did have a similar issue with an Oracle driver a while back. Yes, the
 Debugging helped alot.  So I was driven to doing a System.gc(); after
 and/or before every statement... :)

 I think discovered this, assuming that all of that io and String creation
 forced a gc... and it seems to work now :):)




 On Wed, 11 Apr 2001, Lyle H. Ward wrote:

  Since you are using SQL server, are you using ODBC? There is a
 bug in ODBC
  that stops the [web] service. It doesn't affect all
 installations. If this
  is what's happening, there is an awful work-around. Turn on
 ODBC tracing. It
  prevents the service from halting but creates a monster log file.
 
 
  At 08:11 PM 4/11/2001 +0100, you wrote:
  I am fed up to the back teeth with Tomcat under Apache.  I'm
 trying to run
  a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
  to reset the damn server 3 times today already.
  
  It keeps falling over
  with absolutly no error  *** log messages at all.  I am at
 my wits end,
  not
  to mention my poor users who have had to put up with this
 service for the
  past month.  I am totaly lost now as to where to look for solutions
  
  So can someone please recomend a good webserver that will run .jsp and
  servlets pages and integrates well with a SQL server ?  I used to
  run Java Webserver 2.0 would going back to that help ?
  
  Andy C
  Editor R2 Project
  http://www.r2-dvd.org
  (lets hopr you don't see a 500 internal error message.)
  
  
  
 






re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Andy C


- Original Message -
From: "Sandy McPherson" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 9:06 AM
Subject: RE: Fed up to the back teeth with tomcat !!!


 IMHO: before you go blaming something in public you should first identify
 the problem lies actually with the product you are slagging. Perhaps you
 should change your database to mysql!

Yes, I would like to apologise for that.  Please understand last night I was
extremly irratable and unreasonable after a day of frustration.

Note:  I am uses mysql as well as SQL-server7.0.  As I have intimated in
another message SQL-server is being used as it is is a "legacy" database.
The main page is generated from a  mysql databse, only release date
queries are  being generated from SQL-server.

I also have the problem that after a month of trying to find out where the
problem lies (by examing logs, hammering a test server with request etc) I
am no nearer to the truth.  I will however persevere.

BTW
Is there an easy way to import a SQL-Server database into mysql ?  At least
that way I could dump the jdbc-odbc bridge ?

Regards
Andy C
Editor R2 project
http://www.r2-dvd.org






Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Arthur Veinstein

Hi,
we also use the same configuration (5 * RH Linux 6, Tomcat 3.2.1, Apache
1.3.9, Sun JDK 1.2, Alteon web load balancer)
serving  2 pages per day and connecting to DB using RMI, we only
restart on application updates (3 months)

Arthur Veinstein
- Original Message -
From: "Kevin Sangeelee" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 1:26 AM
Subject: RE: Fed up to the back teeth with tomcat !!!


 And another, we're serving up  5000 pages per day from our application
 (April stats), Tomcat has never crashed, and has run for well over a month
 without hitch (restarting Tomcat only necessary when the application gets
 updated). RH Linux 6, Tomcat 3.2.1, Apache 1.3.9, Sun JDK 1.2

 Kevin

 On Wed, 11 Apr 2001, Randy Layman wrote:

 
  I have a success story to the contrary - using Windows NT 4, Tomcat
  3.2.1, and IIS 4 we are serving a decent sized application with no
problems.
  We've been averaging uptimes of about 5 - 6 days before the machine is
  restarted because of other software on the machine.  No detectable
resource
  loss, no crashes.
 





Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread BenoƮt Jacquemont

I use Tomcat 3.2.1, Apache 1.3.12, mod_jk (own build) on a Linux RedHat 6.2
box (kernel 2.2.14). The database is MySQL 3.23 and I use the mm JDBC
driver.

The application has worked perfectly great since the beginning of March with
a medium and sometimes heavy charge, without any rebooting...

Before putting fire to Tomcat just because it is a free software, you should
take a look at the other over-expensive products from big (and reliable
?) company... You should maybe use one of the new service pack/patches
that makes Win2K a little bit less a beta product...
By the way, what are the others softwares running on your machine ? (There's
always a lot of stuff that Win2K settles on your machine without any
warning. It needs long time before having a slightly clean Win2K server.)
I don't want to start a war, I use a lot of Microsoft products and I'm happy
with them (Office is really great). But when you set up a server, you have
to take EVERYTHING into account.

Anyway, the use of ODBC with SQL Server is the right choice because it is
the natural and native way to talk to a SQL Server database.

Benot


 -Message d'origine-
 De : Andy C [mailto:[EMAIL PROTECTED]]
 Envoy : jeudi 12 avril 2001 09:23
  : [EMAIL PROTECTED]
 Objet : Re: Thanks: Re: Fed up to the back teeth with tomcat !!!


 - Original Message -
 From: "Jeff Kilbride" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]; "Andy C" [EMAIL PROTECTED]
 Sent: Wednesday, April 11, 2001 11:25 PM
 Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
  Hi Andy,
 
  Did you ever post your configuration? I would be interested
 in what OS;
  Tomcat/Apache versions; JVM; DB backend and driver; whether
 or not you're

 I have to admit that the configuration is a little complex,
 mostly because
 of legacy
 database and servlets left over from the JavaWebserver
 version.  Here goes
 though:

 Server is NT2000
 Apache is  1.3.12 with mod_jk
 Tomcat is 3.2.2.b2 (I upgraded from 3.2.1 in the hope it would fix the
 problem.)
 JVM is 1.1.6 (old version but it's the only one that would
 run a legacy
 servlet)

 Databases are:
 mysql 3.23.28 (Handles all the main jsp stories)
 SQL server V7 (Handles servlet requests for release dates)

 JDBC bridge to mysql is mm-mysql-2.0.4
 JDBC-ODBC bridge for SQL server (This could be the problem)

 Hope this is of interest.

 Andy C
 Editor R2 Project
 http://www.r2-dvd.org





RE: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Samson, Lyndon [IT]

You could allways get the source to Tomcat, and insert your own logging!!!

Ooh now, there's an idea :-)


-Original Message-
From: Andy C [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 9:34 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: re: Fed up to the back teeth with tomcat !!!



- Original Message -
From: "Sandy McPherson" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 9:06 AM
Subject: RE: Fed up to the back teeth with tomcat !!!


 IMHO: before you go blaming something in public you should first identify
 the problem lies actually with the product you are slagging. Perhaps you
 should change your database to mysql!

Yes, I would like to apologise for that.  Please understand last night I was
extremly irratable and unreasonable after a day of frustration.

Note:  I am uses mysql as well as SQL-server7.0.  As I have intimated in
another message SQL-server is being used as it is is a "legacy" database.
The main page is generated from a  mysql databse, only release date
queries are  being generated from SQL-server.

I also have the problem that after a month of trying to find out where the
problem lies (by examing logs, hammering a test server with request etc) I
am no nearer to the truth.  I will however persevere.

BTW
Is there an easy way to import a SQL-Server database into mysql ?  At least
that way I could dump the jdbc-odbc bridge ?

Regards
Andy C
Editor R2 project
http://www.r2-dvd.org





Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Jon Barber

You may have already tried this, but you could always download a different 
servlet engine such as JRun and try out your servlets with the new engine.  
If you see the same problems then the problem probably isn't with tomcat.

Jon.


On Thursday 12 April 2001 08:34, you wrote:
 - Original Message -
 From: "Sandy McPherson" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 12, 2001 9:06 AM
 Subject: RE: Fed up to the back teeth with tomcat !!!

  IMHO: before you go blaming something in public you should first identify
  the problem lies actually with the product you are slagging. Perhaps you
  should change your database to mysql!

 Yes, I would like to apologise for that.  Please understand last night I
 was extremly irratable and unreasonable after a day of frustration.

 Note:  I am uses mysql as well as SQL-server7.0.  As I have intimated in
 another message SQL-server is being used as it is is a "legacy" database.
 The main page is generated from a  mysql databse, only release date
 queries are  being generated from SQL-server.

 I also have the problem that after a month of trying to find out where the
 problem lies (by examing logs, hammering a test server with request etc) I
 am no nearer to the truth.  I will however persevere.

 BTW
 Is there an easy way to import a SQL-Server database into mysql ?  At least
 that way I could dump the jdbc-odbc bridge ?

 Regards
 Andy C
 Editor R2 project
 http://www.r2-dvd.org



Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread andy


- Original Message -
From: "Benot Jacquemont" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 9:50 AM
Subject: Re: Fed up to the back teeth with tomcat !!!



 Before putting fire to Tomcat just because it is a free software, you
should
 take a look at the other over-expensive products from big (and reliable
 ?) company... You should maybe use one of the new service pack/patches
 that makes Win2K a little bit less a beta product...

Please,
I'v no wish to start a war here   For the most part I am very happy with
Tomcat,
the development of the application went reasonably smothly and it was easy
to
set up.Both Apache and mySQL work like a dream so there's two "freeware"
solutions I'm over the moon with.

If only I could reproduce the fault and diagnose it I would be very happy !
I will
howver continue to work on the probelm. As one poster suggeted if neccessary
I'll hack the source code of tomcat to generate the logs I need !

Regards
Andy C





RE: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Danny Angus


 BTW
 Is there an easy way to import a SQL-Server database into mysql ?
  At least
 that way I could dump the jdbc-odbc bridge ?

if you have fewer than 100's of tables use rational rose to de-construct the
SQL server into DDL, throw away all the relationship definitions [sic],
switch a few data types, select everything from SQL server into a tab delim
or csv file, and bingo.. ready for import into mysql




Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Sandy McPherson



Andy C wrote:

 - Original Message -
 From: "Sandy McPherson" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 12, 2001 9:06 AM
 Subject: RE: Fed up to the back teeth with tomcat !!!
 
 
 IMHO: before you go blaming something in public you should first identify
 the problem lies actually with the product you are slagging. Perhaps you
 should change your database to mysql!
 
 
 Yes, I would like to apologise for that.  Please understand last night I was
 extremly irratable and unreasonable after a day of frustration.

I know the feeling...


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!



/*
** $Log: MailException.java,v $
** Revision 1.2  2001/02/23 17:20:37  sandy
** Tidy up exception handling
**
** Revision 1.1  2001/02/15 15:17:02  sandy
** Make error page mail exceptions to admin.
**
*/
package com.mapquest.environment;

import java.lang.*;
import java.io.*;
import java.sql.SQLException;
import java.util.Properties;
import javax.mail.*;
import javax.mail.internet.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;

/**
** Class to mail an exception to the admninistrator
** p
** This is a tag which should be used from a JSP error page
** /p
*/
public class MailException extends TagSupport
{
   
   /**
   ** Constructs a mailable exception
   ** p
   ** /p
   ** @exception The exception whose details should be mailed
   */
   public int doStartTag( )
  throws JspTagException
   {
  try
  {
 ServletContext application = pageContext.getServletContext( );
 Throwable exception = (Throwable)pageContext.getAttribute( 
"exception" ); 
 StringWriter trace = new StringWriter( );
 PrintWriter traceWriter = new PrintWriter ( trace );
 exception.printStackTrace( traceWriter );
 JspWriter out = pageContext.getOut( );
 System.out.println( trace.toString( ) );
 try
 {
SQLException dbex = (SQLException)exception;
System.out.println( "SQL ANSI 92 State = "+dbex.getSQLState( ) 
);
System.out.println( "SQL Error Code = "+dbex.getErrorCode( ) );
 }
 catch( java.lang.ClassCastException ex )
 {
 }
 try
 {
// 
// see if this is a servlet exception
//
Throwable rootcause = 
((ServletException)exception).getRootCause( );
if ( rootcause != null )
{
   StringWriter roottrace = new StringWriter( );
   PrintWriter roottraceWriter = new PrintWriter ( roottrace );
   rootcause.printStackTrace( roottraceWriter );
   System.out.println( "Root Cause:" );
   System.out.println( roottrace.toString( ) );
   SQLException dbex = SQLException)rootcause;
   System.out.println( "SQL ANSI 92 State = 
"+dbex.getSQLState( ) );
   System.out.println( "SQL Error Code = "+dbex.getErrorCode( 
) );
}
 }
 catch( java.lang.ClassCastException ex )
 {
 }

//
// mail the message
//
String smtphost = application.getInitParameter( 
"MAIL.SMTP.HOST" );
if ( smtphost == null )
{
   throw new JspTagException( "MAIL.SMTP.HOST not set");
}

String to = application.getInitParameter("MAIL.ADMIN.EMAIL");
if ( to == null )
{
   throw new JspTagException( "MAIL.ADMIN.EMAIL not set");
}
//

RE: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Samson, Lyndon [IT]

Hi Alistair,

I tried to get to the Virtuso link www.openlink.com buts its a redirect to
internet.com Was your email some kind of clever spam :-)



-Original Message-
From: Alistair Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:48 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Fed up to the back teeth with tomcat !!!


For more complex data transfers between databases, take a look at virtuoso
at openlink.com.

It's a meta-database-engine that lets you write SQl loading from one
database into another.

This is nice as you can remove early-effort-stupidities and rearrange your
schema when moving db.

Al.

-Original Message-
From: Danny Angus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:13 AM
To: [EMAIL PROTECTED]
Subject: RE: Fed up to the back teeth with tomcat !!!



 BTW
 Is there an easy way to import a SQL-Server database into mysql ?
  At least
 that way I could dump the jdbc-odbc bridge ?

if you have fewer than 100's of tables use rational rose to de-construct the
SQL server into DDL, throw away all the relationship definitions [sic],
switch a few data types, select everything from SQL server into a tab delim
or csv file, and bingo.. ready for import into mysql






Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Andy C

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!
 
 





RE: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Alistair Hopkins

very sorry.

try www.openlinksw.com/virtuoso

no spam is clever spam

did I mention it's free for  4 connections?  but not opensource...



-Original Message-
From: Samson, Lyndon [IT] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 12:27 PM
To: '[EMAIL PROTECTED]'
Subject: RE: Fed up to the back teeth with tomcat !!!


Hi Alistair,

I tried to get to the Virtuso link www.openlink.com buts its a redirect to
internet.com Was your email some kind of clever spam :-)



-Original Message-
From: Alistair Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:48 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Fed up to the back teeth with tomcat !!!


For more complex data transfers between databases, take a look at virtuoso
at openlink.com.

It's a meta-database-engine that lets you write SQl loading from one
database into another.

This is nice as you can remove early-effort-stupidities and rearrange your
schema when moving db.

Al.

-Original Message-
From: Danny Angus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:13 AM
To: [EMAIL PROTECTED]
Subject: RE: Fed up to the back teeth with tomcat !!!



 BTW
 Is there an easy way to import a SQL-Server database into mysql ?
  At least
 that way I could dump the jdbc-odbc bridge ?

if you have fewer than 100's of tables use rational rose to de-construct the
SQL server into DDL, throw away all the relationship definitions [sic],
switch a few data types, select everything from SQL server into a tab delim
or csv file, and bingo.. ready for import into mysql







RE: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Randy Layman


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!
  
  
 
 



RE: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Lyle H. Ward

Yahoo says www.openlinksw.com
Virtuso database

At 12:27 PM 4/12/2001 +0100, you wrote:
Hi Alistair,

I tried to get to the Virtuso link www.openlink.com buts its a redirect to
internet.com Was your email some kind of clever spam :-)



-Original Message-
From: Alistair Hopkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:48 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Fed up to the back teeth with tomcat !!!


For more complex data transfers between databases, take a look at virtuoso
at openlink.com.

It's a meta-database-engine that lets you write SQl loading from one
database into another.

This is nice as you can remove early-effort-stupidities and rearrange your
schema when moving db.

Al.

-Original Message-
From: Danny Angus [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 11:13 AM
To: [EMAIL PROTECTED]
Subject: RE: Fed up to the back teeth with tomcat !!!



 BTW
 Is there an easy way to import a SQL-Server database into mysql ?
  At least
 that way I could dump the jdbc-odbc bridge ?

if you have fewer than 100's of tables use rational rose to de-construct the
SQL server into DDL, throw away all the relationship definitions [sic],
switch a few data types, select everything from SQL server into a tab delim
or csv file, and bingo.. ready for import into mysql









Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Robert Keddie



what did you find that was better?

Robert Keddieweb developmentMarion County, FL 
[EMAIL PROTECTED] 04/11/01 03:11PM I am fed up to the back teeth 
with Tomcat under Apache. I'm trying to runa 24/7 web page servinbg 
around 20,000 .jsp pages a day and I'v ehadto reset the damn server 3 times 
today already.It keeps falling overwith absolutly no error 
*** log messages at all. I am at my wits end,notto mention my poor 
users who have had to put up with this service for thepast month. I am 
totaly lost now as to where to look for solutionsSo can someone please 
recomend a good webserver that will run .jsp andservlets pages and 
integrates well with a SQL server ? I used torun Java Webserver 2.0 
would going back to that help ?Andy CEditor R2 Projecthttp://www.r2-dvd.org(lets hopr you don't 
see a 500 internal error message.)


RE: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Danny Angus


  possibly mails the exceptions thrown in the production system

Mailing responsible people (other than yourself, obviously) for every 500
error is a *great* wakeup call to nail shoddy workmanship.




Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Scott Tatum

At WorldCom our group is using Tomcat 3.2.1 along with various versions of
Apache and Solaris in production environments for Intranet applications. We
have one production box serving several apps via virtual hosts, each with their
own Tomcat instance. They all get thousands of hits a day (one of them averages
over 10k) and we never have to restart the server for anything other than to
upgrade the application files periodically. Now that I have fixed the
utilization problems I am VERY happy with the stability and performance of
Tomcat in a production environment, and my bosses are too. :)

-Scott
--
Scott Tatum | [EMAIL PROTECTED]
Senior Applications Developer, Special Projects
WorldCom | http://www.wcom.com/

Srinivas Kurella wrote:

 I have the same problem. I am running tomcat 3.2.1 on solaris without
 apache. There is not much of a db activity going on. To me it looks as if
 tomcat dies even if there is no activity or hits after a while.
 From the other messages , it looks like it is a bit  more stable on Linux
 than other OSs.

 Srini

 -Original Message-
 From: Kevin Sangeelee [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 4:27 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Fed up to the back teeth with tomcat !!!

 And another, we're serving up  5000 pages per day from our application
 (April stats), Tomcat has never crashed, and has run for well over a month
 without hitch (restarting Tomcat only necessary when the application gets
 updated). RH Linux 6, Tomcat 3.2.1, Apache 1.3.9, Sun JDK 1.2

 Kevin

 On Wed, 11 Apr 2001, Randy Layman wrote:

 
I have a success story to the contrary - using Windows NT 4, Tomcat
  3.2.1, and IIS 4 we are serving a decent sized application with no
 problems.
  We've been averaging uptimes of about 5 - 6 days before the machine is
  restarted because of other software on the machine.  No detectable
 resource
  loss, no crashes.
 






Update: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Andy C

Many thanks to all who have taken the time to answer our 
rather irratable plea for help.  Although we haven't 100% got the 
solution, following advice from Randy Layman, we have upgraded
our JVM to 1.1.8 (remember there is a lagacy servlet that will not
run on a higher JVM).  We have also changed from the 
sun JDBC-ODBC driver to a type 4 JDBC driver from 
http://www.freetds.org/  for access to the SQL Server database.


We will report back if these changes stabalise the platform and 
keep on running.

Many thanks once again to one and all...

Andy C
Editor R2 project
http://www.r2-dvd.org





Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Manish

Hi All,

Is it possible to use connection pooling using jConnect 5.2 , tomcat 
3.2. I want to use the file server as my service provider cause we dont 
want to implement LDAP server. what are the necessary configuration 
steps needed to do that (if possible). Kindly advice.

Thanks and Regards

Manish




Bad news 2nd Update: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Andy C

Sadly this has made no difference at all.  Tomcat fell
over after about 2 hours usage so it's back to the drawing board.

Andy C

-Original Message-
From: Andy C [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: 12 April 2001 16:56
Subject: Update: Fed up to the back teeth with tomcat !!!


Many thanks to all who have taken the time to answer our 
rather irratable plea for help.  Although we haven't 100% got the 
solution, following advice from Randy Layman, we have upgraded
our JVM to 1.1.8 (remember there is a lagacy servlet that will not
run on a higher JVM).  We have also changed from the 
sun JDBC-ODBC driver to a type 4 JDBC driver from 
http://www.freetds.org/  for access to the SQL Server database.






Re: Thanks: Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Jeff Kilbride

If I were to pick the weakest link, it'd probably be the jdbc-odbc bridge.
FYI, for my own stress tests, I was able to run 24 hours at 20+ hits/second
using Tomcat 3.2.1, IBMJava2-13, Apache 1.3.19, mod_jk w/ajp13, into a MySQL
3.23.35 database. This was all running on a fairly cheap linux box -- RedHat
6.2, 2.2.17 kernel, 128MB RAM, everything on one IDE drive. I was using a
test suite with 25 concurrent threads on another machine (WinNT) connected
by a 100bT ethernet doing simple insert statements. I actually got the
Tomcat/Linux box up to 54 inserts per second, but the load average
skyrocketed so I cut it back to something reasonable. Almost 2 million
records into my database without a glitch. I was actually very surprised by
the performance, since I hadn't tweaked anything and I was using the default
Tomcat config.

Granted, my test was pretty simple. I was only using one servlet and no .jsp
pages.

Are there any alternatives to the jdbc-odbc bridge? I thought that you used
to be able to use the Sybase drivers to connect to MS-SQL -- but that may
have been a long time ago and, obviously, nothing that was every officially
supported.

Thanks,
--jeff

- Original Message -
From: "Andy C" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 12:22 AM
Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!


 - Original Message -
 From: "Jeff Kilbride" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]; "Andy C" [EMAIL PROTECTED]
 Sent: Wednesday, April 11, 2001 11:25 PM
 Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
  Hi Andy,
 
  Did you ever post your configuration? I would be interested in what OS;
  Tomcat/Apache versions; JVM; DB backend and driver; whether or not
you're

 I have to admit that the configuration is a little complex, mostly because
 of legacy
 database and servlets left over from the JavaWebserver version.  Here goes
 though:

 Server is NT2000
 Apache is  1.3.12 with mod_jk
 Tomcat is 3.2.2.b2 (I upgraded from 3.2.1 in the hope it would fix the
 problem.)
 JVM is 1.1.6 (old version but it's the only one that would run a legacy
 servlet)

 Databases are:
 mysql 3.23.28 (Handles all the main jsp stories)
 SQL server V7 (Handles servlet requests for release dates)

 JDBC bridge to mysql is mm-mysql-2.0.4
 JDBC-ODBC bridge for SQL server (This could be the problem)

 Hope this is of interest.

 Andy C
 Editor R2 Project
 http://www.r2-dvd.org






Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Jeff Kilbride

Can you use BCP to output to a delimited file? Or is BCP only supported by
Sybase? I always forget between those two...

--jeff

- Original Message -
From: "Andy C" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 1:34 AM
Subject: re: Fed up to the back teeth with tomcat !!!



 - Original Message -
 From: "Sandy McPherson" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 12, 2001 9:06 AM
 Subject: RE: Fed up to the back teeth with tomcat !!!


  IMHO: before you go blaming something in public you should first
identify
  the problem lies actually with the product you are slagging. Perhaps you
  should change your database to mysql!

 Yes, I would like to apologise for that.  Please understand last night I
was
 extremly irratable and unreasonable after a day of frustration.

 Note:  I am uses mysql as well as SQL-server7.0.  As I have intimated in
 another message SQL-server is being used as it is is a "legacy" database.
 The main page is generated from a  mysql databse, only release date
 queries are  being generated from SQL-server.

 I also have the problem that after a month of trying to find out where the
 problem lies (by examing logs, hammering a test server with request etc) I
 am no nearer to the truth.  I will however persevere.

 BTW
 Is there an easy way to import a SQL-Server database into mysql ?  At
least
 that way I could dump the jdbc-odbc bridge ?

 Regards
 Andy C
 Editor R2 project
 http://www.r2-dvd.org







Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Jeff Kilbride

Hi Scott,

Just wondering what you meant by "utilization problems".

Thanks,
--jeff

- Original Message -
From: "Scott Tatum" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 8:32 AM
Subject: Re: Fed up to the back teeth with tomcat !!!


 At WorldCom our group is using Tomcat 3.2.1 along with various versions of
 Apache and Solaris in production environments for Intranet applications.
We
 have one production box serving several apps via virtual hosts, each with
their
 own Tomcat instance. They all get thousands of hits a day (one of them
averages
 over 10k) and we never have to restart the server for anything other than
to
 upgrade the application files periodically. Now that I have fixed the
 utilization problems I am VERY happy with the stability and performance of
 Tomcat in a production environment, and my bosses are too. :)

 -Scott
 --
 Scott Tatum | [EMAIL PROTECTED]
 Senior Applications Developer, Special Projects
 WorldCom | http://www.wcom.com/

 Srinivas Kurella wrote:

  I have the same problem. I am running tomcat 3.2.1 on solaris without
  apache. There is not much of a db activity going on. To me it looks as
if
  tomcat dies even if there is no activity or hits after a while.
  From the other messages , it looks like it is a bit  more stable on
Linux
  than other OSs.
 
  Srini
 
  -Original Message-
  From: Kevin Sangeelee [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, April 11, 2001 4:27 PM
  To: [EMAIL PROTECTED]
  Subject: RE: Fed up to the back teeth with tomcat !!!
 
  And another, we're serving up  5000 pages per day from our application
  (April stats), Tomcat has never crashed, and has run for well over a
month
  without hitch (restarting Tomcat only necessary when the application
gets
  updated). RH Linux 6, Tomcat 3.2.1, Apache 1.3.9, Sun JDK 1.2
 
  Kevin
 
  On Wed, 11 Apr 2001, Randy Layman wrote:
 
  
 I have a success story to the contrary - using Windows NT 4,
Tomcat
   3.2.1, and IIS 4 we are serving a decent sized application with no
  problems.
   We've been averaging uptimes of about 5 - 6 days before the machine is
   restarted because of other software on the machine.  No detectable
  resource
   loss, no crashes.
  







Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Simon Chatfield



I'm having this problem as well with the server crashing frequently
with no log entries, but in the ssl environment, are there success stories
in that environment as well, or has everything that's been working, been
in the non-ssl env.?
--
Simon Chatfield
VP, Software Development
Inteflux Inc.




RE: Thanks: Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread William Kaufman

There's a metric buttload of JDBC drivers out there, for every database:

  http://industry.java.sun.com/products/jdbc/drivers

For MS SqlServer alone, they list 27; for ODBC, 19.

-- Bill K.


 -Original Message-
 From: Jeff Kilbride [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, April 12, 2001 12:05 PM
 To: [EMAIL PROTECTED]
 Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
 
 
 If I were to pick the weakest link, it'd probably be the 
 jdbc-odbc bridge.
 FYI, for my own stress tests, I was able to run 24 hours at 
 20+ hits/second
 using Tomcat 3.2.1, IBMJava2-13, Apache 1.3.19, mod_jk 
 w/ajp13, into a MySQL
 3.23.35 database. This was all running on a fairly cheap 
 linux box -- RedHat
 6.2, 2.2.17 kernel, 128MB RAM, everything on one IDE drive. I 
 was using a
 test suite with 25 concurrent threads on another machine 
 (WinNT) connected
 by a 100bT ethernet doing simple insert statements. I actually got the
 Tomcat/Linux box up to 54 inserts per second, but the load average
 skyrocketed so I cut it back to something reasonable. Almost 2 million
 records into my database without a glitch. I was actually 
 very surprised by
 the performance, since I hadn't tweaked anything and I was 
 using the default
 Tomcat config.
 
 Granted, my test was pretty simple. I was only using one 
 servlet and no .jsp
 pages.
 
 Are there any alternatives to the jdbc-odbc bridge? I thought 
 that you used
 to be able to use the Sybase drivers to connect to MS-SQL -- 
 but that may
 have been a long time ago and, obviously, nothing that was 
 every officially
 supported.
 
 Thanks,
 --jeff
 
 - Original Message -
 From: "Andy C" [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Thursday, April 12, 2001 12:22 AM
 Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
 
 
  - Original Message -
  From: "Jeff Kilbride" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]; "Andy C" [EMAIL PROTECTED]
  Sent: Wednesday, April 11, 2001 11:25 PM
  Subject: Re: Thanks: Re: Fed up to the back teeth with tomcat !!!
   Hi Andy,
  
   Did you ever post your configuration? I would be 
 interested in what OS;
   Tomcat/Apache versions; JVM; DB backend and driver; whether or not
 you're
 
  I have to admit that the configuration is a little complex, 
 mostly because
  of legacy
  database and servlets left over from the JavaWebserver 
 version.  Here goes
  though:
 
  Server is NT2000
  Apache is  1.3.12 with mod_jk
  Tomcat is 3.2.2.b2 (I upgraded from 3.2.1 in the hope it 
 would fix the
  problem.)
  JVM is 1.1.6 (old version but it's the only one that would 
 run a legacy
  servlet)
 
  Databases are:
  mysql 3.23.28 (Handles all the main jsp stories)
  SQL server V7 (Handles servlet requests for release dates)
 
  JDBC bridge to mysql is mm-mysql-2.0.4
  JDBC-ODBC bridge for SQL server (This could be the problem)
 
  Hope this is of interest.
 
  Andy C
  Editor R2 Project
  http://www.r2-dvd.org
 
 
 



Re: Fed up to the back teeth with tomcat !!!

2001-04-12 Thread Jeff Kilbride

I ran into this already myself. I was using the ServerName and ServerAlias
directives in Apache:

ServerName host.com
ServerAlias www.host.com

But my Host directive in server.xml was just for host.com. So, any request
to www.host.com caused the CPU-bound loop. I posted a few days ago asking if
wildcard or multiple host name capability was in the future for the Host
directive, like:

Host *.host.com
OR
Host host.com www.host.com

In my case, I don't want to use two Host directives, because that causes all
of my servlets to be instantiated twice -- once per host. Does anybody know
if pattern matching or multiple host capability will be added to the Host
directive in the future? I'd really like people to be able to pull up my
domain with or without the "www.", without re-initializing my servlets.

Thanks,
--jeff

- Original Message -
From: "Scott Tatum" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 12, 2001 2:22 PM
Subject: Re: Fed up to the back teeth with tomcat !!!


 There's an issue involving Tomcat 3.2.1 and its configuration (explained
in the
 release notes) where an improper configuration can trigger a CPU-bound
loop.
 This is very easy to do when setting up virtual hosts. I posted a few days
ago
 with a long explanation of my experiences with vhost setup if you want to
see
 more details.

 -Scott

 Jeff Kilbride wrote:

  Hi Scott,
 
  Just wondering what you meant by "utilization problems".
 
  Thanks,
  --jeff
 
  - Original Message -
  From: "Scott Tatum" [EMAIL PROTECTED]
  To: [EMAIL PROTECTED]
  Sent: Thursday, April 12, 2001 8:32 AM
  Subject: Re: Fed up to the back teeth with tomcat !!!
 
   At WorldCom our group is using Tomcat 3.2.1 along with various
versions of
   Apache and Solaris in production environments for Intranet
applications.
  We
   have one production box serving several apps via virtual hosts, each
with
  their
   own Tomcat instance. They all get thousands of hits a day (one of them
  averages
   over 10k) and we never have to restart the server for anything other
than
  to
   upgrade the application files periodically. Now that I have fixed the
   utilization problems I am VERY happy with the stability and
performance of
   Tomcat in a production environment, and my bosses are too. :)
  
   -Scott
   --
   Scott Tatum | [EMAIL PROTECTED]
   Senior Applications Developer, Special Projects
   WorldCom | http://www.wcom.com/
  
   Srinivas Kurella wrote:
  
I have the same problem. I am running tomcat 3.2.1 on solaris
without
apache. There is not much of a db activity going on. To me it looks
as
  if
tomcat dies even if there is no activity or hits after a while.
From the other messages , it looks like it is a bit  more stable on
  Linux
than other OSs.
   
Srini
   
-Original Message-
From: Kevin Sangeelee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 4:27 PM
    To: [EMAIL PROTECTED]
    Subject: RE: Fed up to the back teeth with tomcat !!!
   
And another, we're serving up  5000 pages per day from our
application
(April stats), Tomcat has never crashed, and has run for well over a
  month
without hitch (restarting Tomcat only necessary when the application
  gets
updated). RH Linux 6, Tomcat 3.2.1, Apache 1.3.9, Sun JDK 1.2
   
Kevin
   
On Wed, 11 Apr 2001, Randy Layman wrote:
   

   I have a success story to the contrary - using Windows NT 4,
  Tomcat
 3.2.1, and IIS 4 we are serving a decent sized application with no
problems.
 We've been averaging uptimes of about 5 - 6 days before the
machine is
 restarted because of other software on the machine.  No detectable

resource
 loss, no crashes.

  
  
  

 --
 Scott Tatum | [EMAIL PROTECTED]
 Senior Applications Developer, Special Projects
 WorldCom | http://www.wcom.com/






RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Faine, Mark

I understand your frustration, the lack of verbose/clear error messages in
the logs is a big problem I am having too.

-Mark


-Original Message-
From: Andy C [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:12 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Fed up to the back teeth with tomcat !!!


I am fed up to the back teeth with Tomcat under Apache.  I'm trying to run
a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
to reset the damn server 3 times today already.

It keeps falling over
with absolutly no error  *** log messages at all.  I am at my wits end,
not
to mention my poor users who have had to put up with this service for the
past month.  I am totaly lost now as to where to look for solutions

So can someone please recomend a good webserver that will run .jsp and
servlets pages and integrates well with a SQL server ?  I used to
run Java Webserver 2.0 would going back to that help ?

Andy C
Editor R2 Project
http://www.r2-dvd.org
(lets hopr you don't see a 500 internal error message.)



Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Simon Chatfield


I'm experiencing the same problem, though not serving as many pages, it goes
down without warning or messages about every 2 or 3 days... What's the
deal?


"Faine, Mark" wrote:

 I understand your frustration, the lack of verbose/clear error messages in
 the logs is a big problem I am having too.

 -Mark

 -Original Message-
 From: Andy C [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 2:12 PM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Fed up to the back teeth with tomcat !!!

 I am fed up to the back teeth with Tomcat under Apache.  I'm trying to run
 a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
 to reset the damn server 3 times today already.

 It keeps falling over
 with absolutly no error  *** log messages at all.  I am at my wits end,
 not
 to mention my poor users who have had to put up with this service for the
 past month.  I am totaly lost now as to where to look for solutions

 So can someone please recomend a good webserver that will run .jsp and
 servlets pages and integrates well with a SQL server ?  I used to
 run Java Webserver 2.0 would going back to that help ?

 Andy C
 Editor R2 Project
 http://www.r2-dvd.org
 (lets hopr you don't see a 500 internal error message.)




Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Hunter Hillegas

This scares me as I'm about to deploy my first big Apache/Tomcat/Postgre
site with 3.2.1...

Any ideas/solutions the developers can offer would be appreciated.

Hunter

 From: "Andy C" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date: Wed, 11 Apr 2001 20:11:33 +0100
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Fed up to the back teeth with tomcat  !!!
 
 I am fed up to the back teeth with Tomcat under Apache.  I'm trying to run
 a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
 to reset the damn server 3 times today already.




RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Brandon Cruz

I'm in the same situation, we're using tomcat to serve up between 1000-5000
jsp's per day.  If this thing is going to start crashing for no reason, it
would be nice to know in advance so that we can switch before we get too far
into it.  Does anyone have any more information about this?


-Original Message-
From: Hunter Hillegas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 2:30 PM
To: Tomcat User List
Subject: Re: Fed up to the back teeth with tomcat !!!


This scares me as I'm about to deploy my first big Apache/Tomcat/Postgre
site with 3.2.1...

Any ideas/solutions the developers can offer would be appreciated.

Hunter

 From: "Andy C" [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date: Wed, 11 Apr 2001 20:11:33 +0100
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Fed up to the back teeth with tomcat  !!!

 I am fed up to the back teeth with Tomcat under Apache.  I'm trying to run
 a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
 to reset the damn server 3 times today already.





RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Paul Ramos

We are about to go public with our first web and I am concerned now. Does changing the debug= in server.xml add any more output that you need Andy?

From: "Brandon Cruz" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED] 
To: <[EMAIL PROTECTED]>
Subject: RE: Fed up to the back teeth with tomcat !!! 
Date: Wed, 11 Apr 2001 14:45:07 -0500 

I'm in the same situation, we're using tomcat to serve up between 1000-5000 
jsp's per day. If this thing is going to start crashing for no reason, it 
would be nice to know in advance so that we can switch before we get too far 
into it. Does anyone have any more information about this? 


-Original Message- 
From: Hunter Hillegas [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, April 11, 2001 2:30 PM 
To: Tomcat User List 
Subject: Re: Fed up to the back teeth with tomcat !!! 


This scares me as I'm about to deploy my first big Apache/Tomcat/Postgre 
site with 3.2.1... 

Any ideas/solutions the developers can offer would be appreciated. 

Hunter 

 From: "Andy C" <[EMAIL PROTECTED]>
 Reply-To: [EMAIL PROTECTED] 
 Date: Wed, 11 Apr 2001 20:11:33 +0100 
 To: <[EMAIL PROTECTED]>
 Cc: <[EMAIL PROTECTED]>
 Subject: Fed up to the back teeth with tomcat !!! 
 
 I am fed up to the back teeth with Tomcat under Apache. I'm trying to run 
 a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad 
 to reset the damn server 3 times today already. 


Get your FREE download of MSN Explorer at http://explorer.msn.com


RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Randy Layman


I have a success story to the contrary - using Windows NT 4, Tomcat
3.2.1, and IIS 4 we are serving a decent sized application with no problems.
We've been averaging uptimes of about 5 - 6 days before the machine is
restarted because of other software on the machine.  No detectable resource
loss, no crashes.

The biggest cause of most people's problems when scaling (that I've
seen and helped to fix) is that they use insufficient database drivers that
can't support the concurrent load (such as the JDBC-ODBC bridge that can't
support two concurrent users).  Also, people tend to not remember that only
one thread can write to a file/socket at a time.

Randy

 -Original Message-
 From: Brandon Cruz [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 3:45 PM
 To: [EMAIL PROTECTED]
 Subject: RE: Fed up to the back teeth with tomcat !!!
 
 
 I'm in the same situation, we're using tomcat to serve up 
 between 1000-5000
 jsp's per day.  If this thing is going to start crashing for 
 no reason, it
 would be nice to know in advance so that we can switch before 
 we get too far
 into it.  Does anyone have any more information about this?
 
 
 -Original Message-
 From: Hunter Hillegas [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 2:30 PM
 To: Tomcat User List
 Subject: Re: Fed up to the back teeth with tomcat !!!
 
 
 This scares me as I'm about to deploy my first big 
 Apache/Tomcat/Postgre
 site with 3.2.1...
 
 Any ideas/solutions the developers can offer would be appreciated.
 
 Hunter
 
  From: "Andy C" [EMAIL PROTECTED]
  Reply-To: [EMAIL PROTECTED]
  Date: Wed, 11 Apr 2001 20:11:33 +0100
  To: [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Subject: Fed up to the back teeth with tomcat  !!!
 
  I am fed up to the back teeth with Tomcat under Apache.  
 I'm trying to run
  a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
  to reset the damn server 3 times today already.
 
 



Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Simon Chatfield

I'm using tomcat 3.2.1 on a linux 6.2 machine, same problem with jdk's 1.2.2
and 1.3v2


James Goodwill wrote:

 Which version of Tomcat are you using?

 -Original Message-
 From: Andy C [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 1:12 PM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Fed up to the back teeth with tomcat !!!

 I am fed up to the back teeth with Tomcat under Apache.  I'm trying to run
 a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
 to reset the damn server 3 times today already.

 It keeps falling over
 with absolutly no error  *** log messages at all.  I am at my wits end,
 not
 to mention my poor users who have had to put up with this service for the
 past month.  I am totaly lost now as to where to look for solutions

 So can someone please recomend a good webserver that will run .jsp and
 servlets pages and integrates well with a SQL server ?  I used to
 run Java Webserver 2.0 would going back to that help ?

 Andy C
 Editor R2 Project
 http://www.r2-dvd.org
 (lets hopr you don't see a 500 internal error message.)




RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Craig Pfeifer

This sounds like a business plan for a little startup consulting company if
I ever heard one. I know that Tomcat is the 'reference implementation,' but
how do you know when your load/needs outgrow Tomcat?

And when they do, what are the alternatives?

Craig Pfeifer
Software Engineer
Aether Systems, Software Products Division
703.847.3303 x2053
[EMAIL PROTECTED]

 -Original Message-
 From: Andy C [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 3:12 PM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Fed up to the back teeth with tomcat !!!
 
 
 I am fed up to the back teeth with Tomcat under Apache.  I'm 
 trying to run
 a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
 to reset the damn server 3 times today already.
 
 It keeps falling over
 with absolutly no error  *** log messages at all.  I am 
 at my wits end,
 not
 to mention my poor users who have had to put up with this 
 service for the
 past month.  I am totaly lost now as to where to look for solutions
 
 So can someone please recomend a good webserver that will run .jsp and
 servlets pages and integrates well with a SQL server ?  I used to
 run Java Webserver 2.0 would going back to that help ?
 
 Andy C
 Editor R2 Project
 http://www.r2-dvd.org
 (lets hopr you don't see a 500 internal error message.)
 



RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Brandon Cruz

So the only success story we have is someone that reboots their server every
5-6 days anyway.  Could this problem be related to the previous message sent
by George?



paste
hi,

i'm using tomcat with apache on RedHat 7.0

i'm using a WebPerformance software to test my webpage with multiple users
(100 users)

in the beginning it all works good but after about 15 minutes of stress test
i start getting this error with tomcat .
***
HANDLER THREAD PROBLEM: java.lang.NullPointerException
java.lang.NullPointerException
at
org.apache.tomcat.service.connector.AJP12ResponseAdapter.sendStatus(Ajp12Con
nectionHandler.java:439)
at
org.apache.tomcat.service.http.HttpResponseAdapter.endHeaders(HttpResponseAd
apter.java(Compiled Code))
at
org.apache.tomcat.core.BufferedServletOutputStream.sendHeaders(BufferedServl
etOutputStream.java:127)
at
org.apache.tomcat.core.BufferedServletOutputStream.reallyFlush(BufferedServl
etOutputStream.java(Compiled Code))
at
org.apache.tomcat.core.ResponseImpl.finish(ResponseImpl.java(Compiled Code))
at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:158)
at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java(Com
piled Code))
***

Does anyone know what may have caused this error and is there anyway to fix
it ?

thanks
Georges

/paste















 -Original Message-
 From: Andy C [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, April 11, 2001 3:12 PM
 To: [EMAIL PROTECTED]
 Cc: [EMAIL PROTECTED]
 Subject: Fed up to the back teeth with tomcat !!!


 I am fed up to the back teeth with Tomcat under Apache.  I'm
 trying to run
 a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
 to reset the damn server 3 times today already.

 It keeps falling over
 with absolutly no error  *** log messages at all.  I am
 at my wits end,
 not
 to mention my poor users who have had to put up with this
 service for the
 past month.  I am totaly lost now as to where to look for solutions

 So can someone please recomend a good webserver that will run .jsp and
 servlets pages and integrates well with a SQL server ?  I used to
 run Java Webserver 2.0 would going back to that help ?

 Andy C
 Editor R2 Project
 http://www.r2-dvd.org
 (lets hopr you don't see a 500 internal error message.)





RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread David M. Rosner

Hi All,

We've been running Tomcat for over 6 months on several farmed servers 
(linux) without any major problems. We serve out hundreds of thousands of 
JSPs a day and some days it crosses millions. We normally do monthly 
reboots of the server, but we do restart Apache every hour and only restart 
Tomcat when releasing new builds.

I have seen the servers come to a halt, but this is usually caused by our 
db connections being held up. When that happens the Tomcat processes 
escalate  400, and then the Apache processes escalate  500. This brings 
the machine to its knees. Fixing db bottlenecks and taking all static 
content off the application servers fixed those problems.

Maybe we've just been lucky...


- dave








At 04:12 PM 4/11/2001, Brandon Cruz wrote:
So the only success story we have is someone that reboots their server every
5-6 days anyway.  Could this problem be related to the previous message sent
by George?



paste
hi,

i'm using tomcat with apache on RedHat 7.0

i'm using a WebPerformance software to test my webpage with multiple users
(100 users)

in the beginning it all works good but after about 15 minutes of stress test
i start getting this error with tomcat .
***
HANDLER THREAD PROBLEM: java.lang.NullPointerException
java.lang.NullPointerException
 at
org.apache.tomcat.service.connector.AJP12ResponseAdapter.sendStatus(Ajp12Con
nectionHandler.java:439)
 at
org.apache.tomcat.service.http.HttpResponseAdapter.endHeaders(HttpResponseAd
apter.java(Compiled Code))
 at
org.apache.tomcat.core.BufferedServletOutputStream.sendHeaders(BufferedServl
etOutputStream.java:127)
 at
org.apache.tomcat.core.BufferedServletOutputStream.reallyFlush(BufferedServl
etOutputStream.java(Compiled Code))
 at
org.apache.tomcat.core.ResponseImpl.finish(ResponseImpl.java(Compiled Code))
 at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:158)
 at
org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java(Com
piled Code))
***

Does anyone know what may have caused this error and is there anyway to fix
it ?

thanks
Georges

/paste















  -Original Message-
  From: Andy C [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, April 11, 2001 3:12 PM
  To: [EMAIL PROTECTED]
  Cc: [EMAIL PROTECTED]
  Subject: Fed up to the back teeth with tomcat !!!
 
 
  I am fed up to the back teeth with Tomcat under Apache.  I'm
  trying to run
  a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
  to reset the damn server 3 times today already.
 
  It keeps falling over
  with absolutly no error  *** log messages at all.  I am
  at my wits end,
  not
  to mention my poor users who have had to put up with this
  service for the
  past month.  I am totaly lost now as to where to look for solutions
 
  So can someone please recomend a good webserver that will run .jsp and
  servlets pages and integrates well with a SQL server ?  I used to
  run Java Webserver 2.0 would going back to that help ?
 
  Andy C
  Editor R2 Project
  http://www.r2-dvd.org
  (lets hopr you don't see a 500 internal error message.)
 




Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Lyle H. Ward

Since you are using SQL server, are you using ODBC? There is a bug in ODBC
that stops the [web] service. It doesn't affect all installations. If this
is what's happening, there is an awful work-around. Turn on ODBC tracing. It
prevents the service from halting but creates a monster log file. 


At 08:11 PM 4/11/2001 +0100, you wrote:
I am fed up to the back teeth with Tomcat under Apache.  I'm trying to run
a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
to reset the damn server 3 times today already.

It keeps falling over
with absolutly no error  *** log messages at all.  I am at my wits end,
not
to mention my poor users who have had to put up with this service for the
past month.  I am totaly lost now as to where to look for solutions

So can someone please recomend a good webserver that will run .jsp and
servlets pages and integrates well with a SQL server ?  I used to
run Java Webserver 2.0 would going back to that help ?

Andy C
Editor R2 Project
http://www.r2-dvd.org
(lets hopr you don't see a 500 internal error message.)







Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread David Wall

 I have a success story to the contrary - using Windows NT 4, Tomcat
 3.2.1, and IIS 4 we are serving a decent sized application with no
problems.
 We've been averaging uptimes of about 5 - 6 days before the machine is
 restarted because of other software on the machine.  No detectable
resource
 loss, no crashes.

Not to start a Windows flame war, but 5-6 days is sad.  It's surely not a
"solution," and we surely wouldn't call it a success.

We've been running a moderate virtual domain Apache (probably with at least
50 different domain names) on JRun 2.3 (the old one) and MySQL on RedHat
Linux 7.0 without problem for 101 days now (and the site has been running
for about two years), with no reboots because of acting up software.

Our latest development effort is using Apache 1.3.19+modssl with TC
3.2.2beta2 and Postgresql 7.1beta4 on VA Linux's RH 6.2 distribution.  We
expect that site to go live in May, though unfortunately it's not likely to
be a high hits sort of site (it's a business site and naturally will need to
ramp up customers over time).  I'll try to remember to report on its
success/failure.  There's a low activity brochure site running now using the
same basic configuration (except for TC 3.2.1), but it's only been running
for 23 days.

David




Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Simon Chatfield


What versions of each have you been using? (apache tomcat) and what distribution
and linux kernal are you running? What jvm? I would love to have the success
you're having and really like tomcat when it's working for me.

p.s. My jsp back into rmi services so the reason for failure isn't connected to
the database or services as they both run through multiple tomcat deaths and
re-starts.

"David M. Rosner" wrote:

 Hi All,

 We've been running Tomcat for over 6 months on several farmed servers
 (linux) without any major problems. We serve out hundreds of thousands of
 JSPs a day and some days it crosses millions. We normally do monthly
 reboots of the server, but we do restart Apache every hour and only restart
 Tomcat when releasing new builds.

 I have seen the servers come to a halt, but this is usually caused by our
 db connections being held up. When that happens the Tomcat processes
 escalate  400, and then the Apache processes escalate  500. This brings
 the machine to its knees. Fixing db bottlenecks and taking all static
 content off the application servers fixed those problems.

 Maybe we've just been lucky...

 - dave

 At 04:12 PM 4/11/2001, Brandon Cruz wrote:
 So the only success story we have is someone that reboots their server every
 5-6 days anyway.  Could this problem be related to the previous message sent
 by George?
 
 
 
 paste
 hi,
 
 i'm using tomcat with apache on RedHat 7.0
 
 i'm using a WebPerformance software to test my webpage with multiple users
 (100 users)
 
 in the beginning it all works good but after about 15 minutes of stress test
 i start getting this error with tomcat .
 ***
 HANDLER THREAD PROBLEM: java.lang.NullPointerException
 java.lang.NullPointerException
  at
 org.apache.tomcat.service.connector.AJP12ResponseAdapter.sendStatus(Ajp12Con
 nectionHandler.java:439)
  at
 org.apache.tomcat.service.http.HttpResponseAdapter.endHeaders(HttpResponseAd
 apter.java(Compiled Code))
  at
 org.apache.tomcat.core.BufferedServletOutputStream.sendHeaders(BufferedServl
 etOutputStream.java:127)
  at
 org.apache.tomcat.core.BufferedServletOutputStream.reallyFlush(BufferedServl
 etOutputStream.java(Compiled Code))
  at
 org.apache.tomcat.core.ResponseImpl.finish(ResponseImpl.java(Compiled Code))
  at
 org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
 (Ajp12ConnectionHandler.java:158)
  at
 org.apache.tomcat.service.TcpConnectionThread.run(SimpleTcpEndpoint.java(Com
 piled Code))
 ***
 
 Does anyone know what may have caused this error and is there anyway to fix
 it ?
 
 thanks
 Georges
 
 /paste
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
   -Original Message-
   From: Andy C [mailto:[EMAIL PROTECTED]]
   Sent: Wednesday, April 11, 2001 3:12 PM
   To: [EMAIL PROTECTED]
   Cc: [EMAIL PROTECTED]
   Subject: Fed up to the back teeth with tomcat !!!
  
  
   I am fed up to the back teeth with Tomcat under Apache.  I'm
   trying to run
   a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
   to reset the damn server 3 times today already.
  
   It keeps falling over
   with absolutly no error  *** log messages at all.  I am
   at my wits end,
   not
   to mention my poor users who have had to put up with this
   service for the
   past month.  I am totaly lost now as to where to look for solutions
  
   So can someone please recomend a good webserver that will run .jsp and
   servlets pages and integrates well with a SQL server ?  I used to
   run Java Webserver 2.0 would going back to that help ?
  
   Andy C
   Editor R2 Project
   http://www.r2-dvd.org
   (lets hopr you don't see a 500 internal error message.)
  




Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Andy C

I am fed up to the back teeth with Tomcat under Apache.  I'm trying to run
a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
to reset the damn server 3 times today already.

It keeps falling over
with absolutly no error  *** log messages at all.  I am at my wits end,
not
to mention my poor users who have had to put up with this service for the
past month.  I am totaly lost now as to where to look for solutions

So can someone please recomend a good webserver that will run .jsp and
servlets pages and integrates well with a SQL server ?  I used to
run Java Webserver 2.0 would going back to that help ?

Andy C
Editor R2 Project
http://www.r2-dvd.org
(lets hopr you don't see a 500 internal error message.)




Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Tim O'Neil

At 01:47 PM 4/11/2001 -0700, you wrote:
We've been running a moderate virtual domain Apache (probably with at least
50 different domain names) on JRun 2.3 (the old one) and MySQL on RedHat
Linux 7.0 without problem for 101 days now (and the site has been running
for about two years), with no reboots because of acting up software.

I'm curious, what's a "moderate" virtual domain? And by
domain I assume you mean a virtual host. There's no such
thing as a "virtual domain".




Thanks: Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Andy C

Thanks to all for the  advice, 
I'll be running though suggestions over the next couple of days and 
report back.

Andy C





Re: Thanks: Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Jeff Kilbride

Hi Andy,

Did you ever post your configuration? I would be interested in what OS;
Tomcat/Apache versions; JVM; DB backend and driver; whether or not you're
using connection pooling and, if so, if it's a hand-rolled solution or a
specific product; any settings you're passing the JVM on the command line
(i.e. -mx, -ms, etc...); and anything else you can supply.

I've heard good things about Resin as a servlet container, if you're looking
for a commercial product -- http://www.caucho.com/

Thanks,
--jeff

- Original Message -
From: "Andy C" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 11, 2001 2:22 PM
Subject: Thanks: Re: Fed up to the back teeth with tomcat !!!


 Thanks to all for the  advice,
 I'll be running though suggestions over the next couple of days and
 report back.

 Andy C






RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Kevin Sangeelee

And another, we're serving up  5000 pages per day from our application
(April stats), Tomcat has never crashed, and has run for well over a month
without hitch (restarting Tomcat only necessary when the application gets
updated). RH Linux 6, Tomcat 3.2.1, Apache 1.3.9, Sun JDK 1.2

Kevin

On Wed, 11 Apr 2001, Randy Layman wrote:

 
   I have a success story to the contrary - using Windows NT 4, Tomcat
 3.2.1, and IIS 4 we are serving a decent sized application with no problems.
 We've been averaging uptimes of about 5 - 6 days before the machine is
 restarted because of other software on the machine.  No detectable resource
 loss, no crashes.
 




RE: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Srinivas Kurella

I have the same problem. I am running tomcat 3.2.1 on solaris without
apache. There is not much of a db activity going on. To me it looks as if
tomcat dies even if there is no activity or hits after a while. 
From the other messages , it looks like it is a bit  more stable on Linux
than other OSs.

Srini

-Original Message-
From: Kevin Sangeelee [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 11, 2001 4:27 PM
To: [EMAIL PROTECTED]
Subject: RE: Fed up to the back teeth with tomcat !!!


And another, we're serving up  5000 pages per day from our application
(April stats), Tomcat has never crashed, and has run for well over a month
without hitch (restarting Tomcat only necessary when the application gets
updated). RH Linux 6, Tomcat 3.2.1, Apache 1.3.9, Sun JDK 1.2

Kevin

On Wed, 11 Apr 2001, Randy Layman wrote:

 
   I have a success story to the contrary - using Windows NT 4, Tomcat
 3.2.1, and IIS 4 we are serving a decent sized application with no
problems.
 We've been averaging uptimes of about 5 - 6 days before the machine is
 restarted because of other software on the machine.  No detectable
resource
 loss, no crashes.
 



Re: Fed up to the back teeth with tomcat !!!

2001-04-11 Thread Fernando Padilla


Hmm, interesting..

I did have a similar issue with an Oracle driver a while back. Yes, the
Debugging helped alot.  So I was driven to doing a System.gc(); after
and/or before every statement... :)

I think discovered this, assuming that all of that io and String creation
forced a gc... and it seems to work now :):)




On Wed, 11 Apr 2001, Lyle H. Ward wrote:

 Since you are using SQL server, are you using ODBC? There is a bug in ODBC
 that stops the [web] service. It doesn't affect all installations. If this
 is what's happening, there is an awful work-around. Turn on ODBC tracing. It
 prevents the service from halting but creates a monster log file.


 At 08:11 PM 4/11/2001 +0100, you wrote:
 I am fed up to the back teeth with Tomcat under Apache.  I'm trying to run
 a 24/7 web page servinbg around 20,000 .jsp pages a day and I'v ehad
 to reset the damn server 3 times today already.
 
 It keeps falling over
 with absolutly no error  *** log messages at all.  I am at my wits end,
 not
 to mention my poor users who have had to put up with this service for the
 past month.  I am totaly lost now as to where to look for solutions
 
 So can someone please recomend a good webserver that will run .jsp and
 servlets pages and integrates well with a SQL server ?  I used to
 run Java Webserver 2.0 would going back to that help ?
 
 Andy C
 Editor R2 Project
 http://www.r2-dvd.org
 (lets hopr you don't see a 500 internal error message.)