Oracle9i XML Sample:
Product Catalog Sample with New Oracle9i XML Database Features and the 9i XDK for Java

April 2002

OTN developers have built sample applications that demonstrate the features of Oracle XML Developer's Kit(XDK) for Java and Oracle9i native XML support. The Product Catalog sample application is based on a Product Catalog management scenario where options like administration, search and browse are provided on the catalog records. User can create different Categories and Products within categories. The Product XML schema and details are stored in XMLType columns inside the database.

This sample demonstrates the following Oracle9i native XML features:

  • Storing, retrieving and searching of XML data inside the database.
  • Creation and use of functional indexes for searching XML data inside the database.
  • Use of XPATH, SYS_DBURIGEN, DB-URI-refs and sys.dburitype in the database.

And the following Oracle XML Developer's Kit(XDK) features :

  • Using XML Parser for Java
  • Using XML Schema Processor for Java
  • Following features of XSQL Pages Publishing framework:
    • XSQL Page Custom Action Handlers
    • Custom XSQL Connection Managers
    • Generating PDF document using Apache FOP(Formatting Objects Processor) in XSQL pages
    • XSL Transformations from XML to HTML, EXCEL and WML through XSQL pages
    • Assigning different stylesheets based on User Agent. E.g.: Netscape, IE, Palm, WAP device...

Prerequisite:

  • Oracle9i Database
  • Oracle XML Developer's Kit(XDK) for Java version 9.2.0.2.0
  • Apache FOP(Formatting Objects Processor) implementation for generating PDF output
  • Oracle9iAS Containers for J2EE(OC4J) 2.0

Download the Sample

The download includes installation instructions, Java source code, XSQL source code and SQL scripts for building the database.

Related Documents

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy