Using the Client on Windows › Configuring JDBC Applications to Use CA IDMS Server

Configuring JDBC Applications to Use CA IDMS Server

JDBC-enabled applications running on Windows must be able to find the CA IDMS Server executable files, which include both Java classes and native DLLs. Both the startup executable for the Java VM and the native SQL client interface DLLs are installed in the WINDOWS\SYSTEM32 directory, and are always effectively in the PATH. The CLASSPATH must point to idmsjdbc.jar, which is installed in the \Program Files\CA\IDMS Server\Java\lib directory. The sample batch files set this. It is also useful to include a classes subdirectory, such as the \Program Files\CA\IDMS Server\Java\classes, for the caidms.properties file and any updated class files provided by Technical Support.

When running standalone Java applications, the SSL keystore file must be specified to the Java VM. When running Java applications in application servers such as Websphere or Weblogic, see the vendor's documentation on how to specify the keystore file.

Applications can connect to a database using the JDBC DriverManager class with a URL or using a JNDI server with an IdmsDataSource object.

For an applet to use the JDBC driver, the classes must be accessible to web pages accessed from the web server, and the subdirectory containing idmsjdbc.jar should be defined to the web server. For the Microsoft IIS, define a virtual directory pointing to this directory.