Adding a New DB Driver

To add a DB driver, press the F6 key from the Work with DB Drivers screen (STRDB > 11). The Add DB Driver screen appears:

​                              ​ Add New DB Driver​                                                                                                                  ​ Driver . . . . .​ ​           ​                                                    ​ Driver file  . .​ ​                                                             ​                    ​                                                             ​  ​ Class  . . . . .​ ​                                                             ​  ​                  ​                                                             ​  ​ Driver page  . .​ ​                                                             ​                    ​                                                             ​  ​ Default port . .​ ​      ​                                                         ​ Additional parms​ ​ Label​               ​ Possible values​                          ​ Parm 1 . .<adl1>​ ​                     ​                               ​           ​ Parm 2 . .<adl2>​ ​                     ​                               ​           ​ Parm 3 . .<adl3>​ ​                     ​                               ​           ​ Parm 4 . .<adl4>​ ​                     ​                               ​           ​ URL dft schema .​ ​                                                             ​  ​ Std replacement:​ ​                                                             ​  ​ <host><db>      ​ ​                                                             ​  ​ <catalog><port> ​ ​                                                             ​  ​ <schema><adl1-4>​ ​                                                             ​                                                                                   ​ F3=Exit​  ​ F4=Prompt​  ​ F7=Driver page​  ​ F9=Restore Default​          ​ F12=Cancel​  ​                                                                                                                                                                  ​

The screen contains these fields:

Driver

The driver name and a free-form text description, as they appear on the Work with DB Drivers screen.

Driver file

The path to the jar file on the IFS that contains the JDBC driver for this database. This can be either an absolute path, beginning with the "/" character, or relative to the default path, /iSecurity/DB‑Gate/Drivers

Class

The JDBC driver class name.

Driver page

The URL of the web page for driver information on the developer's web site.

Default port

The default port to use in setting up a connection.

Additional parms

Up to four additional parameters that can be specified in connecting to the database, as in the URL dft schema field. For each, you can specify a Label and a free-form description of Possible values. The four parameters are referenced by the strings <adl1> through <adl4>.

URL dft schema

The default schema used in connecting to the database. The schema can automatically substitute the values of the variables <host>, <db>, <catalog>, <port>, <schema>, and the four parameters specified in the Additional parms field.

In the example value, jdbc:firebirdsql://<host>:<port>/<adl1>, the host name, port, and "file" value specified in the first additional parameter would be included in the schema when it is used.

After you complete the fields, press Enter. A confirmation message appears asking if you want to modify any of the entries. Press Enter again to save the new DB driver.