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 are used to connect to database Servers. There are specific jar files for specific database server. These jar files are not provided with the Adeptia Suite. These jar files are available with the database servers. Driver jar files can also be obtained from 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:
Enterprise |
Premier |
Professional |
Express |
---|---|---|---|
? |
? |
? |
? |
Steps to create a database driver
- Click the Develop tab.
- Go to Services > Connector and then click Database Driver.
The Manage Database Driver screen is displayed (see Figure 587).
Figure 587: Manage Database Driver
- Click the Create New link. The Create Database Driver screen is displayed.
- Enter the name and description of the new database driver in the textboxes Name and Description respectively.
- Click the Browse button to upload the driver jar files for the database. The Upload Jar Files screen is displayed (see Figure 588).
Figure 588: Browse Database Jar
- Click Browse… and select the required jar file. The path of the selected jar file is displayed in the textbox Browse File. A list of required Jar files for different databases is displayed in the table below.
Table 1: Jar Files for Database Servers
Database Servers |
Driver Jar Files |
---|---|
Oracle |
Classes12.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 |
- Click the Upload JAR button. The file name is displayed under the heading File Names.
- Repeat steps 6 and 7 to upload additional jar files.
If required, you can also unload the JAR files. To unload jars files, click the Unload JAR button.
- Click the Finish button 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
- Enter the Driver Main Class Name of the database in the Driver Main Class Name field. 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… button 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.
Table 2: Driver Main Class Names for Database Servers
Database Servers |
Driver Main Class Definition |
---|---|
Oracle |
oracle.jdbc.driver.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 |
- Click the Save button.