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.

  1. Go to Parasoft > Preferences to open the Preferences panel.
  2. Choose Parasoft > Available JDBC Drivers.
  3. Add the required drivers to the classpath.

Common JDBC Drivers

The following JDBC drivers are commonly used to connect databases.

Oracle

Downloadhttp://www.oracle.com/us/downloads/index.html
Driver classoracle.jdbc.driver.OracleDriver
JDBC URL

jdbc:oracle:thin:@<host>:<port>:<dbName>

Example:

jdbc:oracle:thin:@bear:1521:mydb

MySQL

Downloadhttp://dev.mysql.com/downloads/connector/j/
Driver classcom.mysql.jdbc.Driver
JDBC URLjdbc:mysql://<host>:<port>/<dbName>

Windows System DSN

DownloadThis driver is included with Java (Java 7 only)
Driver classsun.jdbc.odbc.JdbcOdbcDriver
JDBC URL

jdbc:odbc:DATABASE_NAME 

Where DATABASE_NAME is the database name from your System DSN settings.

Windows System DSNless

DownloadThis 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 had 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

Downloadhttps://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server
Driver classcom.microsoft.sqlserver.jdbc.SQLServerDriver
JDBC URL

jdbc:sqlserver://<host>:<port>;DatabaseName=<databaseName>

Older drivers may have different settings.

Sybase

DownloadDownloads are no longer available
Driver classcom.sybase.jdbc2.jdbc.SybConnectionPoolDataSource
JDBC URLjdbc: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 URLjdbc:db2://host:port/dbName

Apache Cassandra

Download

https://www.progress.com/jdbc/apache-cassandra

See the documentation for additional details:

https://documentation.progress.com/output/DataDirect/jdbccassandrahelp/

Driver calsscom.ddtek.jdbc.cassandra.CassandraDriver
JDBC URLjdbc:datadirect:cassandra://server:port;KeyspaceName=keyspace
  • No labels

Need assistance? Visit our support page