sqlJDBCDriverClass

The sqlJDBCDriverClass build descriptor option is used for the following two purposes:
  • Specifies a driver class that is used to connect to a database during generation-time validation of SQL statements when you generate either COBOL or Java code using the EGL SDK and set the validateSQLStatements build descriptor option to YES. You specify the location of the database by setting the sqlValidationConnectionURL build descriptor option. Database access is through JDBC.
    Note:
    When you generate either COBOL or Java code using the workbench, EGL uses the database connection currently specified in the EGL Preferences. See the section on setting preferences in the EGL Programmer's Guide for information on setting EGL preferences.
  • Specifies a driver class to use when accessing the database at run time when you generate Java code. If you set the sqlJDBCDriverClass build descriptor option, it assigns a value to the vgj.jdbc.drivers Java runtime property in the program properties file, but only if the following conditions are both true:
    • The genProperties build descriptor option is set to GLOBAL or PROGRAM.
    • The j2ee build descriptor option is set to NO.
There is no default value. The format for the value varies by driver:
  • For the IBM® DB2® Universal Driver for Windows, the driver class is as follows (with com in lower case):
      com.ibm.db2.jcc.DB2Driver
  • For the IBM® DB2® App Driver for Windows, the driver class is as follows:
      COM.ibm.db2.jdbc.app.DB2Driver
  • For the Oracle JDBC thin client-side driver, the driver class is as follows:
      oracle.jdbc.driver.OracleDriver
  • For the IBM® Informix® JDBC driver, the driver class is as follows:
      com.informix.jdbc.IfxDriver
  • For the Apache Derby driver, the driver class is as follows:
      org.apache.derby.jdbc.EmbeddedDriver
  • For the Cloudscape® driver, the driver class is as follows:
      com.ibm.db2j.jdbc.DB2Driver
  • For the SQL Server 2000 driver, the driver class is as follows:
      com.microsoft.sqlserver.jdbc.SQLServerDriver
  • For the SQL Server 2005 driver, the driver class is as follows:
      com.microsoft.jdbc.sqlserver.SQLServerDriver

For other driver classes, see the documentation for the driver.

To specify more than one driver class, separate each class name from the next with a semi-colon ";" You might do this if one Java program makes a local call to another but accesses a different database management system.