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:

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

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