JDBC2XML merges data from any JDBC-compliant database into XML files. Its simple but powerful architecture processes predefined XML templates with embedded SQL queries, and generates XML documents that contain the JDBC or ODBC data merged into the original tagging. In particular, JDBC2XML is a implementation of ODBC2XML in Java, with a number of advantages:

• Portability across machines (ODBC2XML only runs under Win32);
• Easier integration with other server-side Java applications;
• Ability to process multiple documents without re-connecting to the database each time;
• Ability to process input DOM structures;
• Ability to pass JDBC2XML output as a DOM structure to other applications without saving to an XML file;
• Multi-threading: JDBC2XML is now thread-safe; and
• Ability to pass runtime parameters to modify query behavior.

JDBC2XML provides a Java API as well as a sample command-line interface (a future version will be implemented as an Java applet suitable for server-side processing).

Please refer to the ODBC2XML documentation for instructions as to how to define XML templates. In particular, nothing has changed regarding the embedded ODBC2XML instructions within XML template files. Other than running JDBC2XML within a Java Runtime Environment, the only other change is to the JDBC2XML API. The method of embedding SQL statements into XML templates is exactly the same (note: JDBC2XML will recognize the "odbc2xml" or "jdbc2xml" instruction keyword within all embedded processing instructions. Templates that work with ODBC2XML will work with JDBC2XML).

Obtaining JDBC2XML

The distribution file is available here and includes the Xerces XML Parser from the Apache XML Project. You will also require:

• a Java2 1.4 Runtime Environment, available here

Installation

To install JDBC2XML:

• Unpack the distribution ZIP file into a directory on your hard drive (normally c:\jdbc2xml).
• Place the name of this directory into your Java CLASSPATH variable.

Usage

See the file jdbc2xml.bat for an example of how to run JDBC2XML against an ODBC data source (the provided SAMPLE.MDB MS Access file).

See the file sample.java for an example of how to use the Jdbc2xml API from within a Java program.

Release Notes

• Version 1.2, 30-Apr-2003: now uses log4j logging. See the provided log4j.properties file; change the level to DEBUG to see debug output
• Version 1.1i, 16-Apr-2003: added simply logging to a logfile (jdbc2xml.log), also ability to output runtime parameters in the XML
• Version 1.1h, 06-Jan-2003: bug fixes
• Version 1.1g, 02-Jan-2003: changed class name to Jdbc2xml (leading cap) to be consistent with Sun naming convention
• Version 1.1f, 16-Sep-2002: added start_element and end_element processing instructions
• Version 1.1e, 09-Sep-2002: added methods to change runtime params identifier
• Version 1.1d, 28-Aug-2002: added runtime parameters feature
• Version 1.1c, 27-Aug-2002: modified whitespace handling
• Version 1.1b, 26-Aug-2002: added methods to set column and query name delimiters
• Version 1.1a, 23-August-2002: added setPreserveWhitespace() function; fix to userid/pw handling in command-line version
• Version 1.1, 20-August-2002: major bug fixes to nested query handling; also fix to ' entity generation
• Version 1.0, 17-August-2002: beta release

JDBC2XML is distributed as shareware. You may use it for a period of up to 30 days to evaluate it, then you must register it to continue use. Registration entitles users to up to 1 hour of technical support. The registered version is available under these licenses:

JDBC2XML and its accompanying documentation are Copyright © 2002 Intelligent Systems Research. All Rights Reserved. Your use of the program indicates acceptance of the License Agreement with Intelligent Systems Research. This product includes software developed by the Apache Software Foundation.

For more information contact: