JDBC is an interface standard for java based program to interact
eXERD uses JDBC in order to connect and communicate with
database. To connect database with JDBC, JDBC driver is needed.
External Link : JDBC Driver (WIKIPEDIA)
- In case of the driver Oracle database, you can get the
driver from [OracleHome]/jdbc/lib.
[OracleHome] - Directory where Oracle is installed.
- Oracle JDBC Driver Download Page
Note! Old versions of Oracle
drivers – up to 22.214.171.124, don’t provide any method for version
information using meta data. Be sure to use version 126.96.36.199 or
later of which ojdbc14.jar driver supports JDK 1.4. The later
version driver provides compatibility for lower versions. So it is
recommended to use the latest version of ojdbc6.jar which supports
class of Oracle
driver class has stopped support from Oracle 9.x version. It is
provided only for compatibility, but we recommend you to install oracle.jdbc.OracleDriver
Reference: Oracle9i JDBC Drivers
- Microsoft SQL Server
- IBM DB2
Go to DBMS Connection and click 'Browse' button.
Select JDBC driver file. (In Case of Oracle)
After selecting driver class, enter the connecting
In case of SQL Server, enter as follows:
In case of DB2, enter as follows:
Click 'Check the connection' button and check if the
connection is obtained successfully.