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:
Enterprise | Premier | Professional | Express |
---|---|---|---|
? | ? | ? | ? |
Steps to create a database driver
- Click the Develop tab.
- Go to
Go to Develop >Services > Connector
and then click> Database Driver.
...
Click Create New.
...
- Click the Create New link. The Create Database Driver screen is displayed.
- Enter
- On the New Database Driver window, enter the name and description of the new database driver in the textboxes Name and Description respectivelytext boxes.
- 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).
...
- Click Browse… and select the required jar file.
On the Upload Jar File window, browse to and select the jar file. The path of the selected jar file is displayed in
the textboxthe Browse File text box.
A list of required Jar files for different databases is
displayedin the following table
below.
...
...
Database Servers
...
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
Click the Upload JAR button. The file name is displayed under the heading File Names.Anchor _Hlt117833462 _Hlt117833462 Repeat steps 5 to 6
and 7to upload additional jar files.
jarsInfo If required, you can also unload the JAR files. To unload
thejar files, click
buttonUnload JAR
.
Click
theFinish
button toto return to the Manage Database Driver screen. The uploaded jar file(s) is displayed in the Upload Driver Jar files field
(see Figure 589).
...
- Enter the Driver Main Class Name
Enter the main class name of the database in the Driver Main Class Name
field. Driver Main Class Name is a fully qualified
javaJava 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
...
.
...
...
Database Servers
the
ClickSubmit
button. A list of Driver Main Class Name of different databases
is displayed in the table below.
...
appears.
Database Servers
Driver Main Class Definition
Oracle
oracle.jdbc.driver.OracleDriver
For Oracle BLOB Data type:
com.ddtek.jdbc.oracle.OracleDriverIBM 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 Click Save button.