Tomcat is a very popular server. I would say that 30 to 40 percent of the sites I consult with uses it as their production server.
Many applications don't need a full application server such as Weblogic, Websphere, JBoss, etc. In many cases, they are just web based applications, using servlets and JSPs (or a framework that sits on top of it). And Tomcat works very well.
As for Oracle 10g, that's a database -- and not really an application server.
Hi Henry, sorry perhaps there was a mis-understanding, Oracle 10 suite includes the application server OC4J - what I was referring to if anyone as played around with both and what their thoughts of Tomcat over Oracle?
Because of freeware and consume low resources many applications are deployed in Tomcat. Now a days, Tomcat is coming with good solutions and overcome the earlier defects. For the early versions of Tomcat there were some memory issues, but those are resolved in the recent versions.
Coming to Oracle 10g, no database is comparable with 10g. It gives security and flexibility. Hence, most of the clients are opting for the Oracle 10g than other RDBMS softwares.
(SCJP5.0, IBM Rational Solution Designer, IBM Rational Architect, IBM RUP Designer)