Database Configurations options

On the Database Configurations tab, you can add, update, and delete database connection settings.

The Database Connection menu lists all stored database connection configurations. Changing a selection updates all other component values according to the selected connection.

This table shows the available options when a database connection is selected and Edit or New is clicked.

The remainder of the fields are populated from the Add New Database Connection or Edit Database Connection dialog box.

When configuration is completed, clicking OK stores the connection properties in $HCISITE\dbconfiguration.ini.

This table shows the available options on both dialog boxes:
Option Description
Database Connection Specify a unique name for the connection. A duplicate name prompts an error message.
Database Connection Timeout Sets the maximum time in seconds that a driver waits when attempting to connect to a database after the driver has been identified.
Database Select a database type from the menu.
Database URL This defines the JDBC URL for the current connection. When a new database connection is added, Database URL must be in the same format as URL Format.

Default values are shown in this field. Values in red must be configured.

URL Format This shows an example of the JDBC connection URL for the selected database. You can refer to this when specifying the Database URL.

The default port for Oracle is 1521 and for SQL Server is 1433. These are used when specifying the Database URL.

User Name/Password These defines the valid user name/password with which to connect to the database.
Schema This sets the database schema for the current connection. This setting indicates that all the SQL Statements running in the current connection should be available under this schema.

Click List to open the Schema selection dialog box, from which you select an available database schema for the current connection.

This field is optional. For the oracle database, if schema is not set, the IDE uses User Name as the default schema.

When configuring a Database Inbound/Outbound protocol in Network Configurator, the schema must be listed for the table/view name in the SQL statement. This is only if the selected schema does not belong to the selected user.

If the listed schema in dbconnection.ini does not match the default schema in Schema, then this schema name must be used as the table name prefix in the SQL statement. This is the statement that is used in the Database Inbound/Outbound protocol.

For example, if the default schema that is shown on the Database Configurations tab for user1 is schema2, then the dbconnection.ini configuration is:

schema=schema1
userid=user1

On the SQL statement of the Database Inbound/Outbound protocol, schema1 must be placed as the prefix to tablename:

SELECT * FROM schema1.tablename
Note:  tablename is under the schema schema1 in the external database.

If schema1 is not identified in the SQL statement, then an invalid object 'tablename' error results.

SQL Statement

Specify SQL statements in this field. This field is optional. The default value is empty.

You can use multiple lines. These values are saved in the $HCISITE/dbconfiguration.ini file. Database Connection must have a selection before this can be saved.

Large Object Type

This property (largeobjecttype) identifies the implementation details of BLOB/CLOB in different databases.

Options are:

  • oracle
  • sqlserver
  • sqlite
  • postgresql

The default value for uncertified databases is oracle.

This option is only useful if it is another database, not Oracle, SQLServer, SQLite, or PostgreSQL.

If the database is one of these, then the option is not available, and is not required. Other databases are configurable.