Manuals / IBM / TV and Video / Universal Remote

IBM Version 5 manual RDB and XML integration, 101

Models: Version 5

1 340

Download 340 pages 15.44 Kb

Page 117

6

Chapter 6. RDB and XML integration

Chapter six discusses XML and SQL capabilities within Application Studio. In any application, simple or complex, a database usually acts as the data store. For any application development tool, whether developing the graphical user interface or the business logic components, an easy to use tool graphical tool that works well with a database is a must. Application Studio’s tool and wizards for interacting with the database provide a multitude of capabilities.

The SQL to XML wizards gives the user the capability of generating eXtensible Style Sheet (XSL) and XML files from a SQL statement. In the chapter, a simple schema was created to demonstrate the various file generation capabilities. The files from the different options are hen compared.

The DB2 XML Extender is discussed in 6.4, “DB2 XML Extender” on page 126. A very broad overview is provided with the two methods used for storing XML data in the DB2 database. A comparison is carried between the two methods with recommendations for using each method in a set of conditions.

© Copyright IBM Corp. 2002. All rights reserved.

101

Image 117

IBM Version 5 manual RDB and XML integration, 101

Contents

XML Files Page International Technical Support Organization First Edition December Contents XML Collection Contents Part 4. Appendixes Abbreviations and acronyms Page Copyright License Cics TrademarksTeam that wrote this redbook PrefacePage Comments welcome Become a published authorPage Part Page XML overview Background XML conceptsInformation sharing XML business benefitsXML within an organization XML in new innovations Technical benefits of XMLVoice XML Scalable Vector GraphicsUniformity and conformity Acceptability of use for data transferSimplicity and openness Separation of data and displayXML history ExtensibilityIndustry acceptance XML1.0 Xslt and Web applications Web Tier Web services and XML XML, W3C, and IBM Interaction of Web servicesWorking drafts in development RecommendationsPage Technologies in XML Tree-based parsing XML Processor parserEvent-based parsing DTD and XML SchemaPage Schema and style using CSS, XSLT, and XSL Cascading Style Sheet CSS Example 2-1 a namespace example XML namespacesExample 2-2 a namespace example using namespace prefix Link and jump using XLink, XPointer, and XML Base Example 2-3 a simple link Example 2-4 An extended link XML Base Example 2-5 An example of extended links using xbaseXML Pointer XPointer paths and steps XPointer range functions XPointer string functions Example 2-6 An XPath example XPathBook Library XML digitalTechnologies in XML Examples of XML encryption Example 2-7 Information on passenger John SmithExample 2-8 Encrypted Information on passenger John Smith Example of a XML digital signature Example 2-9 Encrypting only the credit card numberExample 2-10 Encryption of the whole document Transforms Example 2-11 An XML digital signatureExample 2-12 Part encryption of an XML document Example 2-13 The final XML document after encryption XML query language Other security specificationsPath expressions Element constructors Conditional expressions if then Else FLWRFOR, LET, Where and Return clauses expressionFiltering QuantifiersQuerying relational data Example schema for relational database and Xquery comparisonJoins Grouping in XQueryXslt interpreters Xslt compilers XsltcFor more details, visit Using XSLTCThe Apache XML Project at Cocoon Java Architecture for XML Binding JaxbGenerators and reader pipeline inputs Transformers and actions processing stepsSerializer pipeline outputs Matchers and selectors conditional processing SitemapExample 2-14 Sample sitemap for Cocoon Example 2-15 Components of a sitemap XML file Part 2 XML technology in IBM WebSphere Page Processing XML XML applications Xalan model of operation XalanJavax.xml.transforms interfaces operation SAX2Example 3-2 Sample event breakdown Example 3-1 Sample XML documentSAX2 classes and interfaces XML namespace support Example 3-3 SAX2 callback methodsExample 3-4 Sample namespace DOM hierarchy DOM level2Example 3-5 Sample XML document Sample generated DOM tree Jaxp Example 3-6 Sample XML to Html transformation code Using JaxpXslt support packages in Jaxp Stylesheet compilation Introduction to IBM WebSphere Application Developer WebSphere Studio family WebSphere Studio product familyWebSphere Studio Application Developer WebSphere Studio Site Developer AdvancedWebSphere Enterprise Developer WebSphere Studio Application Developer Integration EditionWeb development tools ToolsXML tools Relational database toolsJava development tools Web services development toolsEJB development tools Team collaborationDebugging tools Performance profiling tools Server tools for testing and deploymentPlug-in project Plug-in development toolsFragment project Plug-in componentApplication Developer XML Tools Window-Open Perspective-XML XML perspectiveXML editor XML perspective editorsCreating an XML file from scratch Select the option Create XML file from scratchXML editor Editing an XML fileDTD editor Validating the XML fileCreating a DTD from scratch DTD Editor Using the Outline view to add DTD componentsCreating a schema from scratch XSD editorValidating DTD XML Schema Editor Using the Outline view to add schema componentsMaking changes and referential integrity Pop-up on schema file in the Outline viewNamespace Validating schemaCreating an XSL file from scratch XSL editorNamespace support Editing an XSL fileValidating the XSL file Indicate all local elements to be qualified XPath Builder XPath support10 XPath definition 11 XPath Operators 12 XPath functions 13 XPath Query Result screen XSL debugger14 XSL Debugger Web services support Web Service Dadx group configuration wizardWeb service wizard Application Developer XML Tools Page 101 RDB and XML integrationPassenger List Select statement SQL to XML wizardsSQL to XML wizard panel Show table column as option XML and XSL filesExample 6-1 XSL file for Show table columns as ‘Elements’ Html XML file generated with the Elements option Html file Html with the ‘Recurse through foreign keys’ unchecked Html generated for Foreign key as links option Aircraft Html generated for ‘Foreign key as links’ option XML Schema fileRDB and XML integration 076/schema Sequence Example 6-4 XML Schema for Aircraft table DTD file Page Flight Cdata #REQUIRED Query template fileStatement Options Example 6-9 Customer.xml XML to SQL wizardXML to SQL wizard Selecting the connection 10 XML to SQL wizard Selecting Schema and Action 11 XML to SQL wizard Selecting the column DDL to XML Schema wizardExample 6-10 XML Generated through the DDL to XML Schema 12 Generate XML SchemaRestriction base=string length value=30 SimpleType Element Example 6-11 XML Schema for a single table using a Select DB2 XML Extender 13 shows an overview of the XML Extender XML ExtenderAdministrative support tables, UDTs, and UDFs Administrative support tables createdUDTs created UDFs created Stored Procedures createdDTD Repository Example 6-12 DTD representation of a book Document Access Definitions DADPage XML Column method When to use XML Column methodElements/attributes As is xml documentXML Collection 15 XML Collection Method overview When to use XML Collection methodExample 6-14 Sample DTD Mapping schemes for XML collectionsSQL mapping Column name Data type Employee table in Sample databaseEmpact Table in Sample database Example 6-16 The RDBnode RDBnode for the top elementnodeXML Extender administration tools RDBnode for each attribute and textnodeExample 6-17 RDBnode mapping XML MQSeries enablement RDB and XML integration Page 145 Select passengerList.dtd Right-clickGenerate-XML Schema DTD XSDClick Finish Create an XML file from a DTD file XML DTD/XSDCreate an XML file from an XSD file Select Select file from Workspace option Create DTD/XSD files from XMLSelect passengerList.xsd Right-clickGenerate-XML File Example 7-1 Customer.xmlSelect Customer.xml Right-clickGenerate-XML Schema Select customer.xml Right-clickGenerate-DTDExample 7-2 Customer DTD Generate a Html from an XSD Select passengerList.xsd file Right-clickGenerate-HTML DocExample 7-3 Customer.xsd JavaBeans from DTD/XSD Click File-New-ProjectSelect J2EE Web Application Project. Click Next Select passengerList.xsd Right-clickGenerate-JavaBeans Generate XML/XSL from JavaBeansSelect Generate sample test program. Click Finish Example 7-4 passenger.javaPage Input XML Form screen Click File-New-Java Bean XML ClientClick File-New-Other Generate XML/XSL from HtmlAdding annotation tags Preparing the Html file for generationExample 7-5 cus-template.xhtml Select cus-template.xhtml Right-clickGenerate-XSL File Select Customer.xhtml. Click NextExample 7-6 Customer.xml Page 161 Part 3 XML application developmentPage 163 WebSphere and XML approachesXML in Application development Web services Passenger List application Solution Outline Servlet Web ServicesXML in this application Client Web TierDevelopment and running of the Passenger List application Technical implementation overviewPage Discussion Advantages of using the databaseEnterprise JavaBeans Interprise Application Server Customer Registration application Technical overview Page 177 Developing XML Web servicesServlet Creating the Web tierName Type Create the Airline simple projectDesign the XML Schema Select File-New-XML SchemaCreate the Travel Web project PassengerList DOM Tree Select root nodeCreating XML Schema XML Schema Example 9-1 PassengerList.xsd Design an output Generate XML fileHtml and mapping approach Example 9-2 Static XML fileSelect required and optional content, click Finish Example 9-3 html.dtdExample 9-4 html.xml source XML to Html mapping Generate an XSL fileSource Target Mapping XML to HtmlGenerating XSL from Xhtml Create an XSL from scratchDeveloping the servlet Testing the XSLExample 9-5 GetPassengerList Server doGet method Javax.xml.transform.SourceCompiling XSL Test the passenger list applicationJavax.xml.transform.TranfrormerFactory Javax.xml.transform.Transformer11 XML Web service Creating a Web serviceClick Window-Open Perspective-Data Create the database tierRight-clickNew Connection Right-clickImport to folderPassengerList.xsd-Generate-DTD Figure Generate DTD file13 Generated DTD File Loading DTD into XML ExtenderCreating DAD file using RDB to XML mapping MembershipSelect RDB Table to XML Mapping, click Next 15 Edit Join Conditions Click Mapping-Edit Join Conditions16 RDB to XML mapping Select passengerList.rmxDAD Extension Create the Web Service from Dadx fileDadx Group Web services and DB2 XML ExtenderGroup.properties File Next Generating the Dadx18 Dadx Generation Dadx operationsRetrieveXML Deploying the Web service Example 9-6 Updated Dadx fileStoreXML Example 9-7 namspacetable mapping entry 19 Web Service settings20 Testing Web Service Test the Web ServiceMapping DTDIDs to XSD namespaces and locations Modify passenger list application to use the Web ServiceExample 9-8 Namespaces Modifying the XSL fileExample 9-9 Changing root element Example 9-10 passengerList.xslPage Center Creating Html input form22 Input form GetPassengerList.html Using Java proxy23 passengerList result ConclusionPage 215 Development of XML-based Enterprise applicationsXML based Enterprise application architecture Multi-tier solution architectureCustomer registration Solution outline for customer registration sampleCustomer registration scenario outline Retrieving customer informationRetrieving customer data scenario outline Developing the customer registration sampleJavaBean to XML client wizard Preparing to create the Web tierCreating the Web tier Customer JavaBean class specificationJavaBean XML/XSL client wizard JavaBean XML/XSL client JavaBean selection JavaBean XML/XSL client methods and properties selection JavaBean XML/XSL client input form design 10 JavaBean XML/XSL client results form design Investigating the Web-tier generated files 11 JavaBean XML/XSL client prefix specificationPage Org.w3c.dom.Document ProduceDOM DocumentJava Bean XML DataExample 10-2 Source code for CustomerXSLServlet init method Development of XML-based Enterprise applications ProduceDOMDocument XML DocumentXslt Processor Stylesheet Transformer Example 10-4 Source code for the servlet doPost method Form action=/Registration/CustomerXSLServlet method=post Membership Example 10-10 Sample of CustomerResult stylesheet form Validating the Web tier Example 10-12 Schema file for the XML data15 Customer registration form Building the entity EJB and the database schemaEJB mapping approaches review Project configurationPreparing to create the entity EJB Creating the entity EJB17 Create an Enterprise Bean wizard 18 Enterprise bean details Creating the database mapping and tables19 EJB to RBD Mapping wizard for CustomerInfo module 20 Target database specification 21 EJB to RDB mapping editor 22 Database connection definition Access beansCreating an access bean for the entity bean Creating a Jdbc data source 23 Access Bean creation wizard24 Data source definition for a server configuration 25 Jdbc data source definition Binding the EJB to a Jdbc data sourceModifying CustomerXML Integrating the entity EJB with the Web tierExample 10-13 create source code 27 CustomerInfoWeb project propertiesExample 10-14 CustomerXSLServlet doPost source code Modifying CustomerXSLServletRetrieval function Application deployment and testingExample 10-15 Retrieval function Example 10-16 Confirming the creation28 Generating the deployed code for the EJB Testing the registration application29 Customer Registration form Page 257 Light weight XML-based Enterprise ApplicationSQL to/from XML libraries SQL-XML solution architectureCustomer registration Light weight XML-based Enterprise ApplicationRetrieving customer information XSL Servlet XML Document format Adding the libraries to the projectConverting an XML Document XMLToSQL architectureModifying CustomerXSLServlet Initializing the XMLToSQL classXMLToSQL Creating an XML Document Modifying the produceDOMDocument methodExample 11-1 initSQLProperties method Example 11-2 ProduceDOMDocumentforTools We need to change toExample 11-3 CustomerXSLServlet doRegister method Executing the XMLToSQL classModifying the doPost method Example 11-4 CustomerXSLServlet doPost methodExample 11-5 The xslif tag Example 11-6 Customer.XSL firstname template Adding the error caseJdbcDriver Retrieving a customerStatement FormatInitializing the SQLToXML class SQLToXMLExample 11-7 initQueryProperties method Example 11-8 CustomerXSLServlet doQuery method Executing the SQLToXML classModifying the showPage method Example 11-9 CustomerXSLServlet doPost method for queryExample 11-10 showPage method Modifying the doGet method Example 11-11 showPage methodExample 11-12 Customer.XSL membership template Example 11-13 Result XSL Page Customer Registration form Using datasource with SQLToXML and XMLToSQL classGetting the datasource Class definitionConstructors Example 11-14 setDatasourceMethodsExample 11-15 setDatasourceMethods Execute methods 11 Core data is an XML ConclusionPage 283 Deploying your Web applicationExporting your project from Application Developer Manual deploymentStarting the WebSphere AEs Admin Console Installing the EAR file on WebSphere AEsSelect Enterprise Applications Installing the EARTesting the application Creating a remote server instance Publishing to a remote server AEsCreating a remote server instance WebSphere Studio Application Developer Programming Guide Remote server instance settings Remote file transfer option Remote copy options WebSphere Studio Application Developer Programming Guide Publishing to remote server WebSphere Studio Application Developer Programming Guide 297 Part 4 AppendixesPage 299 Installing Application Developer Things to do before installationWebSphere Studio Application Developer installation Select options Selecting your workspacePrograms-IBM WebSphere Studio Application Developer-IBM Verifying the installationWebSphere Studio Application Developer Programming Guide 305 Create groups and users Hardware and software prerequisitesInstall WebSphere Application Server Check that IP ports are unusedStop the Web server processes 10 Installation options 11 Security options 12 Snoop servlet accessed through embedded Web server Using the Web material Locating the Web material311 System requirements for downloading the Web material How to use the Web material313 Abbreviations and acronymsOTS Referenced Web sites IBM RedbooksOther resources 315IBM Redbooks collections How to get IBM Redbooks317 IndexJaxp Wsaa Xacml Xsltc 48 Spine 475-0.875 250 459 pages Page Page XML Files