Understanding how a standard JDBC connection is made

A standard JDBC connection is created for you at run time if you are debugging a generated Java™ program and if the program properties file includes the necessary values.

The JDBC connection is based on the following kinds of information:

Connection URL

If your code tries to access a database before invoking the sysLib.connect or vgLib.connectionService system function, the connection URL is the value of the vgj.jdbc.default.database property.

If your code tries to access a database in response to an invocation of the sysLib.connect or vgLib.connectionService system function, the connection URL is the value of the vgj.jdbc.databaseSN property.

For details on the format of a connection URL, see sqlValidationConnectionURL.

User ID

If your code tries to access a database before invoking the sysLib.connect or vgLib.connectionService system function, the user ID is the value of the vgj.jdbc.default.userid property.

If your code tries to access a database in response to an invocation of one of those system functions, the user ID is a value specified in the invocation.

Password

If your code tries to access a database before invoking the sysLib.connect or vgLib.connectionService system function, the password is the value of the vgj.jdbc.default.password property.

If your code tries to access a database in response to an invocation of one of those system functions, the password is a value specified in the invocation. You can use a system function to avoid exposing the password in the program properties file.

JDBC driver class

The JDBC driver class is the value of the vgj.jdbc.drivers property.