Manuals / IBM / TV and Video / Universal Remote

IBM Version 5 manual DTD Repository

Models: Version 5

1 340

Download 340 pages 15.44 Kb

Page 146

Stored Procedure	Description

dxxGenXML()	uses a DAD file for an XML collection to compose XML
	documents

dxx.RetrieveXML	uses an XML enabled collection to compose XML
	documents

dxxShredXML()	uses a DAD file for an XML collection to decompose XML
	documents

dxxInsertXML()	uses an XMLenabled collection to decompose XML
	documents

DTD Repository

The DTD Repository is a table created by the XML Extender when a database is enabled for XML. The table name is DTD_REF. Each row of this table represents a DTD with additional metadata information. Users can access this table to insert their own DTDs. The DTDs in this table are used when the validation of an XML document is requested.

The DTD_REF table has the following columns:

DTDID: This column specifies the location of the DTD file that you will insert into the DTD_REF table. For example, our DTD file ’redbook.DTD’ is located in the directory x:\redbooks\SG246586\code\redbook.dtd, where x is the local hard-disk drive letter.

CONTENT: This column contains the actual DTD file content. To insert data into the XML enabled column of a table, (depending on the data type you chose for the table column to store the XML data) the insert parameter will be:

db2xml.XMLClobFromFile(’x:\redbooks\SG246586\code\redbook.dtd’)

Here db2xml is the schema qualifier for the function XMLClobFromFile. The full path to the dtd file, required by the function, is specified in parenthesis. We assumed that if you chose XMLCLOB data type for the table column in which you will store the XML data.

USAGE_COUNT: this column indicates the number of XML documents for which this DTD is being used.

The column names AUTHOR, CREATOR, UPDATOR are self-explanatory.

The DTD_REF table is an administrative support table created by XML Extender for its own use. The other administrative support table is the XML_USAGE table. This table maintains the Document Access Definition (DAD) files. We will now describe what a DAD file is and how it is used.

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

Image 146

IBM Version 5 manual DTD Repository

Contents

