java.sql.SQLException: No suitable driver When Connecting to Oracle Lite Repository Using Oracle JDBC Thin Driver

(Doc ID 316555.1)

Last updated on MAY 15, 2018

Applies to:

Oracle Lite - Version 10.0.0.0.1 and later
Microsoft Windows (32-bit)
***Checked for relevance on 08-Apr-2014***

Symptoms

When trying to connect using the code from <Note 316465.1>"SCR 1583 Using Consolidator API to Create Publication and Publication Item for Oracle Lite 10g". The following error is occurring during the connection to the repository. The following error is occurring during the connection to the repository.

java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:532)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at oracle.mobile.admin.ResourceManager.<init>(ResourceManager.java:84)
        at oracle.mobile.admin.ResourceManager.<init>(ResourceManager.java:104)
        at oracle.mobile.admin.ResourceManager.openConnection(ResourceManager.java:186)
        at Publication.openOliteConnection(Publication.java:21)
        at Publication.main(Publication.java:8)
oracle.lite.sync.ConsolidatorException:

CONS-10050: Rollback failure: java.lang.NullPointerException

        at oracle.lite.sync.Subscription.getConsolidatorExceptionAndRollback(Subscription.java:11727)
        at oracle.lite.sync.Consolidator.DropPublicationItem(Consolidator.java:4041)
        at Publication.dropPublication(Publication.java:35)
        at Publication.main(Publication.java:9)
oracle.lite.sync.ConsolidatorException:

CONS-10050: Rollback failure: java.lang.NullPointerException

        at oracle.lite.sync.Subscription.getConsolidatorExceptionAndRollback(Subscription.java:11727)
        at oracle.lite.sync.Consolidator.CreatePublication(Consolidator.java:3578)
        at Publication.createEmployeeAPIPublication(Publication.java:48)
        at Publication.main(Publication.java:10)
oracle.lite.sync.ConsolidatorException:

CONS-10050: Rollback failure: java.lang.NullPointerException

        at oracle.lite.sync.Subscription.getConsolidatorExceptionAndRollback(Subscription.java:11727)
        at oracle.lite.sync.Consolidator.CreatePublicationItem(Consolidator.java:3748)
        at Publication.createEmpPublicationItem(Publication.java:60)
        at Publication.main(Publication.java:11)
oracle.lite.sync.ConsolidatorException:

CONS-10050: Rollback failure: java.lang.NullPointerException

        at oracle.lite.sync.Subscription.getConsolidatorExceptionAndRollback(Subscription.java:11727)
        at oracle.lite.sync.Consolidator.AddPublicationItem(Consolidator.java:4077)
        at Publication.addEmpPublicationItem(Publication.java:72)
        at Publication.main(Publication.java:12)

Changes

Connecting to a 9.2.0.6.0 or 10.0.0.0.0 Oracle Database that was newly installed.

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