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.
- 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.