Transformation of Data in XML into a Database Table Using BorlandXML API
Zhong Wei Luo · Journal of Wuhan Automotive Polytechnic University · 2003
Centrered on the transformation of data in XML into a database table, the No. 4 type JDBC driver provided by Data Direct Co. Ltd and JDBC API are analyzed. A pure Java application is programmed which can transform the data in XML into a database table. There are two models to choose for the interface between JDBC API and a data management system: the famous JDBC-ODBC bridge model and the No. 4 type JDBC driver. In this paper the No. 4 type JDBC driver provided by Data Direct Co. Ltd is employed to avoid the ODBC layer and to improve the efficiency. According to the DTD grammar of an XML document, BorlandXML API unmarshals data in the XML document and generates some Java class, and the data provided by the XML document can be transformed into a database table. It should be emphasized that the Java class generated by unmarshalling an XML document with BorlandXML API changes in each particular case.