You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by David Crooke <da...@convio.com> on 2001/04/07 18:57:42 UTC
Re: Tomcat3.2+Redhat 7.0+glibc-2.x.x+jdk1.x == stable??
The glibc that RH7 shipped with was beta and very broken - you need to apply their patch set. Red Hat rushed their 7.0 release, breaking their
convention (major version = new Linux kernel) and a lot of stuff besides. Most of the new stuff in it is GUI related, and as such you may be
better sticking with 6.2 for server use.
Depending on what your code does, you may get better performance from a green threads VM - with 1.3 these are starting to go away; you can still
get green threads with the Sun JDK using --classic but I believe it hobbles HotSpot. We still run 1.2.2 in production and are evaluating the 1.3
VM's for stability.
Like most open source projects, Apache stuff comes from a Unix heritage, and while you can shoehorn it onto Windows, you will have a much easier
life if you stick with Linux. Just check this newsgroup - 90% of the traffic is "I can't get x, y or z to work on NT"
Chris Price wrote:
> Hi;
>
> I know its kind of an open ended question, but I would like some input
> (factual or anecdotal) on other peoples success in running various
> combinations of glibc + jdk + kernel (does kernel mattrer much?).
>
> I am currently running the Sun JDK 1.3.0 with glibc-2.1.92 and kernel
> 2.2.16-22 on a *very* stock RH 7.0. This combination is proving itself
> to be quite unstable, with the Tomcat http listener and/or servlet
> engine dying under moderate loads (less than 4,000 hits roughly over 8
> hours).
>
> The glibc + kernel are stock RH7.0 pieces, and while I am sure I can
> probably gain some stability by upgrading to newer ones, I would like to
> know if there is a "optimal" (used loosely) combination that exists.
>
> I am inheriting this setup from an Admin that thought that Linux
> 'sucked' and that we should move to NT. The previous admin didn't know
> how to use rpm, compile a kernel, or have a clue as to what glibc is.
> Needless to say, I can probably add some value and squeeze some better
> performance from our Tomcat app servers.
>
> Cheers
>
> Chris Price
RE: database access problem
Posted by Danny Angus <da...@thought.co.uk>.
I dont think its the SQL statement thats causing your grief.
RE: database access problem
Posted by Adam Fowler <af...@cc.edu>.
MS SQL Server 7.0 and above definitely do support the AS keyword, not sure
about oracle.
E.g.:-
SELECT MAX(cutomerID) AS MaxID FROM tblCustomer
Regards,
Adam.
Colorado here I come...
----
Adam Fowler
Second year Computer Science undergraduate
University of Wales, Aberystwyth
Carroll College, WI, USA(2000-2001)
web: http://gucciboy.dyndns.org/aff9
e-mail: adamfowler@chillin.co.uk
"Every new beginning comes from some other beginning's end"
----
-----Original Message-----
From: Marc Battistello [mailto:mbattistello@home.com]
Sent: Sunday, April 08, 2001 7:22 PM
To: tomcat-user@jakarta.apache.org
Subject: Re: database access problem
Asim, I dont think Oracle or SQL Server support the "AS" keyword for
renaming column names. I think its specific to MS Access. I did a quick
search and found the below link but Im no expert on sql syntax. That would
be the first place Id look to check sql syntax. You can also try running the
insert statement outside your application to make sure that its not causing
the problem.
http://w3.one.net/~jhoffman/sqltut.htm#Adding_Data
----- Original Message -----
From: "Asim Ghaffar" <u9...@giki.edu.pk>
To: <to...@jakarta.apache.org>
Sent: Sunday, April 08, 2001 10:49 AM
Subject: database access problem
> Hello Friends!
> I am in real difficult situation so i need some quick advice. I am making
a
> search engine. I did all my testing on MS Acess. So far so good. But now
> when i switched to Oracle and SQL Server i am getting a very odd problem
> (same in oravle and SQL).
> here is my code.
>
> 1 try {
> 2 ResultSet results = g.executeQuery(); //
> 3 while (results.next()) {
> 4 String u = results.getString("u");
> 5 String t = results.getString("T");
> 6 String s = (new Integer(results.getInt("S"))).toString();
> 7 String k = results.getString("K"); // Exception is
> thrown here at this line
> 8 String a = results.getString("P");
> 9 String d = results.getString("D");
> 10 String m = (new Integer(results.getInt("I"))).toString();
> 11 String l = results.getString("L");
> 12 String o = (new Integer(results.getInt("O"))).toString();
> 13 String st = results.getTimestamp("St").toString();
> 14 }
> 15 }catch (SQLException sqle){
> sqle.printStackTrace();
> }
>
> where g = connection.prepareStatement("INSERT INTO HITLIST SELECT
SITES.*,1
> AS SCORE FROM SITES WHERE SITES.PAGETEXT LIKE '%pakistan%'");
>
>
> Now on line # 7 i am getting the exception
> in SQL Server it is [Microsoft][ODBC SQL Server Driver]Invalid Descriptor
> Index
> in Oracle it is some jdbc exeption about invalid column number
>
> Now if i switch the wors with each other error again come on same line
> number not statement.
> I debugged using jbuilder and in the middle of execution all
> resultset.getDataType("columnName") become inavlid even those which are on
> lines above. So badically whole result set gets corrupted.
> Same code is running fine in MS Access. Any clue what can be the reason
for
> this. Where else i can get help from.
> thanking you in advance. I u have any clue do email me.
> bye
>
>
Re: database access problem
Posted by Marc Battistello <mb...@home.com>.
Asim, I dont think Oracle or SQL Server support the "AS" keyword for
renaming column names. I think its specific to MS Access. I did a quick
search and found the below link but Im no expert on sql syntax. That would
be the first place Id look to check sql syntax. You can also try running the
insert statement outside your application to make sure that its not causing
the problem.
http://w3.one.net/~jhoffman/sqltut.htm#Adding_Data
----- Original Message -----
From: "Asim Ghaffar" <u9...@giki.edu.pk>
To: <to...@jakarta.apache.org>
Sent: Sunday, April 08, 2001 10:49 AM
Subject: database access problem
> Hello Friends!
> I am in real difficult situation so i need some quick advice. I am making
a
> search engine. I did all my testing on MS Acess. So far so good. But now
> when i switched to Oracle and SQL Server i am getting a very odd problem
> (same in oravle and SQL).
> here is my code.
>
> 1 try {
> 2 ResultSet results = g.executeQuery(); //
> 3 while (results.next()) {
> 4 String u = results.getString("u");
> 5 String t = results.getString("T");
> 6 String s = (new Integer(results.getInt("S"))).toString();
> 7 String k = results.getString("K"); // Exception is
> thrown here at this line
> 8 String a = results.getString("P");
> 9 String d = results.getString("D");
> 10 String m = (new Integer(results.getInt("I"))).toString();
> 11 String l = results.getString("L");
> 12 String o = (new Integer(results.getInt("O"))).toString();
> 13 String st = results.getTimestamp("St").toString();
> 14 }
> 15 }catch (SQLException sqle){
> sqle.printStackTrace();
> }
>
> where g = connection.prepareStatement("INSERT INTO HITLIST SELECT
SITES.*,1
> AS SCORE FROM SITES WHERE SITES.PAGETEXT LIKE '%pakistan%'");
>
>
> Now on line # 7 i am getting the exception
> in SQL Server it is [Microsoft][ODBC SQL Server Driver]Invalid Descriptor
> Index
> in Oracle it is some jdbc exeption about invalid column number
>
> Now if i switch the wors with each other error again come on same line
> number not statement.
> I debugged using jbuilder and in the middle of execution all
> resultset.getDataType("columnName") become inavlid even those which are on
> lines above. So badically whole result set gets corrupted.
> Same code is running fine in MS Access. Any clue what can be the reason
for
> this. Where else i can get help from.
> thanking you in advance. I u have any clue do email me.
> bye
>
>
database access problem
Posted by Asim Ghaffar <u9...@giki.edu.pk>.
Hello Friends!
I am in real difficult situation so i need some quick advice. I am making a
search engine. I did all my testing on MS Acess. So far so good. But now
when i switched to Oracle and SQL Server i am getting a very odd problem
(same in oravle and SQL).
here is my code.
1 try {
2 ResultSet results = g.executeQuery(); //
3 while (results.next()) {
4 String u = results.getString("u");
5 String t = results.getString("T");
6 String s = (new Integer(results.getInt("S"))).toString();
7 String k = results.getString("K"); // Exception is
thrown here at this line
8 String a = results.getString("P");
9 String d = results.getString("D");
10 String m = (new Integer(results.getInt("I"))).toString();
11 String l = results.getString("L");
12 String o = (new Integer(results.getInt("O"))).toString();
13 String st = results.getTimestamp("St").toString();
14 }
15 }catch (SQLException sqle){
sqle.printStackTrace();
}
where g = connection.prepareStatement("INSERT INTO HITLIST SELECT SITES.*,1
AS SCORE FROM SITES WHERE SITES.PAGETEXT LIKE '%pakistan%'");
Now on line # 7 i am getting the exception
in SQL Server it is [Microsoft][ODBC SQL Server Driver]Invalid Descriptor
Index
in Oracle it is some jdbc exeption about invalid column number
Now if i switch the wors with each other error again come on same line
number not statement.
I debugged using jbuilder and in the middle of execution all
resultset.getDataType("columnName") become inavlid even those which are on
lines above. So badically whole result set gets corrupted.
Same code is running fine in MS Access. Any clue what can be the reason for
this. Where else i can get help from.
thanking you in advance. I u have any clue do email me.
bye
Re: Tomcat3.2+Redhat 7.0+glibc-2.x.x+jdk1.x == stable??
Posted by Steve Ruby <st...@rubysolutions.com>.
I've had no problem with IBM JDK 1.3.0 on redhat 6.1 with glibc 2.1.3
kernel 2.2.12 I posted some tests a while back with multi threaded
(multi machine) load testing, I had some problems with tomcat 4
at the time but I 3.2 was fine.
I'm currently setting up a redhat 7 machine glibc 2.2 IBM 1.3.0 I
haven't run much load testing on it so far, have you tried the
newler glibc on your redhat 7 machine?
Bill Graham wrote:
>
> I've been doing a lot of similar tests in search of the best jdk to
> work with linux and tomcat and have been seeing the same lack of
> stability as Chris. I was running the IBM JDK 1.3.0 bld cx130-20010207
> with glibc-2.1.3-15 and kernel 2.2.16-21.7.1 running with both SMP
> and UP. The VM would just hang after a few minutes of heavy load.
>
> It seemed similar to this bug mentioned in the IBM.Tomcat.Linux group
> list (although their bug was seen with jvmpi):
> http://groups.google.com/groups?hl=en&lr=&group=ibm.software.java.linux&safe
> =off&ic=1&th=443066d336bfa758&seekd=909050309#909050309
>
> Sun's VM wasn't any better:
> This hanging thread bug reported against Sun's 1.2.2 VM is still open and
> looks like the same thing that I've seeing with the 1.3.0 VM:
> http://developer.java.sun.com/developer/bugParade/bugs/4306523.html
>
> I tried running the Sun's VM in in classic mode (green threads) and was
> easily able to reproduce their SEGV bug:
> http://developer.java.sun.com/developer/bugParade/bugs/4372197.html
>
> We've searched extensively for a good vm for linux and haven't found one
> that can pass the test. (Our Solaris machines pass with flying colors,
> albeit a bit slower.)
>
> I've heard some people on this list say that they've had success with
> linux, but none that have done any multithreaded load testing. If anyone
> does have a winning combination, please pipe in!
>
> bill
>
> -----Original Message-----
> From: dave@dcc.vu [mailto:dave@dcc.vu]On Behalf Of David Crooke
> Sent: Saturday, April 07, 2001 9:58 AM
> To: tomcat-user@jakarta.apache.org
> Subject: Re: Tomcat3.2+Redhat 7.0+glibc-2.x.x+jdk1.x == stable??
>
> The glibc that RH7 shipped with was beta and very broken - you need to apply
> their patch set. Red Hat rushed their 7.0 release, breaking their
> convention (major version = new Linux kernel) and a lot of stuff besides.
> Most of the new stuff in it is GUI related, and as such you may be
> better sticking with 6.2 for server use.
>
> Depending on what your code does, you may get better performance from a
> green threads VM - with 1.3 these are starting to go away; you can still
> get green threads with the Sun JDK using --classic but I believe it hobbles
> HotSpot. We still run 1.2.2 in production and are evaluating the 1.3
> VM's for stability.
>
> Like most open source projects, Apache stuff comes from a Unix heritage, and
> while you can shoehorn it onto Windows, you will have a much easier
> life if you stick with Linux. Just check this newsgroup - 90% of the traffic
> is "I can't get x, y or z to work on NT"
>
> Chris Price wrote:
>
> > Hi;
> >
> > I know its kind of an open ended question, but I would like some
> input
> > (factual or anecdotal) on other peoples success in running various
> > combinations of glibc + jdk + kernel (does kernel mattrer much?).
> >
> > I am currently running the Sun JDK 1.3.0 with glibc-2.1.92 and
> kernel
> > 2.2.16-22 on a *very* stock RH 7.0. This combination is proving itself
> > to be quite unstable, with the Tomcat http listener and/or servlet
> > engine dying under moderate loads (less than 4,000 hits roughly over 8
> > hours).
> >
> > The glibc + kernel are stock RH7.0 pieces, and while I am sure I
> can
> > probably gain some stability by upgrading to newer ones, I would like to
> > know if there is a "optimal" (used loosely) combination that exists.
> >
> > I am inheriting this setup from an Admin that thought that Linux
> > 'sucked' and that we should move to NT. The previous admin didn't know
> > how to use rpm, compile a kernel, or have a clue as to what glibc is.
> > Needless to say, I can probably add some value and squeeze some better
> > performance from our Tomcat app servers.
> >
> > Cheers
> >
> > Chris Price
RE: Tomcat3.2+Redhat 7.0+glibc-2.x.x+jdk1.x == stable??
Posted by Bill Graham <bi...@spotlife.com>.
I've been doing a lot of similar tests in search of the best jdk to
work with linux and tomcat and have been seeing the same lack of
stability as Chris. I was running the IBM JDK 1.3.0 bld cx130-20010207
with glibc-2.1.3-15 and kernel 2.2.16-21.7.1 running with both SMP
and UP. The VM would just hang after a few minutes of heavy load.
It seemed similar to this bug mentioned in the IBM.Tomcat.Linux group
list (although their bug was seen with jvmpi):
http://groups.google.com/groups?hl=en&lr=&group=ibm.software.java.linux&safe
=off&ic=1&th=443066d336bfa758&seekd=909050309#909050309
Sun's VM wasn't any better:
This hanging thread bug reported against Sun's 1.2.2 VM is still open and
looks like the same thing that I've seeing with the 1.3.0 VM:
http://developer.java.sun.com/developer/bugParade/bugs/4306523.html
I tried running the Sun's VM in in classic mode (green threads) and was
easily able to reproduce their SEGV bug:
http://developer.java.sun.com/developer/bugParade/bugs/4372197.html
We've searched extensively for a good vm for linux and haven't found one
that can pass the test. (Our Solaris machines pass with flying colors,
albeit a bit slower.)
I've heard some people on this list say that they've had success with
linux, but none that have done any multithreaded load testing. If anyone
does have a winning combination, please pipe in!
bill
-----Original Message-----
From: dave@dcc.vu [mailto:dave@dcc.vu]On Behalf Of David Crooke
Sent: Saturday, April 07, 2001 9:58 AM
To: tomcat-user@jakarta.apache.org
Subject: Re: Tomcat3.2+Redhat 7.0+glibc-2.x.x+jdk1.x == stable??
The glibc that RH7 shipped with was beta and very broken - you need to apply
their patch set. Red Hat rushed their 7.0 release, breaking their
convention (major version = new Linux kernel) and a lot of stuff besides.
Most of the new stuff in it is GUI related, and as such you may be
better sticking with 6.2 for server use.
Depending on what your code does, you may get better performance from a
green threads VM - with 1.3 these are starting to go away; you can still
get green threads with the Sun JDK using --classic but I believe it hobbles
HotSpot. We still run 1.2.2 in production and are evaluating the 1.3
VM's for stability.
Like most open source projects, Apache stuff comes from a Unix heritage, and
while you can shoehorn it onto Windows, you will have a much easier
life if you stick with Linux. Just check this newsgroup - 90% of the traffic
is "I can't get x, y or z to work on NT"
Chris Price wrote:
> Hi;
>
> I know its kind of an open ended question, but I would like some
input
> (factual or anecdotal) on other peoples success in running various
> combinations of glibc + jdk + kernel (does kernel mattrer much?).
>
> I am currently running the Sun JDK 1.3.0 with glibc-2.1.92 and
kernel
> 2.2.16-22 on a *very* stock RH 7.0. This combination is proving itself
> to be quite unstable, with the Tomcat http listener and/or servlet
> engine dying under moderate loads (less than 4,000 hits roughly over 8
> hours).
>
> The glibc + kernel are stock RH7.0 pieces, and while I am sure I
can
> probably gain some stability by upgrading to newer ones, I would like to
> know if there is a "optimal" (used loosely) combination that exists.
>
> I am inheriting this setup from an Admin that thought that Linux
> 'sucked' and that we should move to NT. The previous admin didn't know
> how to use rpm, compile a kernel, or have a clue as to what glibc is.
> Needless to say, I can probably add some value and squeeze some better
> performance from our Tomcat app servers.
>
> Cheers
>
> Chris Price