Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Java Runtime Environment (JRE) version 1.6 is not supported by this driver"

user642829Dec 18 2010 — edited Dec 18 2010
Goal: create new ODI install in testlab on single server

Installer: ODI newbie

Server Software Installed: all 32-bit
Windows 2008
sql 2008
JDK 1.6_22
sqljdbc4.jar (downloaded from Microsoft's site)
No weblogic server installed

Issue: Using ODI Studio to create Master Repository. Jar files and config described below already implemented. When press “Test Connection ” in ODI Studio I get this error: : “Java Runtime Environment (JRE) version 1.6 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0"


Details:

(Sqljdbc.jar and) Sqljdbc4.jar downloaded from here:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en


(Sqljdbc.jar and ) Sqljdbc4.jar placed in C:\Users\Administrator\AppData\Roaming\odi\oracledi\userlib directory

Repository Connection Details:
Technology: Microsoft SQL Server
JDBC driver: com.microsoft.sqlserver.jdbc.SqlServerDriver
JDBC URL : jdbc:sqlserver://ODI:1433;SelectMethod=cursor
User : odi


What am I doing wrong? TIA.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2011
Added on Dec 18 2010
1 comment
1,384 views