Monday, June 24, 2002 11:45 PM
Well we could do with some more information, because (you guessed it) it all depends!
You say the legacy data is in the DB2 database, so what is the role of SQL Server in this?
Things you should look at:
Model-View-Controller (MVC) architecture with JSP; use JSPs to present your data in the web page, use either Java Beans or EJB's to encapsulate access to the database, and use one or more servlets to handle the requests from the browser and navigation and security issues.
Depending on your requirements you might use Entity EJBs with "Container Managed Persistence" (CMP) which do a lot of the database access work for you, or you might opt for plain old Java Beans using JDBC to get at the data (good JDBC drivers exist for both DB2 and SQL Server).
Depending on your budget and your development environment, you might want to use VisualAge with WebSphere as they both support DB2 very well and provide good tools for building both EJBs and "Data Access Beans". Otherwise you might want to look at jBoss - open source and excellent - which supports CMP EJB.
So, it all depends... except you should probably be looking at an MVC architecture whatever!
Hope that helps,
SCJP, SCJD & SCJA