|Date Added:||25 December 2015|
|File Size:||67.87 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
IBM What is the correct / best OJDBC JAR file to use with Cognos Controller? – United States
Here is the link to oracle documentation in x to great answers for the question. Assuming you have installed the Oracle 11G rel2 client in the default location, then you can find this on the Controller application server here: So which type of driver 1,2,3,4 is used for each of these?
We normally include driver like ojdbc14 Intended for Java 1.
Yes you can run the smaller drivers on newer java versions. Again none of this has to do with functionality; however, they all impact how to deploy, how to debug, and how to configure the database connection. Due to the extra “hop” of data through ODBC, one would expect it to be a bit slower than a type-4 access; however, there is a possibility that the ODBC is optimized to such a great extent for a particular situation, that the extra hop is negligible.
Looking at the Oracle site and documentation, the different versions seem to be primarily targeting various versions of the JDBC API, which tend to correspond to the version of the JVM they were introduced in.
Download ojdbc14.jar : ojdbc14 « o « Jar File Download
However, based on customer feedback, IBM Support recommends the following as a basic guideline: The Java program connects directly to the database, meaning that if there is a problem, it will be captured entirely within the JVM of the program making the connection type 1, it’s in the ODBC layer, type 2 it’s in the native compiled code, type 3 it’s in the remote network proxy.
In simple terms Type1: The four types are: Type 4 drivers are the ones you probably want to stick with. However I generely suggest to use the latest i.
Configuring a Linux or AIX portal server (JDBC connection)
Sign up using Facebook. Types of drivers are explained in detail here: They will have different performance characteristics.
We are using THIN mode. Sign up or log in Sign up using Google. No matter what the DB version is. Easy location to obtain from.
Oracle have produced many different versions of their JDBC thin driver. Sign up using Email and Password. Just a side note: