Card Payment Gateway Application ( CPGA ) simulates functionality of a credit card company. Customers ( Card Holders and Merchants ) can see their account and transaction details. CPGA administrators are allowed to create customer and account records. One big difference, however, is the way user data is stored. This application stores customer, account and transaction details in Schema based XMLType tables. It also demonstrates how XML DB allows Relational access and XML access to the same data. For presenting the XML data to the user, the native XMLType transformation capabilities are used.

When merchants seek approval for card transactions the request is routed through a Web Service. This service either accepts or denies the transaction depending on the available credit limit and generates transaction logs if the transaction is successful. JSP's are used to create the user interface.

Oracle9i XML DB features covered in this sample are highlighted below.

• XML DB schema registration
• Mapping of complex types through XML Schema
• Structured XMLType tables
• XML Piecewise updates
• XMLType Transformation
• XPath Searching
• Use of DBMS_XMLGEN package

The sample application has been certified on Solaris 5.6, Windows NT 4.0, 2000 and Red Hat Linux Advanced Server release 2.1

Posted on 18-Dec-2002.