Unable To Import The MS SQL Server List Of Schemas While Mapping Tables In JDeveloper (Doc ID 2016950.1)

Last updated on JUNE 10, 2015

Applies to:

Oracle TopLink - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

In SOA context , Jdeveloper 11.1.1.1.7 is used in order to import tables
from sqlserver (SQL Server of version 2012 - 11.0.5548.0 (X64)) for creating a sqlserver adpater.
For this a connection is created sucessfully by providing connections details :
  and providing a jdbc library sql and class com.microsoft.sqlserver.jdbc.SQLServerDriver .

The problem is when trying to list a table , a list of schemas must be filled
but this schema list cannot be obtained  in Jdeveloper as the following error is occuring :
 

SEVERE: Could not get schema Object:com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between

"SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the INTERSECT operation.
May 12, 2015 2:36:46 PM oracle.tip.tools.ide.adapters.designtime.adapter.xr.XRAdapterImportSelectionPanel
WARNING: Error loading schemas: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between

"SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the INTERSECT operation.
May 12, 2015 2:55:25 PM oracle.jdevimpl.ejb.cmpwiz.CmpTables30Panel
WARNING: Error loading schemas: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between

"SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the INTERSECT operation.




Cause

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 hundreds of Community platforms