D Bundled JDBC Drivers

Learn about the JDBC drivers that are bundled with the Oracle Audit Vault and Database Firewall (Oracle AVDF) SDK.

• About Bundled JDBC Drivers
  Learn about the five JDBC drivers that are bundled with Oracle Audit Vault and Database Firewall.

D.1 About Bundled JDBC Drivers

Learn about the five JDBC drivers that are bundled with Oracle Audit Vault and Database Firewall.

When you create a collection plug-in, you can use it to extract audit records from a database table. To do this, you must have a JDBC driver to connect to the database. Drivers for most common databases are bundled with the SDK.

The Oracle AVDF SDK ships with 5 different JDBC drivers, some that are standard to the product and some that are proprietary drivers provided by Oracle for specific third-party databases.

• Standard

  • Oracle

  • MySQL

• Proprietary

  • Sybase

  • Microsoft SQL Server

  • DB2

You are not required to use any of these JDBC drivers. You can use drivers that you have acquired elsewhere. However, if you plan to use any of the listed drivers, then in your mapper file, and when registering a secured target, you must provide the information in the following table:

Table D-1 JDBC Drivers and Connecting URLs

Database	Driver Class	Connecting URL
Oracle	oracle.jdbc.pool.OracleDataSource	jdbc:oracle:thin:@host:port:sid
MySQL	N/A	jdbc:av:mysql://host:port
SQLServer	oracle.av.platform.jdbcx.sqlserver.SQLServerDataSource	jdbc:av:sqlserver://host:port
DB2	oracle.av.platform.jdbcx.db2.DB2DataSource	jdbc:av:db2://host:port/dbname
Sybase	oracle.av.platform.jdbcx.sybase.SybaseDataSource	jdbc:av:sybase://host:port

• Connecting URLs
  Use the correct Connection URL for the type of JDBC driver that you use with Oracle Audit Vault and Database Firewall.
• DataSource Class
  To enable a Java application to interact with the Oracle Audit Vault platform, use this JDBC DataSource class.

D.1.1 Connecting URLs

Use the correct Connection URL for the type of JDBC driver that you use with Oracle Audit Vault and Database Firewall.

You use Connection URLs to specify the location of a database Secured Target when you register the Secured Target on the GUI or through AVCLI. The format of the Connection URL depends on the JDBC driver that you use. Each of the JDBC drivers shipped with Oracle Audit Vault and Database Firewall specifies the format required by the JDBC driver in question in the table in "About JDBC Drivers and Connecting URLs." .

Additionally, to use specific encryption methods in the connecting URL, you must set the EncryptionMethod property. In the following syntax example, note that the variable encryptionmethod can be SSL, requestSSL, or loginSSL:

jdbc:av:[sqlserver]://hostname: port;[EncryptionMethod=encryptionmethod].

Use this url to register a Secured Target, by entering it into the Secured Target Location field, with the Advanced mode selected.

See Also:

Secured Target Connection Information block in "Creating a Database Table Mapping File. Creating a Database Table Mapper File.

D.1.2 DataSource Class

To enable a Java application to interact with the Oracle Audit Vault platform, use this JDBC DataSource class.

oracle.av.platform.jdbcx.dbsource.DBSourceDataSource