Skip to main content
Version: 3

Database Driver

A database driver is used to specify the type of database and driver jar files that are required to connect to that database. Database jar files are drivers that are used to connect to database servers. There are specific jar files for a specific database server. These jar files are available with the database servers. Driver jar files can also be obtained from the following locations:

Oracle Server  http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

SQL Server  http://www.microsoft.com/downloads/details.aspx?FamilyID=07287B11-0502-461A-B138-2AA54BFDC03A&displaylang=en

Steps to create a Database Driver

  1. Click Configure > ACCOUNTS > Database Driver.
  2. ClickCREATE Database Driver.
  3. On Create Database Driver screen, enter the name and description of the new Database Source in the Name and Description fields respectively.

4. In the Upload Driver Jar File(s), browse to and upload the driver jar files for the database. 5. On the Upload Jar File screen, browse to and select the jar file. The path of the selected jar file is displayed in the Browse File fields.

A list of required Jar files for different databases is in the following table.

Database ServersDriver Jar Files
OracleClasses12.jar 
For Oracle BLOB Data type: 
base.jar, oracle.jar and util.jar
IBM DB2 (Ver 7.1)db2java.zip (7.1 version)
IBM DB2 (Ver 8.1)db2jcc.jar
MS SQLmsbase.jar, mssqlServer.jar and msutil.jar
JTDS-SQL ServerJtds.jar
HSQL DBhsqldb-1.7.2.jar
  1. Click Upload JAR. The file name is displayed under the heading File Names.

7. Repeat steps 5 to 6 to upload additional jar files.

InformationIf required, you can also unload the JAR files. To unload jar files, click Unload JAR.

  1. Click Finish to return to the Create Database Driver Info screen. The uploaded jar file(s) is displayed in the Upload Driver Jar File(s) field.

  2. Enter the main class name of the database in the Driver Main Class Name. Driver Main Class Name is a fully qualified Java class name for the main database driver class. The driver class name typically starts with a com., net. or org. followed by the company domain.

    For example, the JDBC driver class for mysql.com is called com.mysql.jdbc.Driver. Click Get Driver Class to select the Database Driver Main Class Definition in the Select Class field.

    Click Submit. A list of Driver Main Class Name of different databases appears.

    Database ServersDriver Main Class Definition
    Oracleoracle.jdbc.driver.OracleDriver 
    For Oracle BLOB Data type: 
    com.ddtek.jdbc.oracle.OracleDriver
    IBM DB2 (Ver 7.1)COM.ibm.db2.jdbc.net.DB2Driver
    IBM DB2 (Ver 8.1)com.ibm.db2.jcc.DB2Driver
    MS SQLcom.microsoft.jdbc.sqlServer.SQLServerDriver
    JTDS-SQL Servernet.sourceforge.jtds.jdbc.Driver
    HSQLDBorg.hsqldb.jdbcDriver
    MS Accesssun.jdbc.odbc.JdbcOdbcDriver
    MS Excelsun.jdbc.odbc.JdbcOdbcDriver

  3. Expand Advanced Propertiesand select the project of the activity in the Project list.

  4. Click Save.

You may be interested in...

What's new​
Best practices​
Training guides​
Frequently asked questions​
Adeptia Connect APIs​