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