Previous Topic: Editing the Configuration FileNext Topic: Configuring the JDBC Server


Data Source Definitions

A JDBC-enabled application can connect to a CA IDMS database using the DriverManager class with a URL or using JNDI with an IdmsDataSource object. Either technique can reference a data source name similar to an ODBC data source. This DSN is defined in the configuration file, where it is associated with the dictionary name of the catalog defining the SQL schema, a node name identifying the CA IDMS system, and other optional information.

The following sample illustrates a data source definition defined in the configuration file:

[APPLDICT]
Dictionary=APPLDICT
Server=SYST0001

[Server SYST0001]
Resource=SYST0001
AlternateTask=CASERVER

This syntax lets you use meaningful names for the data source and server names. Using an explicit server section lets you specify optional information for a CA IDMS system. When using all default values, this is equivalent to the following minimal data source definition:

[APPLDICT]
Server=SYST0001

Bracket characters "[" and "]" may be difficult to use on 3270 terminals or emulators. The dollar character "$" can be used as a substitute as seen in the following example:

$APPLDICT$
Server=SYST0001

You can also specify this information using DriverPropertyInfo objects or in the IdmsDataSource itself, instead of in the configuration file.

Note: For a complete description of the connection information, see the chapter "JDBC Programmer Reference."