Using the Java Client on Any Platform › Using the JDBC Driver

Using the JDBC Driver

Applications, application servers, and servlets running on platforms other than Windows or z/OS can use the JDBC driver to communicate with a CA IDMS system. CA IDMS Server need not be installed or configured on these platforms. No native methods are used. The JDBC driver uses TCP/IP to communicate directly with the JDBC server running on Windows or z/OS, or directly to CA IDMS r16 SP2 or later. The JDBC server does not need to run on the application platform.

Configuration settings are specified in the caidms.properties file, because the native configuration file is not available. Trace information can be written to a container managed DataSource log or to a file specified in the properties file.

To use the JDBC driver on other platforms

1. Extract or copy the JDBC driver, idmsjdbc.jar, to the client machine. For example, on UNIX, assuming you have copied the archive idmsjdbc.tar to the /classes directory:

   cd /classes
   tar -xovf idmsjdbc.tar idmsjdbc.jar
   

2. Update the CLASSPATH environment variable to point to the JDBC driver directory and Java archive file.

   For example, on Windows:

   set CLASSPATH=c:\classes;c:\classes\idmsjdbc.jar;%CLASSPATH%
   

   On UNIX:

   set CLASSPATH=/classes:/classes/idmsjdbc.jar:$CLASSPATH
   

   Note: J2EE application servers have various ways of defining JDBC drivers and specifying how to access the driver jar file. Consult the documentation provided with the application server for details.

3. Specify the system where the JDBC server or CA IDMS r16 SP2 or later is running as part of the URL or the data source object used to connect to the database. For example:

   jdbc:idms://hostname/datasource
   

Note: For more information about the URL format, the Connection Parameters, and IDMS Data Source definition, see the chapter "JDBC Programmer Reference."