RealSQLDriver

The Driver  interface interacts with the DriverManager. A client application should not call the methods in RealSQLDriver  directly, but should call them via the DriverManager  class. (The javadoc for the DriverManager  class can be found at http://java.sun.com/products/jdk/1.2/docs/api/java/sql/DriverManager.html

To establish a connection to a Reality database, an application calls one of the three DriverManager.getConnection()methods, supplying a unique URL in the format:

 jdbc:realsql://host{:port}/database{;key=value,key=value}

Where:

• host is the network name of the remote system.
• port  is the port number of the DDATCP listening port on the remote system. This is optional and if not supplied defaults to 1203.
• database  is the database name defined on the remote system. It can be found in the ROUTE-FILE on Unix or the Registry on Windows systems.

• key=value  may contain the following properties:

  - user  is the userid on the remote host and database
  - userpwd  is the user password on the remote host and database
  - account  is the Reality account where the SQL server will logon
  - accountpwd  is the Reality account password, if one exists
  - logLevel  defines the level of diagnostic information to be traced 
  - logOptions applies additional tracing information if required
  - logModules  controls which modules are traced
  - hostOption  defines server tracing if required
  - HostItemName  sets the item name in the Reality logfile SQLSRVLOG

  (for more information on the last five properties, see Diagnostics)

The key=value  pairs are defined as optional, but a connection will not be successful without at least a user-id, user password and account name.

The three getConnection()  methods in DriverManager  provide three alternative ways in which the properties can be supplied. The Connection Examples illustrate the three ways: Method A appends all of the information to the URL; Method B and the full Example Application build a java.util.Properties  object to pass the connection properties; Method C appends the account, account password and a logging property to the URL, then passes the URL, plus separate user and user password identifiers, to getConnection().

The request is packaged and forwarded to the RealSQLDriver.connect()  method. The connection URL is parsed and validated and a new Connection  object is created, at which point the connection to the database is established.