sqlJNDIName

The sqlJNDIName build descriptor option specifies the default database used by a generated Java program that runs in J2EE. To set the value, use the name in the JNDI registry to which the default data source is bound; for example, jdbc/MyDB.

The sqlJNDIName build descriptor option is case-sensitive, has no default value, and is used only when you are generating a Java program for J2EE. The option assigns a value to the vgj.jdbc.default.database Java runtime property, but only if the genProperties build descriptor option is set to GLOBAL or PROGRAM. This runtime property is stored in the J2EE deployment descriptor.

If you set the validateSQLStatements build descriptor option to YES, the location of the database used for generation-time validation of the SQL statements is determined in the following manner:
  • If you are generating in the workbench, EGL uses the connection currently specified in the EGL Preferences. You can find those preference settings by following these steps:
    1. Open the Preferences window by clicking Window > Preferences.
    2. On the left side of the Preferences window, expand EGL and click SQL Database Connections.
    3. Under Connection details, fill in the connection information in the field, or click New to use the wizard to set up a new connection.
  • If you are using the EGL SDK, EGL uses the sqlJDBCDriverClass and sqlValidationConnectionURL build descriptor options.

To specify the database name for a non-J2EE program, set the sqlDB build descriptor option.