You can specify the JDBC drivers needed to connect to a database. The driver must be available on your CLASSPATH. If it is not, your database will not be accessible.
- Choose Parasoft> Preferences to open the Preferences panel.
- Select Available JDBC Drivers on the left.
- Add the required drivers to the classpath.
Common JDBC Drivers
The following JDBC drivers are commonly used to connect databases.
Oracle
MySQL
Windows System DSN
| Download | This driver is included with Java (Java 7 only) |
|---|
| Driver class | sun.jdbc.odbc.JdbcOdbcDriver |
|---|
| JDBC URL | jdbc:odbc:DATABASE_NAME Where DATABASE_NAME is the database name from your System DSN settings. |
|---|
Windows System DSNless
| Download | This driver is included with Java (Java 7 only) |
|---|
| Driver class | sun.jdbc.odbc.JdbcOdbcDriver |
|---|
| JDBC URL | jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=PATH_TO_MICROSOFT_ACCESS_DATABASE_FILE;
Where PATH_TO_MICROSOFT_ACCESS_DATABASE_FILE is the absolute path to the location where a local database file created in Microsoft Access is stored. For example, if you have a MS Access database file that is named testDB.mdb and saved in the C: drive, you would use the URL
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/testDB.mdb; |
|---|
SQLServer
Sybase
| Download | Downloads are no longer available |
|---|
| Driver class | com.sybase.jdbc2.jdbc.SybConnectionPoolDataSource |
|---|
| JDBC URL | jdbc:sybase:Tds:host:port/dbName |
|---|
DB2
| Download | http://www-01.ibm.com/support/docview.wss?uid=swg21363866 Additional IBM license files may be added. Depending on the target DB2 host, additional IBM db2jcc_license_*.jar license files may be added to the JDBC drivers list. Please refer to DB2 materials for details. |
|---|
| Driver class | com.ibm.db2.jcc.DB2Driver Use the universal pure Java driver found under [DB 2 install dir]/java |
|---|
| JDBC URL | jdbc:db2://host:port/dbName |
|---|
Apache Cassandra