7.6 JDBC Connector

The following procedure explains the migration to the JDBC connector. This is a mandatory step.

IMPORTANT:Version 2.0 has removed the built-in connectors for MySQL and Oracle 10G because of licensing issues. If you have existing test suites that use these two connectors, when opening the test suite the migration process will modify it to use the standard JDBC connector.

  1. Download the appropriate JDBC Driver jar (MySQL or Oracle10G) and copy it into your Identity Validator install directory (lib/jars).

  2. Restart the Identity Validator 2.0 server.

  3. Within Identity Validator, edit the connector properties for the former MySQL or Oracle connector. Fill in the Driver Class field with the appropriate value for the JDBC Driver. Note the following information for migration.

JDBC Driver Information for MySQL and Oracle 10G

MySQL

Oracle 10G

  • Using the “Get Column Value and Set Variable” action:

    You must use a SELECT statement in the SQL Statement field that returns a single column. Identity Validator 2.0 uses the value from the first row returned. If your SELECT statement returns multiple columns and or rows, Identity Validator 2.0 uses the value in the first column of the first row.

  • Configure the JDBC Connector to work with Oracle:

    The following steps will work with any JDBC ‘thin’ client - on the Builder tab:

    1. Copy the correct jdbc thin client jar file to the lib/jars directory. If it has a .zip extension, rename it to .jar.

    2. Create a new Connector by clicking the Add (plus sign) icon in the Connections Group.

    3. Select ‘JDBC Connector’ from the Connector Type drop-down.

    4. In the Connection Editor Section:

      1. Provide a Display Name for the Connector

      2. In the User name and Password fields, provide the user name and password of the database account to be used for authentication

      3. In the Driver field, provide the class name of the JDBC driver (Ex: ‘oracle.jdbc.driver.OracleDriver’)

      4. In the Url field, provide the jdbc connection string (Ex: ‘jdbc:oracle:thin:@172.17.2.146:1521:ORCL10G’)

    5. In the Connections Group, check the checkbox to the left of the new connection, and click the Test (play button) icon to test the new connection

  • Using a 3rd party JDBC Driver

    Place the JDBC Driver JAR in the lib/jars directory. If it has a .zip extension, rename it to .jar.

    Common JDBC Drivers:

    SQL Server (JTDS Driver option)

    SQL Server (MS SQL Server Driver option)

    MySQL

    Oracle 10G