%META:TOPICPARENT{name="InstallConfigJDBC"}%
= Connection URLs for Type 1 JDBC Driver =

A Type 1 JDBC Driver connects ("bridges") JDBC client applications to ODBC Data Source Names (DSNs). 

//**Note 1:** You should generally have only one of the following in your <code>CLASSPATH</code> environment variable.  If you have multiple jars which use the same Classname, only the first found by the JVM (typically the first in your <code>CLASSPATH</code>) will be active.  Choose the one best matched to your active JVM.//

//**Note 2:** Our pure [[JDBC3ConnectionURLFormat|Type 3 JDBC Drivers]], filenames <code>megathin*.jar</code>, cannot be used for Type 1 connections, and must not be included in your active <code>CLASSPATH</code> alongside <code>opljdbc*.jar</code>.//
 
Our Type 1 JDBC Drivers have the following attributes --
|  <b>Java %BR% Version</b> |  <b>Compatible %BR% JVM/JRE/JDK</b> |  <b>JDBC %BR% Version</b> |  <b>Filename</b>            |  <b>Classname</b>                  |
|  Java 8                   |  1.8.x                              |  JDBC 4.2                 | <code>opljdbc4_2.jar</code> | <code>openlink.jdbc4.Driver</code> |
|  Java 7                   |  1.7.x                              |  JDBC 4.1                 | <code>opljdbc4_1.jar</code> | <code>openlink.jdbc4.Driver</code> |
|  Java 6                   |  1.6.x                              |  JDBC 4                   | <code>opljdbc4.jar</code>   | <code>openlink.jdbc4.Driver</code> |
|  Java 4 and 5             |  1.4.x and 1.5.x                    |  JDBC 3                   | <code>opljdbc3.jar</code>   | <code>openlink.jdbc3.Driver</code> |
|  Java 2 and 3             |  1.2.x and 1.3.x                    |  JDBC 2                   | <code>opljdbc2.jar</code>   | <code>openlink.jdbc2.Driver</code> |
|  Java 1                   |  1.1.x                              |  JDBC 1                   | <code>opljdbc.jar</code>    | <code>openlink.jdbc.Driver</code>  |


== Type 1 JDBC URL Syntax ==

Our Type 1 JDBC URL sytax is as follows:
{{{
jdbc:openlink://ODBC[/DSN=dsn][/UID=uid][/PWD=pwd][/READONLY=x]
}}}

=== Type 1 JDBC URL Attributes ===

* **{{{/DSN}}}** -- ODBC Data Source Name
* **{{{/UID}}}** -- Username
* **{{{/PWD}}}** -- Password
* **{{{/READONLY}}}** -- Determines session mode, read-write ({{{=N}}}) or read-only ({{{=Y}}}).

== Example ==

To connect to an ODBC DSN on your machine named "CustomerDatabase" in read-only mode, you could use the following JDBC URL:
{{{
jdbc:openlink://ODBC/DSN=CustomerDatabase/UID=test/PWD=test/READONLY=Y
}}}

== //Important Note// == 

//The connect string syntax below uses the proof-of-concept JDBC-to-ODBC bridge which was bundled into Java 1 through 7, and dropped in Java 8.//

//This syntax should not be used.//
{{{
jdbc:odbc:<dsn>;UID=<uid>;PWD=<pwd>
}}}


== See Also ==

* [[JDBC3ConnectionURLFormat| Connection URLs for Type 3 JDBC Driver]]