JDBC Driver Implementation and Configuration › JDBC Applications and the Windows Environment › JDBC Proxy and Windows

JDBC Proxy and Windows

The JDBC Proxy is installed as an optional item when the JDBC driver is installed and must be installed on the same machine as the web server.

The URL used by the applet identifies the address of the JDBC Proxy. An ODBC data source included in the URL must be a system data source to be recognized by the JDBC Proxy. You can start and stop the JDBC Proxy from the CA Datacom Server submenu, which you access from your Start menu.

The Windows version of the JDBC Proxy service wrapper, cadcjsrv.exe, is installed in the c:\Program Files\CA\CA DatacomServer\Java subdirectory. This version invokes the JVM using the Java command (as provided by the JRE or Java Development Kit (JDK) from Sun Microsystems). Configuration settings are maintained in the registry, and can be updated using the CA Datacom ODBC Administrator. Run the executable file, cadcjsrv.exe, using one of the following parameters:

cadcjsrv start

Starts the JDBC Proxy as a background process.

cadcjsrv stop

Stops the JDBC Proxy.

cadcjsrv suspend

Suspends the JDBC Proxy.

cadcjsrv resume

Resumes the JDBC Proxy.

cadcjsrv status

Checks the JDBC Proxy status.

cadcjsrv debug

Starts the JDBC Proxy as a foreground process.

cadcjsrv usage

Displays usage information.

More information:

Server and the z/OS Environment

DriverManager

JDBC Proxy Service Wrapper as a Windows Service

The JDBC Proxy Service wrapper is an optional component in the CA Datacom Server installation. You can download a self extracting zip file from CA Support and unzip the contents to the "Datacom installation folder\Java\Classes" folder. The zip file contains Jna.jar which is required by the Java classes in the cadcjdbc.jar which is used to install, run and, (if required) uninstall the service.

The JDBC Proxy is controlled using the cadcjsrv.exe wrapper. This executable is used to start, stop and check the status of the JDBC Proxy. With CA Datacom Server Version 14.0, you can start and stop the JDBC Proxy using a Windows service. Once installed, the Windows service can be used to control the JDBC Proxy instead of using the cadcjsrv.exe wrapper. The Windows service is accessed the same way other Windows services are accessed, through the Control Panel -> Administrative Tools -> Services application.

Important! The JDBC Proxy Service wrapper as a Windows Service will not work on Itanium machines, as JNA does not support Windows on Itanium.

Using the JDBC Proxy Service Windows Service Wrapper

This section describes how to use the CA Datacom Proxy wrapper when it is installed as a Windows service.

Requirements

• JRE 6 – Java Runtime 6 needs to be installed on the machine.
• jna.jar – provides access to native libraries from Java programs.
• cadcjdbc.jar – contains the CA Datacom JDBC driver and proxy classes.
• CLASSPATH – the system variable used by the Java programs. The jar file paths need to be appended to this variable.

Note: The CA Datacom Server installer adds these jar entries to the CLASSPATH variable during installation. The Proxy service wrapper as a Windows service does not work on Itanium machines because JNA doesn’t support Windows on an Itanium machine.

Installation

ProxyService is a Java program that is in cadcjdbc.jar. Using this Java program, you can install and uninstall one or more Proxy Service wrappers as Windows services on the same computer. Each Proxy Service wrapper must have a unique name and a unique port number.

The following arguments are accepted by the ProxyService program:

-install

Installs the Proxy Service wrapper.

-uninstall

Uninstalls the Proxy Service wrapper.

-name xxxx

(Optional) Assigns a name to the service. The default is DatacomProxyService.

-desc xxxx

(Optional) Writes the service description. The default is “CA DatacomProxyService Description”.

-port xxxx

(Optional) Changes the port number of the service. The default is 3909.

-help | help | /? | <none>

Prints out the arguments and their usage.

Operation

The Proxy Service wrapper (ProxyService.java) can be invoked from a command prompt.

Note: Make sure that cadcjdbc.jar and jna.jar are in the classpath.

The following command installs the Proxy Service wrapper with the default name and description:

CMD PROMPT\>java ca.datacom.proxy.proxyservice.ProxyService -install

The following command installs the Proxy Service wrapper with the name “AProxy”, description “A Proxy Service” and the JDBC Proxy runs on port 3999:

CMD PROMPT\>java ca.datacom.proxy.proxyservice.ProxyService -install -name “AProxy” -desc “A Proxy Service” -port 3999

The following command uninstalls the Proxy Service wrapper that is named “AProxy”.

CMD PROMPT\>java ca.datacom.proxy.proxyservice.ProxyService -uninstall -name “AProxy”

Note: The order of the arguments is not significant.

Using Windows Service Control Manager (SCM)

Windows SCM can be accessed through the Control Panel -> Administrative Tools -> Services. SCM lists all the services registered on that computer and shows their status. It also gives access to configure and control the services. If you have registered a Proxy Service wrapper, you can see it in the list of services displayed by SCM.

Parameters

In the SCM, you can control and configure the listed services. However, for the Proxy Service wrappers, the only parameter you can change is the port. This overrides all previous parameter values of port whether supplied through the “cadatacom.properties” file or through the command line when the service was registered.

Events

SCM logs information about all the services and their states. The Proxy Service wrapper logs its events to the default windows Application log. This log can be viewed through the Event Viewer available in the Control Panel -> Administrative Tools -> Event Viewer.

Note: Open the Application log to view all the logged messages, and double-click a particular log message to view it. Note that the log also mentions the proxy name, which is helpful if you have multiple Proxy Service wrappers.