Method for accessing object linking-embedding database data via JAVA database connectivity

• US 7,089,566 B1
• Filed: 02/07/2002
• Issued: 08/08/2006
• Est. Priority Date: 02/07/2002
• Status: Expired due to Term

• Current Assignee: Unisys Corporation
• Original Assignee: Unisys Corporation
• Inventors: Johnson, Peter
• Primary Examiner(s): Thomson, William
• Assistant Examiner(s): CAO, DIEM K
• Application Number:
  US10/071,815
• Time in Patent Office: 1,643 Days
• Field of Search: 717/116, 717/118, 719310-320, 719328-330
• US Class Current: 719/328
• CPC Class Codes: G06F 9/541 via adapters, e.g. between incompatible applications

Abstract

A method for enabling database access to an OLE DB compatible database by a client using a JAVA JDBC Application Program Interface. A JDBC Driver program provides a bridging functionality between the using JDBC client and the OLE DB database.

Claims

1. A method for enabling a Java application, that is a client of a JDBC driver, to access data from an object linking-embedding database (OLE DB) via utilization of a Java Database Connectivity (JDBC) interface, comprising the steps of:

(a) initiating a Java application to contact said Java Database Connectivity (JDBC) driver;

(b) bridging, by said JDBC driver, to an OLE DB data provider, to provide a JDBC interface between said JDBC driver and said OLE DB database, wherein said bridging step includes the steps of;

(b1) providing a series of Java classes that implement said JDBC interface;

(b2) implementing a Datalink Library in C++ for said Java classes to act as an OLE DB client for said OLD DB data provider; and

(b3) connecting said Java classes to said OLE DB client to enable utilization of said OLE DB data provider.

2. A method for enabling a Java application acting as a JDBC Driver client to access an OLE DB database having OLE DB objects, by utilization of a standard Java Database Connectivity (JDBC) API interface, comprising the steps of:

(a) establishing, for each interface in said JDBC API interface, a corresponding Java class including Java objects and a corresponding C++ class including C++ objects;

(b) maintaining in each Java object of said Java class, a reference to its corresponding C++ object in said C++ class;

(c) maintaining in each C++ object a reference to the OLE DB object which most closely matches the functionality of said JDBC API interface;

(d) passing, by said C++ object, a database query to said OLE DB database via an OLE DB data provider holding an OLE DB Command Object;

(e) connecting to said OLE DB database to garner a response to said database query; and

(f) returning said response to said Java application.

3. A system utilizing a Java JDBC API application specification which is the Java platform standard call level API for database access designated core JDBC 2.1 API by Sun Microsystems, and also utilizing an OLE DB API Specification which is a Microsoft statement for Microsoft Data Access Components of which OLE DB (Object Linking and Embedding Database) is one collection of COM objects that encapsulate database management system services for various servers and data providers and has four OLE DB objects which are DataSource, Session, Command, and Rowset, said system for enabling a client utilizing a Java JDBC API application to access an OLE DB database which is designed for communication with OLE DB-type interfaces comprising:

(a) JDBC Driver means that utilizes JDBC API Java standards and performs a bridge interface operation between a Java JDBC API application and an OLE DB data provider which implements said OLE DB API specification, wherein said JDBC Driver means includes;

(a1) a series of JDBC API interfaces wherein each said JDBC API interface contains a Java class holding including Java objects and a corresponding C++ class having C++ object;

(a2) means to maintain a reference between each java object and its corresponding C++ object;

(a3) means to maintain a reference between each C++ object and the particular OLE DB object which most closely matches the functionality of the JDBC API interface; and

(b) means to pass an OLE DB database query initiated by said Java JDBC API application as a client to a database organized for OLE DB API clients and receive a response to said OLE DB database query, wherein the response is in a format suitable for said Java JDBC API application.

4. The system of claim 3 wherein each C++ object maintains a connective reference to multiple interfaces defined by the said OLE DB object.

5. The system of claim 3 wherein said means (b) to pass an OLE DB database initiated by said JAVA JDBC API application as a JAVA client to an OLE DB database organized for OLE-DB API clients, includes:

(b1) means to create a JDriver object;

(b2) means to create a CDriver object which provides a C session object;

(b3) means to make said JDriver object reference itself to said CDriver object;

(b4) means to create a Data Source object;

(b5) means to make said CDriver object reference said Data Source object;

(b6) means to develop a OLE DB Session object;

(b7) means to make said CSession object reference said OLE DB Session object;

(b8) means to create a JSession object;

(b9) means to make said JSession object reference said CSession object;

(b10) means to return said JSession object to said Java client.

6. The system of claim 5 which further includes:

