Error "java.sql.SQLException: [oias][Sybase JDBC Driver]This driver is locked for use with embedded applications" Occurs When Accessing Sybase Database Connection in JDeveloper 11g (Doc ID 1316977.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle JDeveloper - Version 11.1.1.1.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Mar-2013***

Symptoms

In JDeveloper 11g, when trying to connect to a Sybase database connection using Data Direct drivers fails and the following error occurs.

oracle.javatools.db.DBException: java.sql.SQLException: [oias][Sybase JDBC Driver]This driver is locked for use with embedded applications.
at oracle.javatools.db.jdbc.JdbcDDLDatabase.loadSchemasImpl(JdbcDDLDatabase.java:613)
at oracle.javatools.db.jdbc.JdbcDDLDatabase.listSchemas(JdbcDDLDatabase.java:578)
at oracle.javatools.db.AbstractDBObjectProvider.listSchemas(AbstractDBObjectProvider.java:850)
at oracle.javatools.db.ddl.DDLDatabase.listSchemas(DDLDatabase.java:708)
at oracle.dbtools.raptor.navigator.dbapi.MetadataSchemasInstance.listChildren(MetadataSchemasInstance.java:40)
at oracle.dbtools.raptor.navigator.dbapi.MetadataSchemasInstance.listChildren(MetadataSchemasInstance.java:23)
at oracle.dbtools.raptor.navigator.ConnectionFilter$1.doWork(ConnectionFilter.java:141)
at oracle.dbtools.raptor.navigator.ConnectionFilter$1.doWork(ConnectionFilter.java:102)
at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:492)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: [oias][Sybase JDBC Driver]This driver is locked for use with embedded applications.
at com.oracle.ias.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.oracle.ias.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.oracle.ias.jdbc.base.BaseConnection.createStatement(Unknown Source)
at com.oracle.ias.jdbc.base.BaseConnection.createStatement(Unknown Source)
at com.oracle.ias.jdbc.base.BaseDatabaseMetaData.getSchemas(Unknown Source)
at oracle.javatools.db.jdbc.JdbcDDLDatabase.populateSchemas(JdbcDDLDatabase.java:657)
at oracle.javatools.db.jdbc.JdbcDDLDatabase.loadSchemasImpl(JdbcDDLDatabase.java:593)
... 17 more


STEPS

The issue can be reproduced following steps.
1. Down Data Direct drivers version 3.6 from
      http://www.oracle.com/technetwork/topics/datadirect-index-091847.html
2. Define Data Direct Sybase libraries (Manage Libraries screen).
3. Create a database connection to Sybase.
4. Connect to new Sybase connection.

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