Research And Implementation Of JDBC And COM Datasource Integration

With the rapid development of information technology, lot of information is saved into kinds of datasources, according to the differences of application backgrounds of information. These datasources not only include kinds of relational database, but also COM component-based datasources used in E-governmental business. Nowadays, information communication is very prevalent for the case of the great mature of internet. It is extremely important how to integrate these distributed and heterogeneous datasources, and make data exchanged without changing separately administrated systems which have already existed.JDBC and COM datasource integration adopts distributed object technology. It makes data integrated from datasources locating at many clients through server. Client transforms data in local datasource into middle data carrier, and then sends the carrier to server. Other clients get content of the middle data carrier, and transform the data of the carrier into local datasource.The paper uses XML file as middle carrier, makes data integrated from datasources locating at many clients, making use of the kinds of J2EE technologies, which are widerly used in distributed application of enterprise. The paper's researchs include followings:(1) The paper analyzes the shortage of already data transformation using XML as data carrier, and constitues the XML data file suitable for many datasources with uniform format. The paper introduces meta-information into XML file. Meta-information saves not only data, but also schema and sematics information used for data transformation. .(2) The paper analyzes data types of relational database, sorts these data types and designs transformation algorithm. Based on transformation of data types, the paper realizes the schema transformation of relational database, and transformation of database to XML and XML to database, further. Based on inter-transformation between XML and database, the paper realizes the inter-transformation between XML and COM component-based datasource. The paper realizes inter-transformation between structured datasources and non-structured datasources using XML as middle data carrier finally.(3) The paper introduces JCA into integration of the COM component-based datasource, and designs the JCA resource adapter of the COM component-based datasource. The paper integrates the COM component-based datasource seamlessly with JCA resource adapter.(4) The paper designs and realizes the model of datasource integration, making data integrated from heterogeneous datasources locating at many clients.