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. Choose Parasoft> Preferences to open the Preferences panel.
  2. Select Available JDBC Drivers on the left.
  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 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

Microsoft's JDBC driver download for SQL Server comes with two jar files—sqljdbc.jar and sqljdbc4.jar—for two different versions of Java. sqljdbc4.jar (the newer one for Java 6 and later) is the one that you need to add to the JDBC driver preferences.

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