If you are connecting to a relational database at run time, you
need to
define a data source for use with your program. If you are using WebSphere® Application Server,
the directions are in the help system of the administrative console.
If you
are using another supported J2EE server, check the documentation for
your
server for instructions on defining the data source.
When you
define a data source, assign values to the following properties:
- JNDI name
- Specify a value that matches the name
to which the database is bound in
the JNDI registry:
- If you are defining a data source which
connects to a database that your
J2EE module uses by default, make sure that the JNDI name specified
in the
data source definition matches the value of the vgj.jdbc.default.database property
in the J2EE deployment descriptor used at run time
- If you
are defining a data source that will be accessed when the system
function vgLib.connectionService runs, make sure that the JNDI name
specified
in the data source definition matches the value of the appropriate vgj.jdbc.database.SN property
in the J2EE deployment descriptor used at run time
- Database name
- Specify the name of your
database, as known to the database management
system
- User ID
- Specify the user
name for connecting to the database.
If the data source
definition refers to the default database, the value you specify in
the User
ID field is overridden by any value set in the vgj.jdbc.default.userid property
of the J2EE deployment descriptor used at run time, but only if you
have specified
values for both vgj.jdbc.default.userid and vgj.jdbc.default.password.
Similarly, if the data source definition refers to a database that
is accessed
by way of the sysLib.connect or vgLib.connectionService system
functions, the value you specify in the User ID field is overridden
by any
user ID that you specify in the call to that system function, but
only if
the call passes both a user ID and password.
You specify the
name when
setting up the authentication alias. To reach the display where you
can define
that alias, follow this sequence in the Administrative Console:.
- Password
- Specify the password for connecting
to the database. If the data source
definition refers to the default database, the value you specify in
the Password
field is overridden by any value set in the vgj.jdbc.default.password property
of the J2EE deployment descriptor used at run time, but only you have
specified
values for both vgj.jdbc.default.userid and vgj.jdbc.default.password.
Similarly, if the data source definition refers to a database that
is accessed
by way of the vgLib.connectionService system
function,
the value you specify in the Password field is overridden by any password
that you specify in the call to that system function, but only if
the call
passes both a user ID and password.
You specify the password when
setting
up the authentication alias. To reach the display where you can define
that
alias, follow this sequence in the Administrative Console: .
You may define multiple data sources, in
which case you use the system
function vgLib.connectionService to switch between them.