(c) means to create a Statement object, said means including;

(c1) means to query whether said OLE DB Data Provider supports an OLE DB Command object;

(c2) if no support is provided to said OLE DB command object by said OLE DB Data Provider, then, activation means to create a CStatement object which is referenced to said OLE DB Session object.

7. The system of claim 6 wherein said means (c1) to query whether said OLE DB Data Provider supports an OLE DB Command object indicates a negative (NO) response, includes:

(c1a) means to catch said negative response as an exception and display an error code.

8. The system of claim 5 wherein if said OLE DB Data Provider does not support (c2) said OLE DB Command object, then said activation means includes:

(c2a) means to create an OLE DB Command object;

(c2b) means to create a CStatement object which is referenced to said OLE DB Command object;

(c2c) means to create a JStatement object which is referenced to said CStatement object;

(c2d) means to return said JStatement object to said JAVA client.

9. The system of claim 8 wherein said means (c2a) to create an OLE DB Command object includes:

(c2a1) means to create a CPreparedStatement object or a CCallableStatement object which is referenced to said Command object;

(c2a2) means to create a JPreparedStatement object or JCallableStatement object which is respectively referenced to said CPreparedStatement object or said CCallableStatement object;

(c2a3) means to return, to said JAVA client, said JPreparedStatement object or said JcallableStatement object.

10. The system of claim 8 wherein said means (c2b) to create a CStatement object referenced to said OLE DB Command object includes:

(c2b1) means to indicate that said CStatement object does reference said OLE DB Command object;

(c2b2) means to execute said OLE DB Command of said Command object;

(c2b3) means to question if said OLE DB Command object involves a query;

(c2b4) means, if said Command object involves a query, to create a Rowset object;

(c2b5) means to create a CResultSet object which is referenced to said Rowset object;

(c2b6) means to create a JResultSet object which is referenced to said CResultSet object;

(c2b7) means to return to said client, said JResultSet object.

11. The system of claim 10 wherein said means (c2b3) to question said OLE DB Command object indicates that it is NOT a query, then said system includes:

(c2b31) means to return to said JAVA client, a count of the number of records which have been updated.

12. The system of claim 8 wherein said means (c2b) to create a CStatement object referenced to said OLE DB Command object includes:

(c2bn1) means to indicate that said CStatement object does not reference said OLE DB Command object;

(c2bn2) means to indicate that the command to said OLE DB Command object is a simple query;

(c2bn3) means to call the open Rowset function of the IOpenRowset interface which is supported by the Session object;

(c2bn4) means to create a Rowset object;

(c2bn5) means to create a CResultSet object referenced to said Rowset object;

(c2bn6) means to create a JResultSet object referenced to said CResultSet object;

(c2bn7) means to return to said JAVA client, said JResultSet object.

13. The system of claim 8 wherein said means (c2b) to create a CStatement object referenced to said OLE DB Command object includes:

(c2b1) means to indicate that said CStatement object does not reference said OLE DB Command object;

(c2b2) means to indicate that an SQL command to said OLE DB Command object is NOT a simple query;

(c2b3) means to flag an exception condition and display an error message.

14. The system of claim 8 wherein said means (c2a) to create an OLE DB Command object includes:

(f1) means to execute an SQL command;

(f2) means to indicate said command is an SQL query;

(f3) means to create an OLE DB Rowset object to handle said SQL query;

(f4) means to create a C++ ResultSet object which references said Rowset object;

(f5) means to create a JAVA JResultSet object which references said CResultSet object created in clause (f4);

(f6) means to return said JResultSet object to the JAVA client application.

15. The system of claim 14 wherein means (f4) to create said C++ResultSet object includes:

(g1) means to create a CResultSetMetaData object;

(g2) means to acquire column information from said Rowset object;

(g3) means to create a JResultSetMetaData object based on said column information;

(g4) means to return to said JAVA client, a reference to said JResultSetMetaData object.

16. The system of claim 15 wherein said means (g1) to create a CResultSetMetaData object includes:

(h1) means to create a CDatabaseMetaData object which is referenced to said OLE DB Session object;

(h2) means to create a JDatabaseMetaData object which is referenced to said CDatabaseMetaData object;

(h3) means to return to said JAVA client, said reference to said JDatabaseSetMetaData object.

17. The system of claim 15 wherein said means (f3) to create an OLE DB Rowset object includes:

(d1) means to create a C++ResultSet object which is referenced to said OLE DB Rowset object;

(d2) means to create a JResultSetMetaData object based on said column information cited on clause (g3);

(d3) means to return to said JAVA client, a reference to said JResultSetMetaData object.