Skip to Content
Building Oracle XML Applications
book

Building Oracle XML Applications

by Steve Muench
October 2000
Intermediate to advanced
812 pages
21h 21m
English
O'Reilly Media, Inc.
Content preview from Building Oracle XML Applications

Inserting Datagrams Using Java

In this section, we’ll study how the previous techniques can be applied from within your own Java programs.

Inserting Arbitrary XML Using Java

We’ve learned so far that the Oracle XML SQL Utility can be used to insert XML datagrams into database tables and views. We used the command-line oraxsl utility to transform the XML datagram into canonical <ROWSET>/<ROW> format before feeding it to the OracleXML utility for insertion into the database. Later, we saw how a simple <xsql:insert-request> action element could be used in an XSQL page to accomplish the same thing. The XSQL Servlet is able to automate these steps since both the Oracle XSLT Processor (oraxsl) and the Oracle XML SQL Utility (OracleXML) can be used programmatically by any Java program.

The API for the Oracle XSLT Processor comprises two simple-to-use objects, XSLStylesheet and XSLProcessor , and the API for the Oracle XML SQL Utility is even simpler. The OracleXMLSave object takes care of inserting XML into the database for us. Here we’ll look at an example of using these three objects in a simple Java program to insert the contents of a live Moreover.com news story datagram fetched directly over the Web into our newsstoryview.

Example 12.34 does the following to accomplish this feat:

  1. Parses the live XML news feed from Moreover.com by calling the parse() method of a DOMParser object, passing it a string URL to the live news feed:

    // Create a DOM Parser to Parse the News Document DOMParser ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Oracle Database 11g Building Oracle XML DB Applications

Oracle Database 11g Building Oracle XML DB Applications

Jinyu Wang
Querying XML

Querying XML

Jim Melton, Stephen Buxton
XML Data Management: Native XML and XML-Enabled Database Systems

XML Data Management: Native XML and XML-Enabled Database Systems

Akmal B. Chaudhri, Awais Rashid, Roberto Zicari

Publisher Resources

ISBN: 1565926919Catalog PageErrata