Uploaded image for project: 'Network Controller'
  1. Network Controller
  2. SDNC-1373

SQLException: Unable to load class: org.mariadb.jdbc.Driver

XMLWordPrintable

      Testing the docker image nexus3.onap.org:10003/onap/sdnc-image:2.1.0-STAGING-latest in a standalone env, the following error appears in karaf.log:

       
      2020-10-06T08:54:52,628 | ERROR | Thread-66 | ConnectionPool | 149 - org.apache.tomcat.jdbc - 9.0.30 | - | Unable to create initial connections of pool.
      java.sql.SQLException: Unable to load class: org.mariadb.jdbc.Driver from ClassLoader:org.eclipse.osgi.internal.loader.EquinoxClassLoader@787cc752[org.apache.tomcat.jdbc:9.0.30(id=149)];ClassLoader:org.eclipse.osgi.internal.framework.ContextFinder@6950ed69
      at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:292) ~[149:org.apache.tomcat.jdbc:9.0.30]
      at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:212) ~[149:org.apache.tomcat.jdbc:9.0.30]
      at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:744) ~[149:org.apache.tomcat.jdbc:9.0.30]
      at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:676) ~[149:org.apache.tomcat.jdbc:9.0.30]
      at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:483) [149:org.apache.tomcat.jdbc:9.0.30]
      at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154) [149:org.apache.tomcat.jdbc:9.0.30]
      at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118) [149:org.apache.tomcat.jdbc:9.0.30]
      at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107) [149:org.apache.tomcat.jdbc:9.0.30]
      at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131) [149:org.apache.tomcat.jdbc:9.0.30]
      at org.onap.ccsdk.sli.core.dblib.CachedDataSource.getConnection(CachedDataSource.java:121) [227:org.onap.ccsdk.sli.core.dblib-provider:1.1.0.SNAPSHOT]
      at org.onap.ccsdk.sli.core.dblib.CachedDataSource.testConnection(CachedDataSource.java:369) [227:org.onap.ccsdk.sli.core.dblib-provider:1.1.0.SNAPSHOT]
      at org.onap.ccsdk.sli.core.dblib.DBResourceManager.setDataSource(DBResourceManager.java:669) [227:org.onap.ccsdk.sli.core.dblib-provider:1.1.0.SNAPSHOT]
      at org.onap.ccsdk.sli.core.dblib.DBResourceManager$DataSourceTester.run(DBResourceManager.java:294) [227:org.onap.ccsdk.sli.core.dblib-provider:1.1.0.SNAPSHOT]
      Caused by: java.lang.ClassNotFoundException: Unable to load class: org.mariadb.jdbc.Driver from ClassLoader:org.eclipse.osgi.internal.loader.EquinoxClassLoader@787cc752[org.apache.tomcat.jdbc:9.0.30(id=149)];ClassLoader:org.eclipse.osgi.internal.framework.ContextFinder@6950ed69
      at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:56) ~[?:?]
      at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:281) ~[?:?]
      ... 12 more
      Caused by: java.lang.ClassNotFoundException: org.mariadb.jdbc.Driver
      at jdk.internal.loader.BuiltinClassLoader.loadClass(Unknown Source) ~[?:?]
      at jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(Unknown Source) ~[?:?]
      at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:?]
      at org.eclipse.osgi.internal.framework.ContextFinder.loadClass(ContextFinder.java:132) ~[?:?]
      at java.lang.ClassLoader.loadClass(Unknown Source) ~[?:?]
      at java.lang.Class.forName0(Native Method) ~[?:?]
      at java.lang.Class.forName(Unknown Source) ~[?:?]
      at org.apache.tomcat.jdbc.pool.ClassLoaderUtil.loadClass(ClassLoaderUtil.java:38) ~[?:?]
      at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:281) ~[?:?]
      ... 12 more
      2020-10-06T08:54:52,631 | ERROR | Thread-66 | CachedDataSource | 227 - org.onap.ccsdk.sli.core.dblib-provider - 1.1.0.SNAPSHOT | - | SQL DataSource < sdnctldb01 > test failed. Cause : Unable to load class: org.mariadb.jdbc.Driver from ClassLoader:org.eclipse.osgi.internal.loader.EquinoxClassLoader@787cc752[org.apache.tomcat.jdbc:9.0.30(id=149)];ClassLoader:org.eclipse.osgi.internal.framework.ContextFinder@6950ed69> test failed. Cause : {}
       

      Due to this reason, the calls to A1-ADAPTER are failing:

      2020-10-06T09:58:12,916 | ERROR | qtp1834080683-127 | DBResourceManager | 227 - org.onap.ccsdk.sli.core.dblib-provider - 1.1.0.SNAPSHOT | - | Generated alarm: DBResourceManager.getData - No active DB connection pools are available.
      2020-10-06T09:58:12,916 | ERROR | qtp1834080683-127 | A1AdapterProvider | 218 - org.onap.ccsdk.oran.a1-adapter-provider - 1.1.0.SNAPSHOT | - | Caught exception looking for service logic, SQL query failed
      2020-10-06T09:58:12,916 | ERROR | qtp1834080683-127 | A1AdapterProvider | 218 - org.onap.ccsdk.oran.a1-adapter-provider - 1.1.0.SNAPSHOT | - | No service logic active for A1Adapter: 'getA1PolicyType'

            djtimoney Dan Timoney
            rehanraza rehanraza
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: