Page Comparison

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 , which that are used to connect to database Serversservers. There are specific jar files for a specific database server. These jar files are not provided with the Adeptia Suite . These jar files 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

This feature is available in:

Steps to create a database driver

1. Click the Develop tab.

2. Go to Go to Develop >Services > Connector and then click  > Database Driver.

   The Manage Database Driver screen is displayed (see Figure 587).

    Image Removed

   Figure 587: Manage Database Driver

3. Click the Create New link. The Create Database Driver screen is displayed.
4. Enter

   Click Create New.

   
   Image Added
   
   

5. On the New Database Driver window, enter the name and description of the new database driver in the textboxes Name and Description respectivelytext boxes.

6. Click the Browse button to In the Upload Driver Jar File, browse to and upload the driver jar files for the database. The Upload Jar Files screen is displayed (see Figure 588).

   Image Removed
   Figure 588: Browse Database Jar

   Click Browse…

    

7. On the Upload Jar File window, browse to and select the

   required

   jar file. The path of the selected jar file is displayed in

   the textbox

   the Browse File text box. 

   A list of required Jar files for different databases is

   displayed

   in the following table

   below

   .

   
    

   Table 1: Jar Files for Database Servers

   Database Servers	Driver Jar Files
   Oracle	Classes12.jar For Oracle BLOB Data type: base.jar, oracle.jar and util.jar These Jars can be downloaded from http://www.datadirect.com/download/index.ssp
   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

8. Anchor
   _Hlt117833462 _Hlt117833462

   Click the Upload JAR button. The file name is displayed under the heading File Names.

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

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

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

    

    Figure 589: Uploaded Driver Jar Files 

11. Enter the Driver Main Class Name main class name of the database in the Driver Main Class Name field. Driver Main Class Name is a fully qualified java 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… button to Class to select the Database Driver Main Class Definition from the Select Class dropdown list (see Figure 590).

    

    Figure 590: Select Database Driver Main Class Name

    
    Click

    the

    Submit

    button

    . A list of Driver Main Class Name of different databases

    is displayed in the table below.
    Anchor_Toc156195291_Toc156195291 Anchor_Toc177878273_Toc177878273 Anchor_Toc208651170_Toc208651170 Anchor_Toc235424652_Toc235424652 Anchor_Toc315524525_Toc315524525Table 2: Driver Main Class Names for Database Servers

    Database Servers

    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

12. Click the Click Save button.