Filter
Top Products
258 The XML Files: Development of XML/XSL Applications Using WebSphere Studio
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.
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.
Presentation
Data
Data Server
Client
Web Tier
Servlet Request Handler
SQL <-> XML
HTML/JSP
XMLXSLT Processor
XSLT
Data
Data
Presentation Logic
Validation Logic