How To Install and Configure the Multi-Tier Edition JDBC Drivers for OpenLink Virtuoso (macOS)

There are no Server Components to Install

Configuration for Advanced Users (Click to Show)

There are no configuration guides available

Installation

1. Download the OpenLink Generic JDBC Driver for macOS, which comes in a .dmg file.
2. Double-click the .dmg file to start the installation process.
3. Confirm the warning message to proceed with the installation.
4. Read and accept the License Agreement for the OpenLink Generic JDBC Driver.
5. Choose the destination volume for the installation (typically your macOS boot volume).
6. Select the installation type:
   • Easy Install (recommended).
   • Custom Install (for experienced users who want to choose specific components).
     • If you have installed OpenLink or iODBC components in the past, select "Upgrade" to continue. Otherwise, click "Install."
7. If you chose the custom installation option, select the desired components to install.
   • Click Next.
   • Enter your macOS Username and Password when prompted to complete the installation.
8. After installation, your database driver is ready for use.
9. For configuring the OpenLink Generic JDBC Driver, use the following parameters in the Connection URL:
   • Driver Name: opljdbc3.jar, megathin3.jar
   • Driver Class Name: openlink.jdbc3.Driver
   • Connection URL: jdbc:openlink://<Hostname>:[portnumber] [/UID] [/PWD] [/READONLY] [/SVT] [/APPLICATION] [/FBS|FETCHBUFFERSIZE] [/ENCRYPTED] [/CHARSET] [/UNICODE] [/DLF] [/DATABASE] [/OPTIONS] [/DRIVER]
     • Description of Parameters:
     • Hostname: Network Alias or IP address of the machine running the OpenLink Request Broker instance.
     • Port Number: TCP port on which the Request Broker listens.
     • /UID: Database username.
     • /PWD: Database password.
     • /READONLY: Read-write or read-only session mode.
     • /SVT: A valid domain alias from the [Domain Aliases] section of the OpenLink server component's oplrqb.ini file. Default domain aliases represent the type of database agent to which the application intends to connect.
     • /APPLICATION: The Application name to enable connectivity when restrictive server-side rules screen by application name.
     • /FBS (or /FETCHBUFFERSIZE): The Fetch Buffer Size representing the number of rows to return during one fetch operation.
     • /ENCRYPTED: Sets the Encrypted flag for outgoing packets. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
     • /CHARSET: Specifies the charset of remote databases. Default value is read from System.getProperty("file.encoding").
     • /UNICODE: Instantiates unicode. The unicode connection isn't used by default. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
     • /DLF: Pushes large, binary objects to the end of the resultset. Smaller data types are retrieved first, enhancing performance. ('1', '0', 'Y', 'N', 'y', or 'n'. Disabled by default.)
     • /DATABASE: Actual database name within a particular database environment.
     • /OPTIONS: Optional parameter to pass specialized database native client connection parameters.
     • /DRIVER: The Driver name contained in curly brackets ({}). Used for DSN-Less connections to remote ODBC Drivers.
10. Examples of Connection URLs:
    • jdbc:openlink://localhost:5000/SVT=Ingres II/DATABASE=iidbdb/UID=ingres/PWD=ingres
    • jdbc:openlink://192.128.13.119:5000/SVT=Oracle 8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger
    • jdbc:openlink://saturn:5000/SVT=Progress 91D/DATABASE=isports/OPTIONS=-S isports -N tcp -H saturn
    • jdbc:openlink://localhost:5000/SVT=SQLServer 2000/DATABASE=Northwind/UID=sa/OPTIONS=-S SATURN

Configuration

1. The OpenLink installer should set your CLASSPATH. You should have a pre-existing JAVA_HOME directory that points to the root of your JAVA installation. No further configuration should be needed.
2. Driver Name: opljdbc3.jar, megathin3.jar
3. Driver Class Name: openlink.jdbc3.Driver
4. Connection URL: jdbc:openlink://<Hostname>:[portnumber] [/UID] [/PWD] [/READONLY] [/SVT] [/APPLICATION] [/FBS|FETCHBUFFERSIZE] [/ENCRYPTED] [/CHARSET] [/UNICODE] [/DLF] [/DATABASE] [/OPTIONS] [/DRIVER]
   • Hostname - Network Alias or IP address of the machine that runs an OpenLink Request Broker instance.
   • Port Number - TCP port on which the Request Broker listens.
   • /UID - Database username.
   • /PWD - Database password.
   • /READONLY - Read-write or read-only session mode.
   • /SVT - A valid domain alias from the [Domain Aliases] section of the OpenLink server component's oplrqb.ini file. Default domain aliases represent the type of database agent to which the application intends to connect, e.g., DB2, Informix 2000, Oracle 8.1.x. Custom aliases may take any form.
   • /APPLICATION - The Application name. Enables connectivity when restrictive server-side rules screen by application name.
   • /FBS (or /FETCHBUFFERSIZE) - The Fetch Buffer Size. The Fetch Buffer Size is an integer that represents the number of rows to return during one fetch operation.
   • /ENCRYPTED - Sets the Encrypted flag for outgoing packets. /ENCRYPTED may pass '1', '0', 'Y', 'N', 'y', or 'n'. (This feature is disabled by default.)
   • /CHARSET - Specifies the charset of remote databases. The default value is read from System.getProperty("file.encoding").
   • /UNICODE - Instantiates unicode. The unicode connection isn't used by default. The value may be '1', '0', 'Y', 'N', 'y', 'n' (This feature is disabled by default.)
   • /DLF - Pushes large, binary objects to the end of the result set. Smaller data types are retrieved first. This enhances performance. /DLF may be set to '1', '0', 'Y', 'N', 'y', or 'n'. (This feature is disabled by default.)
   • /DATABASE - Actual database name within a particular database environment.
   • /OPTIONS - Optional parameter that passes specialized database native client connection parameters. Do not use this parameter unless you need to pass Progress socket parameters or database native client parameters that enable a local OpenLink database agent to locate a remote database. Example parameters would be Oracle Net10 Service Names, Ingres vnodes, remote Informix instance names, or DB2 remote database aliases.
   • /DRIVER - The Driver name contained in curly brackets ({}). Used for DSN-Less connections to remote ODBC Drivers.
5. Examples of Connection URLs:
   • jdbc:openlink://localhost:5000/SVT=Ingres II/DATABASE=iidbdb/UID=ingres/PWD=ingres
   • jdbc:openlink://192.128.13.119:5000/SVT=Oracle 8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger
   • jdbc:openlink://saturn:5000/SVT=Progress 91D/DATABASE=isports/OPTIONS=-S isports -N tcp -H saturn
   • jdbc:openlink://localhost:5000/SVT=SQLServer 2000/DATABASE=Northwind/UID=sa/OPTIONS=-S SATURN