java.sql.SQLException: No suitable driver When Connecting to Oracle Lite Repository Using Oracle JDBC Thin Driver (Doc ID 316555.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

Symptoms

When trying to connect using the code "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.