IBM Version 5 manual SQL to/from XML libraries, SQL-XML solution architecture

11.1 SQL to/from XML libraries

In this chapter, we replace the EJB part which is described in previous chapter with SQL to/from XML libraries. These libraries are exactly same as used in XML from SQL query and XML, to SQL wizard. You can use the XML from SQL wizard to unit test your query to make sure it produces the expected result (see 6.1, “The SQL to XML wizards” on page 102). And you should use the XML to SQL wizard to unit test the XML document to make sure it updates the right data.

This simple architecture (illustrated in Figure 11-1) can keep the application simple. The application server layer has been removed from J2EE architecture and SQL <-> XML libraries will handle the database directory from Web tier inside.

Client Web Tier

HTML/JSP

Servlet

Validation Logic

Request Handler

SQL <-> XML

XSLT Processor

XML

Presentation

Data

XSLT

Data

Presentation Logic Data Server

Figure 11-1 SQL<->XML solution architecture

In order to understand how these components interact with each other, have a deep look at 11.2, “Solution outline for customer registration sample” on page 259.

258 The XML Files: Development of XML/XSL Applications Using WebSphere Studio