The Easysoft JDBC-Access Gateway is a type 2 JDBC driver for MDB format Microsoft Access databases. The Easysoft JDBC-Access Gateway provides JDBC access from Java applications, application servers and servlets to MDB files. If you configure your Java security policy to allow the Easysoft JDBC-Access Gateway to load its native component, the driver can also be used with Java applets.
The Easysoft JDBC-Access Gateway uses the Java Native Interface (JNI) to communicate with the Microsoft Access ODBC driver, there is no need to configure an ODBC data source. Because this ODBC driver library also supports Excel, the Easysoft JDBC-Access Gateway also provides JDBC access to XLS format Excel workbooks.
JDBC is a Java application programming interface (API) that connects Java to relational databases (and other tabular data, such as spreadsheets and flat files). To interact with a database, a Java application uses a JDBC driver. A JDBC driver implements the JDBC API for a particular database.
Microsoft do not produce a JDBC driver for Jet, the underlying database engine for the Microsoft Office product suite. However, Microsoft do produce a Jet-based ODBC driver. (ODBC is another data access technology, the Microsoft implementation of which is included with Windows.) To provide a JDBC interface to Office applications via this native Microsoft interface, a JDBC driver must be able to convert JDBC calls to ODBC calls. As far as the Java application is concerned, it is using a normal JDBC driver. As far as the Office application is concerned, it is being accessed via the normal ODBC driver.
The Easysoft JDBC-Access Gateway is a JDBC driver for Access that uses the Java Native Interface (JNI) to communicate with the Access ODBC driver library. Because this ODBC driver library also supports Excel, the Easysoft JDBC-Access Gateway also provides JDBC access to Excel.
You can use the Easysoft JDBC-Access Gateway to connect Java applications, servlet/JavaServer Pages (JSP) engines, integrated development environments (IDE) and application servers with Access and Excel.
Comments