Jump to: navigation, search

Configure DAP Connection Parameters/JDBC Drivers

Enter these parameters in the DAP as described in Creating the Rules Repository Database).

Default Values

Important
You should consult your database vendor’s documentation for specific information. Choose the most current version of the JDBC driver that supports your operating system and Java version. The JDBC driver(s) must be copied to the lib directory of your application server. Typical examples are shown in the table.

Database Type

Connector Class

Default Database URL

Example JDBC Driver to be Copied
(see note above)

MSSQL com.microsoft.sqlserver.
jdbc.SQLServerDriver
jdbc:jtds:sqlserver://{host}:{port};
databaseName={database_name}
sqljdbc42.jar
Oracle oracle.jdbc.driver.
OracleDriver
jdbc:oracle:thin:
@//{host}:{port}/{SID}
ojdbc6.jar
DB2 com.ibm.db2.jcc.
DB2Driver
jdbc:db2://{host}:{port}
/{database_name}
db2jcc.jar
db2jcc_license_cu.jar
PostGRE SQL org.postgresql.
Driver
"jdbc:postgresql://{host}:{port}
/databaseName"
postgresql-9.3-1102.
jdbc41.jar

Overriding Default Values on the Options Tab

More advanced users can use the DAP's Options tab to override the default values mentioned above; for example, if a database vendor makes changes to the JDBC driver class, or if additional options need to be specified on the DB URL. Note that this is very rarely needed—entering the parameter during DAP configuration is almost always sufficient.

If the GRS section is present, the value of any options specified here overrides the defaults generated by GRAT.

Procedure

  1. On the Options tab, create a section called GRS.
  2. Use the URL field to override the URL value generated by GRAT.
  3. Use the Driver field to override the default driver value generated by GRAT.
This page was last modified on August 30, 2019, at 12:57.

Feedback

Comment on this article:

blog comments powered by Disqus