JDBC Connection Options Summary

As described in the previous sections, there are numerous ways to define CA IDMS Server connection information. Commonly used options are:

When using the JDBC driver with a Servlet, EJB, or other application running in an application server, all information can be defined in an IdmsDataSource, or more likely, an IdmsConnectionPoolDataSource or IdmsXADatasource object, and accessed using the container's JNDI implementation. It is not necessary to define an ODBC style data source.
When using the Type 2 JDBC driver in a standalone Java application on Windows or z/OS, a JNDI implementation is generally not available, and it is usually most convenient to reference an ODBC style data source in a CA IDMS URL, accessed using the DriverManager. The ODBC style data source is defined in the registry on Windows and the configuration file on the mainframe.
When using the Type 3 JDBC driver in an applet or standalone application that connects through the JDBC server, it is usually most convenient to reference an ODBC style data source defined on the machine where the JDBC server invokes the native client interface.