Suggestion on technologies that used for JSP to develop a project !

[Anson Ding]

Greetings!
I quite new to JSP development environment. Please help me with my questions.
I'm currently working on a online based Project Manangement's project that utilize the JSP programming to develop. As, default I using Tomcat as web server, Linux OS based server, MySQL database software and more dynamic HTML as front end interface. Now, I concern in the technologies that I used does it works fine for this internal system for client company.
Please advise me about the technologies that I used or any suggestion about it, such as use Ms. SQL server instead of MySQL or run system in Linux is complecated or others.
Any good website for MySQL tutorials and JSP connectivity to MySQL code sample? Thank You!

[Shawn Bayern]

Originally posted by anson:
Greetings!
I quite new to JSP development environment. Please help me with my questions.
I'm currently working on a online based Project Manangement's project that utilize the JSP programming to develop. As, default I using Tomcat as web server, Linux OS based server, MySQL database software and more dynamic HTML as front end interface. Now, I concern in the technologies that I used does it works fine for this internal system for client company.
Please advise me about the technologies that I used or any suggestion about it, such as use Ms. SQL server instead of MySQL or run system in Linux is complecated or others.

This might range a little far afield from core JSP topics, but personally, I think that nearly any environment can be sufficient for JSP applications. You just need to size the hardware appropriately and ensure that the RDBMS (that is, the database system) in particular meets the needs of your client.
I must admit that I'm personally not a big fan of MySQL; its historic support for traditional database concepts has been somewhat poor. Still, it's extremely fast and used by many large sites; in fact, it's loved by many, so it's sometimes hard to buck the trend. I personally use PostgreSQL on all but the largest projects; PostgreSQL is free and has historically had exceptionally good support for transactions, referential integrity, and full ANSI SQL. For very large projects, I'd probably recommend Oracle (but I'd swallow the pill with a few teaspoons of honey).
As for operating system, JSP runs fine on Linux, Windows, Solaris, or any other reasonable system. For what it's worth, I personally prefer Linux for both development and production, but my organization (a large university) tends to use both Linux and Solaris in production.

Any good website for MySQL tutorials and JSP connectivity to MySQL code sample? Thank You!

If you use something like JSTL, then all you really need to do is name the driver, the database's JDBC URL, and optionally a username and password in the appropriate context-initialization parameter (or using a <sql:setDataSource> tag). The JSTL spec describes this in some detail, as does JSTL in Action.