Calling-out Web service from Java stored procedure

This sample implements a purchasing order processing scenario.  

(i)The user can browse through the products catalog and purchase, on-line.

(ii)Based on the login information supplied by the user, a Credit Agency Web service --- which maintains a repository of customers and their credit authorization -- authenticates and authorizes the user for buying products of interest. The status of the order will be stored as 'PENDING' and processed and shipped on a later time.

(iii) A database batch job scheduled to run every 6 min (for demo purposes), processes "PENDING" orders by calling-out the Credit Agency Web service with the customer information, the authorization id (obtained previously), and the exact amount of shipment (which might be different from the initial order amount). If the response to payment request to the Credit Agency Web service is okay, then the order status is changed from "IN_SHIPPING", to "SHIPPED". This marks the end of the life cycle for this particular order. The user can view the status of the order at any time.

For complete information on the architecture, downloading and configuring the demo, refer to the Readme.

E-mail this page
Printer View Printer View