User guide

default, this file will be used by the dispatcher whenever a server has to be started. JDBC
Dispatcher Setup Procedure describes the use of a setup command procedure for the
dispatcher.
Example
$type RDB$JDBC_COM:RDBJDBC_SQS_ONSTARTUP.COM
$@SYS$LIBRARY:RDB$SETVER 72
$@sys$common:[java$142.com]JAVA$142_SETUP.COM
FAST
$define/job MY_DB_DIR sys$common:[DBS]
These commands ensure that the environment is correct for the server process to access a
V7.2 Oracle Rdb database using FAST JAVA VM.
Step 3. Create a JDBC dispatcher in SQL/Services
Now that the configuration file and setu0p procedure have been created and moved to the
appropriate directory we can now create a JDBC Dispatcher. We will use 1888 as the
PORT_ID as this will be the key value used by the dispatcher to locate the necessary files
for server start-up.
$ MCR SQLSRV_MANAGE71
SQLSRV> CONNECT SERVER;
SQLSRV> CREATE DISPATCHER MY_JDBC_DISP NETWORK_PORT TCPIP PORT_ID 1888
PROTOCOL JDBC;
SQLSRV> SHOW DISPATCHER;
Dispatcher MY_JDBC_DISP
State: UNKNOWN
Autostart: on
Max connects: 100 clients
Idle User Timeout: <none>
Max client buffer size: 5000 bytes
Network Ports: (State) (Protocol)
TCP/IP port 1888 Unknown JDBC clients
Log path: SYS$MANAGER:
Dump path: SYS$MANAGER:
Step 4. Associate configuration and setup files
Next we must associate the server configuration and setup files with this dispatcher.
As we chose to use standard configuration file names, the dispatcher will make the
following associations automatically and we need take no further action to make this
happen.
156