| Publisher | DataDirect Networks | ||
|---|---|---|---|
| Format | 321.9KB PDF | Date added | 22 Aug 2003 |
| Topics | XML, Java, Database Management | ||
| Downloads | 101 | ||
This paper explores different approaches for creating XML structures from SQL queries by comparing SQL/XML to custom-coded solutions using JDBC and SAX or DOM and to proprietary XML extensions from the database vendors. Many Java applications exchange data as XML, but store and query data using a JDBC connection to a traditional relational database. Unfortunately, XML and SQL represent information in very different ways, and many developers spend significant effort converting between the two formats. When producing XML for exchange, developers need a way to build hierarchical XML structures using queries on a set of unordered, two-dimensional tables. Similarly, they need a way to update the content of their two dimensional tables using data found in XML hierarchies.
Did you find this white paper useful?
23 out of 50 users found this white paper useful
Related white papers
Think Globally, Act Locally: Targeting New Customers with Geolocation
When it comes to content, "one size fits all" used to be the norm and web traffic was measured in "hits". No longer. Companies that are leading the...
Introducing Xomega for XML Object Modeling and Code Generation
XML-based Model Driven Development can be a simple, but very powerful alternative to the UML-based MDA and can result in significantly increased productivity, clean and robust designs and improved system...
Oracle Primavera P6 EPPM Integrations With Web Services and Events
Primavera Web Services is an integration technology that extends P6 functionality and business objects. Based on open standards such as SOAP, XML and WSDL, Primavera Web Services enable developers to...
Radio-Research Firm Reduces Production Time and Costs With Presentation Solution
Research Director, Inc. (RDI), one of the largest radio-research consulting firms in the United States, produces large, complex presentations that provide radio-audience data for its customers once every quarter. Faced...
Testing SIP Call Flows Using XML Protocol Templates
A Session Initiation Protocol (SIP) Call Flow is a casual sequence of messages that is exchanged between interacting SIP entities. This paper presents a novel test system for SIP based...
Consortium Develops New Accessible Multimedia Tool for the Print Disabled
The DAISY Consortium develops and promotes DAISY (the Digital Accessible Information System), the world's most widely used assistive reading technology for the print disabled. The consortium wanted a solution that...
Web Server Improvements with Microsoft Server 2008
This is another in our series about Microsoft Longhorn, also known as Server 2008. In this series we break down the most important components of Longhorn and give listeners the...
