Which app server/db solution for light enteprise project ?

Hi all,

I plan to develop a small archiving application (for video tapes/rushes) using Java Enterprise technology.

As part of my job, I've been working for a while on JOnAS/Tomcat and WebLogic, and also had glimpses of WebSphere and the SAP NetWeaver J2EE engine. We've had Oracle and Ingres databases running, as well.

Now, these solutions seem a bit overweight regarding what I plan to do, so I wonder if you people could advise me to use smaller solutions.

For instance, I had a look at the Java Application Server while using as part of AVK-based certification, and it looked very small and easy - and it's Sun's... Yet I don't know it in details, and it's the same for JBoss or Apache/Tomcat combinations. Regarding the DBs, even using the freeversion of Oracle DB seemed a bit too much, but on the other hand, DBs such like MySQL seem a bit too light...

For the record, the solution should be running on a high-end desktop PC in a small LAN (<10 users).

Any feedback appreciated!

PS: I've been using Eclipse for ages, but I wonder: how's NetBeans?

[1113 byte] By [olivier.giesa] at [2007-11-26 16:20:30]
# 1

MySQL imho is much more stable and faster than Oracle, SQL Server, Sybex and DB2. It's free and has a lot of standard features in the free version, such as triggers, views, stored procs. I use it in all of my personal stuff and it runs fine, plus I deployed at a few clients with 20-45 transactions per second with no problems. Plus there are thousands of LAMP/R application that use MySQL and get hit tens of thousands of times an hour. If you don't want to mess with it, you can use PostGres which is also free and if you feel like getting crazy you can use a OO DB like DB4O which is actually very stable and much quicker than a RDBMS/Driver scenario (or so they claim)....

As for Application Servers, I am partial to JBoss, it's free it's super stable and it has most of the same bells and whistles WebSphere/WebLogic. Plus it's a full application server, not a servlet container like, Orion, Tomcat, Resin... Plus I have used Tomcat at a couple of clients as a production Server and I find it a little flaky, especially when it comes to Server ConnectionPooling.

there you go my .02

rutherford218a at 2007-7-8 22:44:06 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2
I would use PostgreSQL as the DBMS. I agree with the previous poster on JBoss, it is a fine product.
gimbal2a at 2007-7-8 22:44:06 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...