text
|
-
Download the OpenLink Generic JDBC Driver for Mac OS X, which comes in a .dmg file.
-
Double-click the .dmg file to start the installation process.
-
Confirm the warning message to proceed with the installation.
-
Read and accept the License Agreement for the OpenLink Generic JDBC Driver.
-
Choose the destination volume for the installation (typically your Mac OS X boot volume).
-
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."
-
If you chose the custom installation option, select the desired components to install.
-
Click Next.
-
Enter your Mac OS X Username and Password when prompted to complete the installation.
-
After installation, your database driver is ready for use.
-
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.
-
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
-
Download the OpenLink Generic JDBC Driver for macOS, which comes in a .dmg file.
-
Double-click the .dmg file to start the installation process.
-
Confirm the warning message to proceed with the installation.
-
Read and accept the License Agreement for the OpenLink Generic JDBC Driver.
-
Choose the destination volume for the installation (typically your macOS boot volume).
-
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."
-
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.
-
After installation, your database driver is ready for use.
-
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.
-
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
-
Download the OpenLink Generic JDBC Driver for macOS, which comes in a .dmg file.
-
Double-click the .dmg file to start the installation process.
-
Confirm the warning message to proceed with the installation.
-
Read and accept the License Agreement for the OpenLink Generic JDBC Driver.
-
Choose the destination volume for the installation (typically your macOS boot volume).
-
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."
-
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.
-
After installation, your database driver is ready for use.
-
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.
-
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
|