Not logged in : Login
(Sponging disallowed)

About: Installation of the Multi-Tier "Enterprise" Edition Generic Client JDBC Drivers, on macOS Operating Systems     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : schema:HowTo, within Data Space : data.openlinksw.com associated with source document(s)
QRcode icon
http://data.openlinksw.com/describe/?url=http%3A%2F%2Fdata.openlinksw.com%2Foplweb%2Fuda%2Fhowto%2FMacOSXMulti-TierGenericJDBCDriverInstallationGuide%23this

Installation of the Multi-Tier "Enterprise" Edition Generic Client JDBC Drivers, on macOS Operating Systems

AttributesValues
description
  • Installation of the Multi-Tier "Enterprise" Edition Generic Client JDBC Drivers, on macOS Operating Systems
described by
title
  • Installation of the Multi-Tier "Enterprise" Edition Generic Client JDBC Drivers, on macOS Operating Systems
hasOperatingSystemFamily
category
  • Installation Guide
relatedLink
text
    1. Download the OpenLink Generic JDBC Driver for Mac OS X, 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 Mac OS X 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 Mac OS X 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
    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
    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
type
schema:step
is topic of
is about of
is schema:mainEntity of
Faceted Search & Find service v1.17_git122 as of Jan 03 2023


Alternative Linked Data Documents: iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3330 as of Apr 5 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (30 GB total memory, 28 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software