Table of Contents
Java Database Connectivity (JDBC) is a standard SQL database access interface, providing uniform access to a wide range of relational databases. JDBC also provides a common base on which higher level tools and interfaces can be built. Elixir Data Designer supports reading of data using JDBC and provides an SQL query builder.
There are four categories of JDBC drivers.
JDBC-ODBC bridge plus ODBC driver - This driver provides JDBC API access via one or more ODBC drivers. ODBC native code and native database client code may be required on each machine that uses this type of driver.
Native API partly-Java driver - A native API partly Java technology-enabled driver converts JDBC calls into calls to the client API for Oracle, Sybase, Informix, DB2, or other DBMS. This driver is similar to the ODBC bridge driver as it requires some binary code to be loaded on each client machine.
JDBC-Net pure Java driver - This type of driver translates JDBC API calls into a DBMS-independent net protocol which is then translated to a DBMS protocol by a server. This net server middleware is able to connect its clients to different databases. The specific protocol used depends on the vendor.
Native protocol pure Java driver - This driver converts JDBC technology calls into the network protocol used by a specific DBMS directly. This allows a direct call from the client machine to the DBMS server and is a practical solution for intranet access.
To illustrate the configuration process for a driver, here are the steps on how to use a MySQL DataSource. The latest MySQL driver can be downloaded from http://www.mysql.com/. The mysql jar file must be copied to the Elixir Repertoire ext folder. Similarly, for an Oracle DataSource, the classes12.jar file provided by Oracle must be copied to the ext folder. For a Postgres driver, check here: http://jdbc.postgresql.org/.
In each case, regardless of the DBMS vendor, the corresponding driver files are copied to the ext folder. Elixir Repertoire must be restarted to load any new drivers added.
If you are using Elixir Repertoire Remote, then the database drivers must be placed in the server ext folder instead. This is because data operations are performed on the server. The only exception is the Query Builder functionality which requires access to the database schema information. See the note in the Query Builder section below describing how to configure the Remote tool to support this.