Sqldeveloper Connection import failed with error oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212

Problem:
Import connections.xml from 12c to 11g environment throws error “Missing class: oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212“

Error log :

oracle.jdeveloper.db.ConnectionException: Could not retrieve connection details for database myDB Connection. The error encountered was: oracle.jdeveloper.db.ConnectionException: Could not retrieve connection details for database myDB Connection. The error encountered was: 
   Missing class: oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212
 Dependent class: oracle.adf.share.common.ClassUtils          
    Loader: main:11.0     
 Code-Source: /u01/binary/sqldeveloper/BC4J/lib/adf-share-base.jar   
 Configuration: system property /u01/binary/sqldeveloper/BC4J/lib/adf-share-base.jar

This load was initiated at main:11.0 using the Class.forName() method.

The missing class is not available from any code-source or loader in the system. 
at oracle.jdeveloper.db.DatabaseConnections.getReferenceable(DatabaseConnections.java:713)
.
.
. 
at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: javax.naming.NamingException [Root exception is oracle.classloader.util.AnnotatedClassNotFoundException: 
   Missing class: oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212
 Dependent class: oracle.adf.share.common.ClassUtils          
    Loader: main:11.0     
Code-Source: /u01/binary/sqldeveloper/BC4J/lib/adf-share-base.jar   
Configuration: system property /u01/binary/sqldeveloper/BC4J/lib/adf-share-base.jar

This load was initiated at main:11.0 using the Class.forName() method.

The missing class is not available from any code-source or loader in the system.] 
at oracle.adf.share.jndi.ContextImpl.throwNamingException(ContextImpl.java:388)
.
. 
at oracle.jdeveloper.db.DatabaseConnections.getReferenceable(DatabaseConnections.java:695) 
... 33 more

Caused by: oracle.classloader.util.AnnotatedClassNotFoundException: 
   Missing class: oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212
 Dependent class: oracle.adf.share.common.ClassUtils          
Loader: main:11.0     
Code-Source: /u01/binary/sqldeveloper/BC4J/lib/adf-share-base.jar   
Configuration: system property /u01/binary/sqldeveloper/BC4J/lib/adf-share-base.jar

This load was initiated at main:11.0 using the Class.forName() method.
The missing class is not available from any code-source or loader in the system. 
at oracle.classloader.PolicyClassLoader.handleClassNotFound(PolicyClassLoader.java:2186)
.
. 
at oracle.adf.share.jndi.ContextImpl.findObject(ContextImpl.java:456) 
... 37 more

 

Solution:

Modify connections.xml which is exported earlier and do a find/replace

Find: oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212
Replace: oracle.jdeveloper.db.adapter.DatabaseProvider

Now you can import file 🙂