User guide

5.2 SSL and the Controller......................................................................................................... 59
5.3 SSL Configuration Options.................................................................................................. 60
5.4 Using Self-Signed Certificates for Testing........................................................................... 61
Chapter 6 Oracle JDBC for Rdb Controller............................................................................................................63
6.1 Running the Controller ........................................................................................................ 66
6.1.2 Controller Command Line .......................................................................................... 69
6.2 Connecting to Servers.......................................................................................................... 74
6.2.1 Connect Command...................................................................................................... 75
6.2.2 Implicit Connection .................................................................................................... 76
6.3 Control Password ................................................................................................................76
6.4 Server Operations ................................................................................................................ 77
6.4.1 Closing Servers ........................................................................................................... 78
6.4.2 Opening Servers.......................................................................................................... 79
6.4.3 Showing Servers ......................................................................................................... 81
6.4.4 Starting Servers........................................................................................................... 83
6.4.5 Stopping Servers ......................................................................................................... 85
6.4.6 Watching Servers........................................................................................................ 87
6.4.7 Polling Servers............................................................................................................ 88
6.5 Client Operations................................................................................................................. 90
6.5.1 Showing Clients.......................................................................................................... 90
6.5.2 Stopping Clients.......................................................................................................... 91
Chapter 7 Oracle SQL/Services and Oracle JDBC for Rdb Servers .....................................................................95
7.1 JDBC Dispatcher.................................................................................................................95
7.1.1 Creating an Oracle SQL/Services JDBC Dispatcher .................................................. 95
7.1.2 Associating an Oracle SQL/Services JDBC Dispatcher to a Server........................... 96
7.1.3 Starting a JDBC Dispatcher...................................................................................... 102
7.1.4 Stopping a JDBC Dispatcher .................................................................................... 103
7.2 Command Procedures used by Oracle SQL/Services........................................................ 103
7.2.1 JDBC Dispatcher Setup Procedure ........................................................................... 104
7.3 Using Pool Servers ............................................................................................................ 105
Chapter 8 Other Features ........................................................................................................................................108
8.1 Anonymous Usernames...................................................................................................... 108
8.2 BYPASS Privilege .............................................................................................................. 108
8.2.1 BYPASS and Multi-Process servers......................................................................... 109
8.3 Persona .............................................................................................................................. 110
8.3.1 Persona and Server Operations ................................................................................. 110
8.4 Default Transaction ........................................................................................................... 111
8.5 Executor Sub-process used with the Rdb Native driver..................................................... 112
8.5.1 Setting Maximum Handshake Tries and Wait Duration........................................... 112
8.6 FetchSize............................................................................................................................ 113
4