WebSphere application server 6.1, is a J2EE and web services technology based application server for developing J2EE applications. The WebSphere application server is used to develop JDBC applications. The IBM DB2 9 offers some new features, which are suitable for developing a JDBC 4.0 application. DB2 9 has added support for the SQL XML
data type, which can be used in conjunction with the SQLXML
java data type. It is a new data type in JDBC 4.0 to store and retrieve XML documents. The DB2 database server provides access from WebSphere application server by configuring a JDBC Provider, which is a WebSphere proprietary term in the application server.
In this chapter, we will configure a data source in WebSphere application server 6.1 to connect to DB2 9 database. We will deploy a web application to the WebSphere application server that consists of a JSP to generate an HTML table using the data source configured in the server. We...