title: Cannot load JDBC Driver class in Birt 4.6.0-20160607
body: <p>i am having a Java EE project in which i include the Birt runtime as a maven dependency:</p>
  
  <pre><code> &lt;dependency&gt;
    &lt;groupId&gt;org.eclipse.birt.runtime&lt;/groupId&gt;
    &lt;artifactId&gt;org.eclipse.birt.runtime&lt;/artifactId&gt;
    &lt;version&gt;4.6.0-20160607&lt;/version&gt;
    &lt;exclusions&gt;
      &lt;exclusion&gt;
          &lt;groupId&gt;org.eclipse.birt.runtime&lt;/groupId&gt;
          &lt;artifactId&gt;org.apache.xerces&lt;/artifactId&gt;
      &lt;/exclusion&gt;
      &lt;exclusion&gt;
        &lt;artifactId&gt;org.apache.poi&lt;/artifactId&gt;
        &lt;groupId&gt;org.eclipse.birt.runtime&lt;/groupId&gt;
      &lt;/exclusion&gt;
    &lt;/exclusions&gt;
  &lt;/dependency&gt;
  </code></pre>
  
  <p>The engine seems to be created (i hope at least) . In my report i have defined the datasource settings.</p>
  
  <pre><code>   &lt;data-sources&gt;
          &lt;oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="somename" id="43"&gt;
              &lt;list-property name="privateDriverProperties"&gt;
                  &lt;ex-property&gt;
                      &lt;name&gt;contentBidiFormatStr&lt;/name&gt;
                      &lt;value&gt;ILYNN&lt;/value&gt;
                  &lt;/ex-property&gt;
                  &lt;ex-property&gt;
                      &lt;name&gt;metadataBidiFormatStr&lt;/name&gt;
                      &lt;value&gt;ILYNN&lt;/value&gt;
                  &lt;/ex-property&gt;
              &lt;/list-property&gt;
              &lt;property name="odaDriverClass"&gt;oracle.jdbc.driver.OracleDriver&lt;/property&gt;
              &lt;property name="odaURL"&gt;jdbc:oracle:thin:@host...&lt;/property&gt;
              &lt;property name="odaUser"&gt;username&lt;/property&gt;
              &lt;encrypted-property name="odaPassword" encryptionID="base64"&gt;password&lt;/encrypted-property&gt;
          &lt;/oda-data-source&gt;
      &lt;/data-sources&gt;
  </code></pre>
  
  <p>Unfortunately it seems that Birt cannot find the ojdbc driver (Note, we use an oracle database)  and we get the following error:</p>
  
  <blockquote>
    <p>SEVERE [org.eclipse.birt.data.engine.odaconsumer] (default task-20)
    Unable to open connection.:
    org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC
    Driver class: oracle.jdbc.driver.OracleDriver.</p>
  </blockquote>
  
  <p>I have included in my Web module under WEB-INF/lib the following jar org.eclipse.birt.report.data.oda.jdbc_4.6.0.v201606072122.jar but i am still getting the same error.</p>
  
  <p>Is there any way to solve this by adding the ojdbc as a maven dependency or is there any other workaround ?</p>
  
  <p><strong>Update:</strong> I have tried to also to add the also the org.eclipse.birt.report.data.oda.jdbc_4.6.0.v201606072122.jar as a maven dependency.</p>
  
  <pre><code>&lt;!-- Oracle JDBC driver --&gt;
  &lt;dependency&gt;
      &lt;groupId&gt;com.oracle&lt;/groupId&gt;
      &lt;artifactId&gt;ojdbc6&lt;/artifactId&gt;
      &lt;version&gt;11.2.0.4.0&lt;/version&gt;
      &lt;scope&gt;provided&lt;/scope&gt;
  &lt;/dependency&gt;
  
   &lt;dependency&gt;
       &lt;groupId&gt;org.eclipse.birt&lt;/groupId&gt;
       &lt;artifactId&gt;ojdbc&lt;/artifactId&gt;
       &lt;scope&gt;system&lt;/scope&gt;
       &lt;version&gt;1.0&lt;/version&gt;
       &lt;systemPath&gt;${basedir}\src\main\resources\lib\org.eclipse.birt.report.data.oda.jdbc_4.6.0.v201606072122.jar&lt;/systemPath&gt;
   &lt;/dependency&gt;
  </code></pre>
  
  <p>I am getting the same error. Bellow some part of the stacktrace:</p>
  
  <blockquote>
    <p>2017-01-05 13:07:11,990 SEVERE
    [org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager] (default
    task-45) DriverClassLoader failed to load class:
    oracle.jdbc.driver.OracleDriver: java.lang.ClassNotFoundException:
    oracle.jdbc.driver.OracleDriver
        at org.eclipse.birt.core.framework.URLClassLoader.findClass1(URLClassLoader.java:188)</p>
    
    <p>......</p>
    
    <p>......</p>
    
    <p>2017-01-05 13:07:12,020 SEVERE
    [org.eclipse.birt.data.engine.odaconsumer] (default task-45) Unable to
    open connection.: org.eclipse.birt.report.data.oda.jdbc.JDBCException:
    Cannot load JDBC Driver class: oracle.jdbc.driver.OracleDriver.
        at org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager.findDriver(JDBCDriverManager.java:881)</p>
  </blockquote>
  
  <p><strong>Update 2:</strong>  I  made further changes but still without success.  I added the org.eclipse.birt.report.data.oda.jdbc_4.6.0.v201606072122.jar library in all my modules under WEB-INF and MEtA-INF</p>
  
  <p>\src\main\webapp\WEB-INF\lib\org.eclipse.birt.report.data.oda.jdbc_4.6.0.v201606072122.jar</p>
  
  <p>The results are quite the same:</p>
  
  <blockquote>
    <p>2017-01-05 15:40:49,927 SEVERE
    [org.eclipse.birt.report.data.oda.jdbc.JDBCDriverManager] (default
    task-19) DriverClassLoader failed to load class:
    org.eclipse.birt.report.data.oda.jdbc:
    java.lang.ClassNotFoundException:
    org.eclipse.birt.report.data.oda.jdbc</p>
  </blockquote>
  
  <p>I would also like to note here something. For our persistence in the application, we use a datasource on our wildfly in which we use the ojdbc driver as a module in Wildfly 10 .</p>
  
  <p>I am slowly running out of ideas with Birt + ojdbc</p>