Field

Description

DIP ID

The name of the DIP.

Values: DBDIP1, DBDIP2, DBDIP3, DBDIP4, DBDIP5, CDH

This is a value set by the system.

The port number the DIP is listening on (default)

The LAN port monitored by the DIP.

Values: 0-65535

This field is required.

Database type

The type of database you want to use.

Values: Oracle, Sybase, IBM DB2, Informix, Microsoft SQL Server, or Custom.

DB username

The username used to access the database.

Values: Any string

This field is required.

DB password

The password used to access the database.

Values: Any string.

This field is required.

Classname

The Java classname for the driver, such as com.microsoft.jdbc.sqlserver.SQLServerDriver.

This field is required.

Database URL

Enter the URL that the Avaya IR system uses to connect to the database, such as jdbc:microsoft:sqlserver://domain_name:1433;databaseName=yourdatabasename where domain_name is the domain name for the MS SQL Server 2000 server, and yourdatabasename is the filename of the database.

This field is required.

Additional properties

This field can be left blank.

Connection Pool Size

The maximum anticipated number of concurrent JDBC connections that the Avaya IR system will use.

Values: 1-200

Recommended Values:
5-10 (for the Sun Blade 150 )
5-20 (for the Sun Fire V240 or 280R)

This field is required.

Database subtype

The database type that matches the JDBC drivers you are using.

Check connection SQL query

This field displays when the Database subtype is set to other.

Enter a simple SQL query that will be used to test that the database connection is working properly when the database DIP is running.

Button

Description

Main

Displays the JDBC Administration - Main screen.

Save

Saves the DIP configuration and displays the JDBC Administration - Main screen.

Test

Tests the DIP and displays the DB Dip test screen.

Delete

Deletes the DIP configuration.