Adding, editing, and deleting a database driver

Clicking Configure Database Drivers on the Database Configurations tab opens the Configure Database Drivers dialog box.

From this dialog box, you can insert, delete, and update a database configuration.

The Database menu lists all stored database configurations. By default, the selected database is the same as the one shown on the Database Configurations tab. Changing a selection updates all other component values according to the selected database.

  1. On the Configure Database Drivers dialog box, click New or Edit to add or edit a database driver.
  2. Specify the parameters on the resulting Add New/Edit Database Driver dialog box.
    Click Open next to Driver File Path to open a file browser where you can select the relevant JDBC driver jar file. This sets the jar file’s full path in Driver File Path. This browser only supports jar file selection and permits browsing under $HCIROOT. The default location is $HCIROOT\clgui\lib.
    For the predefined SQL Server and Oracle databases, the default value of Driver File Path must be available after installation. The default location for driver jar files is $HCIROOT\clgui\lib\jdbc_jar_file.
    Click OK to add/update the database connection configuration.
  3. All modified database configurations are saved when OK is clicked on theDatabase Configurations tab. This action also updates the Database menu on the main tab. Database driver configurations are stored at $HCIROOT\server\database.ini.

    By default, it predefines these configuration entries:

    [sqlite]
    driver_class=org.sqlite.JDBC
    driver_file=<HCIROOT>\clgui\lib\sqlite-jdbc.jar
    url_format=jdbc:sqlite:<databse file name>
    ...
    [SQL Server]
    driver_class=com.microsoft.sqlserver.jdbc.SQLServerDriver
    driver_file= <HCIROOT>\clgui\lib\ sqljdbc4.jar
    url_format= jdbc:sqlserver://<server>:<port1433>;DatabaseName=<database>
    …
    [Oracle]
    driver_class=oracle.jdbc.OracleDriver
    driver_file= <HCIROOT>\clgui\lib\ojdbc7.jar
    url_format=jdbc:oracle:thin:@//<server>:<port1521>/<sid>
  4. After creating the database, if you must change any parameter, click Edit on the Database Configurations tab. The Edit Database Driver dialog box opens. In this dialog box, you can update the configuration of the selected driver.
  5. To delete the database, click Delete on the Database Driver Configurator dialog box. The IDE first checks whether any database connection is referring to the selected driver. If the driver is never referenced, then a confirmation message is displayed.