My Oracle Support Banner

How to create Fusion ADF Web Application that connects to Microsoft SQL Server in JDeveloper 11.1.2.4 and later (Doc ID 2110091.1)

Last updated on MARCH 15, 2016

Applies to:

Oracle JDeveloper - Version 11.1.2.4.0 and later
Information in this document applies to any platform.

Goal

Since there are some differences between JDeveloper 11.1.2.4 and 12.2.1 when it comes to connecting to Microsoft SQL Server, this article will list step by step instructions and how to create an ADF page that connects to SQL Server database and retrieve some data using Microsoft JDBC driver sqljdbc4.jar.

The difference is that in JDeveloper 11.1.2.4, we have to add a classpath statement  in setDomainEnv.bat to point to sqljdbc4.jar. Otherwise, the following error will be encountered:

JBO-29000: Unexpected exception caught: java.lang.NoClassDefFoundError, msg=com/microsoft/sqlserver/jdbc/ISQLServerConnection

In JDeveloper 12.2.1, that step is not needed.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.