XML Files Page International Technical Support Organization First Edition December Contents XML Collection Contents Part 4. Appendixes Abbreviations and acronyms Page Copyright License Trademarks CicsPreface Team that wrote this redbookPage Become a published author Comments welcomePage Part Page XML overview XML concepts BackgroundXML business benefits Information sharingXML within an organization Voice XML Technical benefits of XMLXML in new innovations Scalable Vector GraphicsSimplicity and openness Acceptability of use for data transferUniformity and conformity Separation of data and displayIndustry acceptance XML historyExtensibility XML1.0 Xslt and Web applications Web Tier Web services and XML Interaction of Web services XML, W3C, and IBMRecommendations Working drafts in developmentPage Technologies in XML XML Processor parser Tree-based parsingDTD and XML Schema Event-based parsingPage Schema and style using CSS, XSLT, and XSL Cascading Style Sheet CSS XML namespaces Example 2-1 a namespace exampleExample 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 Example 2-5 An example of extended links using xbase XML BaseXML Pointer XPointer paths and steps XPointer range functions XPointer string functions XPath Example 2-6 An XPath exampleXML digital Book LibraryTechnologies in XML Example 2-8 Encrypted Information on passenger John Smith Examples of XML encryptionExample 2-7 Information on passenger John Smith Example 2-10 Encryption of the whole document Example of a XML digital signatureExample 2-9 Encrypting only the credit card number Example 2-12 Part encryption of an XML document TransformsExample 2-11 An XML digital signature Example 2-13 The final XML document after encryption Other security specifications XML query languagePath expressions Element constructors FLWRFOR, LET, Where and Return clauses expression Conditional expressions if then ElseQuantifiers FilteringExample schema for relational database and Xquery comparison Querying relational dataGrouping in XQuery JoinsXslt compilers Xsltc Xslt interpretersFor more details, visit Using XSLTCThe Apache XML Project at Java Architecture for XML Binding Jaxb CocoonSerializer pipeline outputs Generators and reader pipeline inputsTransformers and actions processing steps Example 2-14 Sample sitemap for Cocoon Matchers and selectors conditional processingSitemap Example 2-15 Components of a sitemap XML file Part 2 XML technology in IBM WebSphere Page Processing XML XML applications Xalan Xalan model of operationSAX2 Javax.xml.transforms interfaces operationExample 3-1 Sample XML document Example 3-2 Sample event breakdownSAX2 classes and interfaces Example 3-4 Sample namespace XML namespace supportExample 3-3 SAX2 callback methods DOM level2 DOM hierarchyExample 3-5 Sample XML document Sample generated DOM tree Jaxp Using Jaxp Example 3-6 Sample XML to Html transformation codeXslt support packages in Jaxp Stylesheet compilation Introduction to IBM WebSphere Application Developer WebSphere Studio product family WebSphere Studio familyWebSphere Studio Site Developer Advanced WebSphere Studio Application DeveloperWebSphere Studio Application Developer Integration Edition WebSphere Enterprise DeveloperTools Web development toolsRelational database tools XML toolsWeb services development tools Java development toolsDebugging tools EJB development toolsTeam collaboration Server tools for testing and deployment Performance profiling toolsFragment project Plug-in development toolsPlug-in project Plug-in componentApplication Developer XML Tools XML perspective Window-Open Perspective-XMLCreating an XML file from scratch XML perspective editorsXML editor Select the option Create XML file from scratchEditing an XML file XML editorCreating a DTD from scratch DTD editorValidating the XML file Using the Outline view to add DTD components DTD EditorValidating DTD Creating a schema from scratchXSD editor Using the Outline view to add schema components XML Schema EditorPop-up on schema file in the Outline view Making changes and referential integrityValidating schema NamespaceXSL editor Creating an XSL file from scratchValidating the XSL file Namespace supportEditing an XSL file Indicate all local elements to be qualified XPath support XPath Builder10 XPath definition 11 XPath Operators 12 XPath functions XSL debugger 13 XPath Query Result screen14 XSL Debugger Web service wizard Web services supportWeb Service Dadx group configuration wizard Application Developer XML Tools Page RDB and XML integration 101SQL to XML wizards Passenger List Select statementSQL to XML wizard panel Example 6-1 XSL file for Show table columns as ‘Elements’ Show table column as optionXML and XSL files 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 XML Schema file Aircraft Html generated for ‘Foreign key as links’ optionRDB and XML integration 076/schema Sequence Example 6-4 XML Schema for Aircraft table DTD file Page Query template file Flight Cdata #REQUIREDStatement Options XML to SQL wizard Example 6-9 Customer.xmlXML to SQL wizard Selecting the connection 10 XML to SQL wizard Selecting Schema and Action DDL to XML Schema wizard 11 XML to SQL wizard Selecting the column12 Generate XML Schema Example 6-10 XML Generated through the DDL to XML SchemaRestriction base=string length value=30 SimpleType Element Example 6-11 XML Schema for a single table using a Select DB2 XML Extender XML Extender 13 shows an overview of the XML ExtenderUDTs created Administrative support tables, UDTs, and UDFsAdministrative support tables created Stored Procedures created UDFs createdDTD Repository Document Access Definitions DAD Example 6-12 DTD representation of a bookPage When to use XML Column method XML Column methodXML Collection Elements/attributesAs is xml document When to use XML Collection method 15 XML Collection Method overviewMapping schemes for XML collections Example 6-14 Sample DTDSQL mapping Employee table in Sample database Column name Data typeEmpact Table in Sample database RDBnode for the top elementnode Example 6-16 The RDBnodeExample 6-17 RDBnode mapping XML Extender administration toolsRDBnode for each attribute and textnode XML MQSeries enablement RDB and XML integration Page 145 Click Finish Select passengerList.dtd Right-clickGenerate-XML SchemaDTD XSD XML DTD/XSD Create an XML file from a DTD fileCreate an XML file from an XSD file Select passengerList.xsd Right-clickGenerate-XML File Create DTD/XSD files from XMLSelect Select file from Workspace option Example 7-1 Customer.xmlExample 7-2 Customer DTD Select Customer.xml Right-clickGenerate-XML SchemaSelect customer.xml Right-clickGenerate-DTD Example 7-3 Customer.xsd Generate a Html from an XSDSelect passengerList.xsd file Right-clickGenerate-HTML Doc Select J2EE Web Application Project. Click Next JavaBeans from DTD/XSDClick File-New-Project Select Generate sample test program. Click Finish Generate XML/XSL from JavaBeansSelect passengerList.xsd Right-clickGenerate-JavaBeans Example 7-4 passenger.javaPage Click File-New-Java Bean XML Client Input XML Form screenGenerate XML/XSL from Html Click File-New-OtherPreparing the Html file for generation Adding annotation tagsExample 7-5 cus-template.xhtml Example 7-6 Customer.xml Select cus-template.xhtml Right-clickGenerate-XSL FileSelect Customer.xhtml. Click Next Page Part 3 XML application development 161Page WebSphere and XML approaches 163XML in Application development Web services Passenger List application Solution Outline XML in this application Web ServicesServlet Client Web TierTechnical implementation overview Development and running of the Passenger List applicationPage Advantages of using the database DiscussionEnterprise JavaBeans Interprise Application Server Customer Registration application Technical overview Page Developing XML Web services 177Creating the Web tier ServletCreate the Airline simple project Name TypeCreate the Travel Web project Design the XML SchemaSelect File-New-XML Schema Select root node PassengerList DOM TreeCreating XML Schema XML Schema Example 9-1 PassengerList.xsd Html and mapping approach Generate XML fileDesign an output Example 9-2 Static XML fileExample 9-4 html.xml source Select required and optional content, click FinishExample 9-3 html.dtd Generate an XSL file XML to Html mappingMapping XML to Html Source TargetCreate an XSL from scratch Generating XSL from XhtmlTesting the XSL Developing the servletJavax.xml.transform.Source Example 9-5 GetPassengerList Server doGet methodJavax.xml.transform.TranfrormerFactory Test the passenger list applicationCompiling XSL Javax.xml.transform.TransformerCreating a Web service 11 XML Web serviceRight-clickNew Connection Create the database tierClick Window-Open Perspective-Data Right-clickImport to folderGenerate DTD file PassengerList.xsd-Generate-DTD FigureLoading DTD into XML Extender 13 Generated DTD FileSelect RDB Table to XML Mapping, click Next Creating DAD file using RDB to XML mappingMembership Click Mapping-Edit Join Conditions 15 Edit Join ConditionsSelect passengerList.rmx 16 RDB to XML mappingCreate the Web Service from Dadx file DAD ExtensionWeb services and DB2 XML Extender Dadx GroupGroup.properties File Generating the Dadx NextDadx operations 18 Dadx GenerationRetrieveXML StoreXML Deploying the Web serviceExample 9-6 Updated Dadx file 19 Web Service settings Example 9-7 namspacetable mapping entryTest the Web Service 20 Testing Web ServiceModify passenger list application to use the Web Service Mapping DTDIDs to XSD namespaces and locationsExample 9-9 Changing root element Modifying the XSL fileExample 9-8 Namespaces Example 9-10 passengerList.xslPage Creating Html input form CenterUsing Java proxy 22 Input form GetPassengerList.htmlConclusion 23 passengerList resultPage Development of XML-based Enterprise applications 215Multi-tier solution architecture XML based Enterprise application architectureSolution outline for customer registration sample Customer registrationRetrieving customer information Customer registration scenario outlineDeveloping the customer registration sample Retrieving customer data scenario outlinePreparing to create the Web tier JavaBean to XML client wizardCustomer JavaBean class specification Creating the Web tierJavaBean 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 11 JavaBean XML/XSL client prefix specification Investigating the Web-tier generated filesPage Java Bean ProduceDOM DocumentOrg.w3c.dom.Document XML DataExample 10-2 Source code for CustomerXSLServlet init method Development of XML-based Enterprise applications Xslt Processor Stylesheet Transformer ProduceDOMDocumentXML Document 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 Example 10-12 Schema file for the XML data Validating the Web tierBuilding the entity EJB and the database schema 15 Customer registration formPreparing to create the entity EJB Project configurationEJB mapping approaches review Creating the entity EJB17 Create an Enterprise Bean wizard Creating the database mapping and tables 18 Enterprise bean details19 EJB to RBD Mapping wizard for CustomerInfo module 20 Target database specification 21 EJB to RDB mapping editor Access beans 22 Database connection definitionCreating an access bean for the entity bean 23 Access Bean creation wizard Creating a Jdbc data source24 Data source definition for a server configuration Binding the EJB to a Jdbc data source 25 Jdbc data source definitionIntegrating the entity EJB with the Web tier Modifying CustomerXML27 CustomerInfoWeb project properties Example 10-13 create source codeModifying CustomerXSLServlet Example 10-14 CustomerXSLServlet doPost source codeExample 10-15 Retrieval function Application deployment and testingRetrieval function Example 10-16 Confirming the creationTesting the registration application 28 Generating the deployed code for the EJB29 Customer Registration form Page Light weight XML-based Enterprise Application 257SQL-XML solution architecture SQL to/from XML librariesLight weight XML-based Enterprise Application Customer registrationRetrieving customer information XSL Servlet Adding the libraries to the project XML Document formatXMLToSQL architecture Converting an XML DocumentXMLToSQL Modifying CustomerXSLServletInitializing the XMLToSQL class Example 11-1 initSQLProperties method Creating an XML DocumentModifying the produceDOMDocument method We need to change to Example 11-2 ProduceDOMDocumentforToolsExecuting the XMLToSQL class Example 11-3 CustomerXSLServlet doRegister methodExample 11-5 The xslif tag Modifying the doPost methodExample 11-4 CustomerXSLServlet doPost method Adding the error case Example 11-6 Customer.XSL firstname templateStatement Retrieving a customerJdbcDriver FormatExample 11-7 initQueryProperties method Initializing the SQLToXML classSQLToXML Executing the SQLToXML class Example 11-8 CustomerXSLServlet doQuery methodExample 11-10 showPage method Modifying the showPage methodExample 11-9 CustomerXSLServlet doPost method for query Example 11-12 Customer.XSL membership template Modifying the doGet methodExample 11-11 showPage method Example 11-13 Result XSL Page Using datasource with SQLToXML and XMLToSQL class Customer Registration formClass definition Getting the datasourceExample 11-15 setDatasourceMethods ConstructorsExample 11-14 setDatasourceMethods Execute methods Conclusion 11 Core data is an XMLPage Deploying your Web application 283Manual deployment Exporting your project from Application DeveloperInstalling the EAR file on WebSphere AEs Starting the WebSphere AEs Admin ConsoleInstalling the EAR Select Enterprise ApplicationsTesting the application Publishing to a remote server AEs Creating a remote server instanceCreating 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 Part 4 Appendixes 297Page 299 Things to do before installation Installing Application DeveloperWebSphere Studio Application Developer installation Selecting your workspace Select optionsVerifying the installation Programs-IBM WebSphere Studio Application Developer-IBMWebSphere Studio Application Developer Programming Guide 305 Hardware and software prerequisites Create groups and usersStop the Web server processes Install WebSphere Application ServerCheck that IP ports are unused 10 Installation options 11 Security options 12 Snoop servlet accessed through embedded Web server 311 Using the Web materialLocating the Web material How to use the Web material System requirements for downloading the Web materialAbbreviations and acronyms 313OTS Other resources IBM RedbooksReferenced Web sites 315How to get IBM Redbooks IBM Redbooks collectionsIndex 317Jaxp Wsaa Xacml Xsltc 48 Spine 475-0.875 250 459 pages Page Page XML Files