Jump to: navigation, search

Example Values for Database Connection Parameters

During the installation of the Genesys Rules Authoring Tool, you will be prompted to enter various connection parameters for the database you are using as the Rules Repository (created in Creating the Rules Repository Database).

The table below provides some example values for the three supported database types (MSSQL, Oracle, and DB2). Note that these values are examples only, and you must consult your database vendor’s documentation for specific information. The last column in the table lists the JDBC drivers that you must to copy to the lib directory of your application server.

Database Type

Example Connector Class

Example Database URL

JDBC Driver to be Copied

MSSQL com.microsoft.sqlserver.

jdbc.SQLServerDriver

jdbc:sqlserver://example.com:1433;databaseName=GRS_db

where example.com is the MS SQL host, and GRS_db is the database name

sqljdbc.jar
Oracle oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@//example.com:1521/orcl

where example.com is the Oracle database host, and orcl is the database instance (SID)

ojdbc14.jar

ojdbc14_g.jar ojdbc14dms_g.jar ojdbc6_g.jar

DB2 com.ibm.db2.jcc.DB2Driver jdbc:db2://192.168.10.10:50000/GRS_db

where 192.168.10.10 is the DB2 host, and GRS_db is the database name

db2jcc.jar db2jcc_license_cu.jar
This page was last modified on June 25, 2013, at 01:12.

Feedback

Comment on this article:

blog comments powered by Disqus