User guide

7.3 Using Pool Servers
Each JDBC dispatcher defined is related only to a single server. Use a pool server if you
require more than one server to be started for a single dispatcher.
By defining a pool of servers that the pool server can use and enabling autoStart on each of
these servers, a whole pool of servers can be started by starting a single dispatcher. See
Pool Server Operation
for more information on pool servers.
The following example shows how you can define a dispatcher to start up a pool server that
will automatically start up three standard thin servers as part of its pool:
Note:
This example uses the default server naming, default server type of POOL and a standard
SQS_ONSTARTUP command procedure. No RDB$JDBC_SQS* logical names need be set
up.
Define an Oracle SQL/Services dispatcher
$ MCR SQLSRV_MANAGE71
SQLSRV> CONNECT SERVER;
SQLSRV> CREATE DISPATCHER POOL_DISP NETWORK_PORT TCPIP PORT_ID 1880
PROTOCOL JDBC;
Create a configuration file for this server in RDB$JDBC_COM:SQS1880_CFG.XML
<?xml version = '1.0'?>
<!-- Configuration file for Rdb Thin JDBC Drivers and Servers -->
<config>
<!-- SERVERS -->
<servers>
<!-- DEFAULT server characteristics-->
<server
name="DEFAULT"
type="RdbThinSrv"
url="//localhost:1880/"
maxClients="-1"
srv.bindTimeout="0"
srv.idleTimeout="0"
srv.mcBasePort="5520"
srv.mcGroupIP="239.192.1.10"
autoStart="false"
controlUser="jdbc_user"
controlPass="0x811B15F866179583EB3C96751585B843"
cfg="rdb$jdbc_com:sqlsrv_jdbc_server_cfg.xml"
srv.startup="rdb$jdbc_home:rdbjdbc_startsrv.com"
srv.onStartCmd="@rdb$jdbc_com:rdbjdbc_sqs_onstartup.com"
/>
<!-- now the servers that will be started up by pool server -->
<server
105