By Philip Quinn – I find navigating XML using the XMLDOM object to be hell. Some people seem to get the hang of it, but I don't. However, I find navigating a RecordSet to be much easier. This article will detail how to import an XML file into a RecordSet and to navigate it.
Other News
Server Side SVG
by J. David Eisenberg – The Batik viewer application uses the JSVGCanvas component, which is a Java class that accepts SVG as input and displays it on screen. In this article, we'll use two of the other Batik components, SVGGraphics2D, and the Batik transcoders. The SVGGraphics2D class is the in
Database Architecture: Federated vs. Clustered
The technical white paper, Database Architecture: Federated vs. Clustered, evaluates two different database architectures: the federated architecture, as represented by Microsoft SQL Server, and Oracle9i Real Application clusters. It also explains how to interpret and use benchmark results. (PDF)
Finding ASCII representations of integers via SQL
By Karen Porter – Often I want to include a carriage return or other character into my SQL statement. Single tics are especially confusing due to breaking them on and off to be effective. I now use the CHR() function to write single tics into my SQL. If I forget what integer is required in the CHR()
Database Development in SQLJ, Part II: SQLJ Language Elements
by Boris Milrud – SQLJ is the evolving industry standard language that allows you to write Oracle stored procedures with database-independent code that can be easily ported to other Java-enabled database platforms. Get the lowdown on connection contexts, iterators, executable statements, and host ex
The Visual Display of Quantitative XML
by Fabio Arciniegas A. – While quantitative XML data is everywhere, a less common thing to find is examples of effective ways to display such information. Most resources will merely show you how to use XSLT to convert XML data to HTML, which is often not nearly enough when you need to explain comple
Government to give web services the go-ahead
Andrew Pinder, the eEnvoy, is due to set out a consultation paper for the further development of the UK's eGovernment Interoperability Framework (eGIF). It is expected that this paper will recommend the use of SOAP and UDDI standards for the provision of web service and, in so doing, will provid
Extending XML tools with Jacl scripts
By Phil Whiles – This article shows how to extend open-source Apache XML tools using Jacl, a Java implementation of the popular Tcl scripting language. With Jacl, you can embed scripted functionality within XML or XSL. In addition, due to its Java extensions, you can use Jacl to interact with Java o
Retrieve a Recordset from an Oracle Stored Procedure Using ADO on ASP
This article demonstrates how to call an Oracle package to retrieve a recordset using ADO on Active Server Pages (ASP).
Introduction to Real Application Clusters
Real Application Clusters is one of the revolutionary features in Oracle 9i Database. Real Application Clusters is a breakthrough technology that provides many advantages for Online Transaction Processing (OLTP), Decision Support System (DSS), Online Analytic Processing (OLAP) and hybrid system type