%META:TOPICPARENT{name="MultiTierInstallJDBCMac"}%
== <nop>OpenLink Generic JDBC Driver Installation and Configuration==
**Review Preinstallation Documentation:**  [[PreInstallJDBCClientOSX|Pre-Installation Requirements for Multi-Threaded Generic JDBC Driver (OSX)]]

=== Installation===

The  <nop>OpenLink Generic JDBC Driver for Mac OS X is distributed in a single disk image (.dmg) file, which contains a Macintosh Installer mpkg.

<BR><img src="%ATTACHURLPATH%/JDBC3_Dmgfile.png" style="wikiautogen"/>

Double-click the mpkg to start the installation process. 

<BR><img src="%ATTACHURLPATH%/JDBC3_MPKG.png" style="wikiautogen"/>

You will encounter a warning message that will ask you if you are sure that you want to install the software click to continue.

<BR><img src="%ATTACHURLPATH%/JDBC3_Warning.png" style="wikiautogen"/>

The installer will display a **Welcome** message. Click "Continue."

<BR><img src="%ATTACHURLPATH%/JDBC3_Welcome.png" style="wikiautogen"/>

The next screen will display the **Read Me** file, including any last- minute updates to these documents. Please read carefully and click "Continue" when finished.

<BR><img src="%ATTACHURLPATH%/JDBC3_Readme.png" style="wikiautogen"/>

The next screen will display the **License Agreement** for the  <nop>OpenLink Generic JDBC Driver. Please read and click "Continue."

<BR><img src="%ATTACHURLPATH%/JDBC3_Agreement.png" style="wikiautogen"/>

You will be prompted to "Agree" to continue the installation or "Disagree" to abort.

<BR><img src="%ATTACHURLPATH%/JDBC3_Agree.png" style="wikiautogen"/>

You will be asked to select a Destination Volume. Generally, this should be your Mac OS X boot volume. Click on the desired disk icon and then click "Continue."

<BR><img src="%ATTACHURLPATH%/JDBC3_Destination.png" style="wikiautogen"/>

You may now choose the Easy Install, or if you are an experienced user, you may Customize which components are installed.  <nop>OpenLink  generally recommends the Easy Install.

If you have installed  <nop>OpenLink  or iODBC components in the past, click "Upgrade" to continue. Otherwise, click "Install."

<BR><img src="%ATTACHURLPATH%/JDBC3_Easyinstall.png" style="wikiautogen"/>

If you chose the custom option, select which of the following components to install.

<BR><img src="%ATTACHURLPATH%/JDBC3_Custominstall.png" style="wikiautogen"/>

You must have an Administration username and password to install the  <nop>OpenLink  driver. Enter your Mac OS X Username and Password.

<BR><img src="%ATTACHURLPATH%/JDBC3_Authenticate.png" style="wikiautogen"/>

When the process is complete, you will be told that the software was successfully installed. Click "Close" and your new database driver is ready for use.

<BR><img src="%ATTACHURLPATH%/JDBC3_Success.png" style="wikiautogen"/>


=== Configuration ===

The <nop>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.

**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] }}}


Here is a description of each of the parameters: 

* **Hostname** - Network Alias or IP address of machine that runs an <nop>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 <nop>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** - (also 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 resultset. 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 [[MTServerConfigConnectOptions|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 <nop>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.

**Examples**: 


{{{jdbc:openlink://localhost:5000/SVT=Ingres II/DATABASE=iidbdb/UID=ingres/PWD=ingres}}} %BR%

{{{jdbc:openlink://192.128.13.119:5000/SVT=Oracle 8.1.x/DATABASE=ORCL/UID=scott/PWD=tiger}}} %BR%

{{{jdbc:openlink://saturn:5000/SVT=Progress 91D/DATABASE=isports/OPTIONS=-S isports -N tcp -H saturn}}} %BR%

{{{jdbc:openlink://localhost:5000/SVT=SQLServer 2000/DATABASE=Northwind/UID=sa/OPTIONS= -S SATURN}}} %BR%