User guide

Create a JDBC dispatcher in SQL/Services

Associate configuration and setup files

Start the JDBC dispatcher

See Chapter 7 Oracle SQL/Services and Oracle JDBC for Rdb Servers

for more

information on these operations.

Step 1 Decide on the versions of Rdb and JAVA

This step is basically the same as Step 2 Decide on the versions of Rdb and JAVA, as

covered in Sample Setup, Starting and Using an Oracle JDBC for Rdb thin server.

•

Step 2 Setup server-side configuration files and command procedures

For the server to start correctly a command procedure and a configuration file have to be

created.

The following two files must be created:

The Server Configuration file

The Server Setup file

You may use a XML configuration file to store the server definitions for you server. In

addition you should provide a command procedure to set up the Rdb and JAVA

environments correctly for

this server. This environment setup may also be done as part of the setup of dispatcher

environment in SQL/Services, but for the purpose of this example, we shall create our

own setup procedure.

Server Configuration File

As limited information can be passed to the server at the command line, most of the

server characteristics for a JDBC Dispatcher server can be placed in a configuration file.

See Configuration Files

for more information on what may be contained in the

configurations files and the format of the data within the file. Oracle recommends using

the XML-formatted form of the configuration files as it does allow greater flexibility of

option specification and allows more than one server definition to be defined in a single

configuration file.

During installation a generic configuration file RDBJDBCCFG.XML is copied to the

RDB$JDBC_HOME directory. You may use this file as a basis of your server

configuration file. The configuration file provides information to Oracle JDBC for Rdb

153