Search

Page tree
Skip to end of metadata
Go to start of metadata

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 not provided with Adeptia Suite and 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. Go to Develop >Services > Connector > Database Driver.

  2. Click Create New.




  3. On the New Database Driver window, enter the name and description of the new database driver in the Name and Description text boxes.
  4. In the Upload Driver Jar File, browse to and upload the driver jar files for the database. 

  5. On the Upload Jar File window, browse to and select the jar file. The path of the selected jar file is displayed in the Browse File text box

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

    Database Servers

    Driver Jar Files

    Oracle

    Classes12.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 SQL

    msbase.jar, mssqlServer.jar and msutil.jar 

    JTDS-SQL Server

    Jtds.jar

    HSQL DB

    hsqldb-1.7.2.jar

  6. Click Upload JAR. The file name is displayed under the heading File Names.
  7. Repeat steps 5 to 6 to upload additional jar files.

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

  8. Click Finish to return to the Manage Database Driver screen. The uploaded jar file(s) is displayed in the Upload Driver Jar files field.

     

  9. 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 from the Select Class dropdown list.


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

    Database Servers

    Driver Main Class Definition

    Oracle

    oracle.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 SQL

    com.microsoft.jdbc.sqlServer.SQLServerDriver

    JTDS-SQL Server

    net.sourceforge.jtds.jdbc.Driver

    HSQLDB

    org.hsqldb.jdbcDriver

    MS Access

    sun.jdbc.odbc.JdbcOdbcDriver

    MS Excel

    sun.jdbc.odbc.JdbcOdbcDriver

  10. Click Save.
  • No labels