User guide

Chapter 7
Oracle SQL/Services and Oracle JDBC for
Rdb Servers
The Oracle SQL/Services management command line may be used to start and stop servers
using the new dispatcher protocol called JDBC available in Oracle SQL/Services V7.1.6 and
later.
Currently the Oracle SQL/Services interface to Oracle JDBC for Rdb Servers is minimal and
may only be used to start and stop a JDBC dispatcher which in turn will start or stop the
associated Oracle JDBC for Rdb server.
1. Create an SQL/Services Dispatcher with the protocol JDBC. See Creating an Oracle
SQL/Services JDBC Dispatcher.
2. Associate the JDBC Dispatcher with an Oracle JDBC for Rdb server. See Associating
an Oracle SQL/Services JDBC Dispatcher to a Server
3. Start the JDBC dispatcher. See Starting a JDBC Dispatcher
The following sections show how these determinations are carried out.
A1.3 Sample Setup, Starting an Oracle JDBC for Rdb thin server from Oracle SQL/Services.
provides a working example on creating a JDBC dispatcher and its server associations.
7.1 JDBC Dispatcher
A new SQL/Services dispatcher protocol of JDBC was introduced in V7.1.6 of Oracle
SQL/Services. This dispatcher type allows you to create JDBC dispatchers that may be
associated with Oracle JDBC for Rdb servers.
Starting an Oracle JDBC for Rdb server using Oracle SQL/Services involves the following
steps:
In order for the dispatcher to start a server, the dispatcher must determine the name and type
of the server as well as the command procedures and configuration files to use during startup.
7.1.1 Creating an Oracle SQL/Services JDBC Dispatcher
95