Web enabling of a legacy mainframe data existing on DB2
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Anonymous
Posted On:   Monday, June 24, 2002 10:35 PM


How do you web enable a legacy data existing on DB2. The data will constantly flow from DB2 to SQL Server and to a web page on to a browser and goes back to DB2 via SQL Server. Kindly let me know what is the technology used and what is the architecture of the system going to be.

I appreciate your immediate resp. on this.

Thanks and regards
Khaja HUssain.M

Re: Web enabling of a legacy mainframe data existing on DB2

Posted By:   Dave_Pellatt  
Posted On:   Monday, June 24, 2002 11:45 PM

Hi Khaja,


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,


Dave Pellatt

SCJP, SCJD & SCJA

About | Sitemap | Contact