Hi Mike,
Welcome to the Ranch!
The rationale for selecting a server-side technology often has a lot to do with the existing skill set of the development team (in this case you
). I would say that JSP and
Tomcat is a good choice given your Java background. The only downside for your client is that the cost of good Java web hosting is much higher than for simpler technologies (at least in the UK anyway!)
I'm not so sure about the choice of MySQL for the database, however. What alternatives have you considered? The last I heard MySQL didn't support transactions or stored procedures. I did hear it now supports sub-queries (finally) in version 4.1. I don't know which DB to recommend to you - it might depend on the hosting arrangement, but bear those things in mind.
Hope this helps.
Jules
[ August 13, 2004: Message edited by: Julian Kennedy ]