How to add JDBC driver to a BIRT project?
<p><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">Hi,</span><br><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">I am trying to add a MySQL jdbc driver to a BIRT project.</span><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">This is how I created the Java project.</span><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">1. In the project, I have "designConfig.setBIRTHome("org.eclipse.birt.runtime_4.4.0.jar");" which specifies what the runtime is.</span><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">2. In Eclipse, I right clicked on the project and selected "Export" to export the project as an executable jar file.</span><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">3. In the terminal, I entered "java -jar BIRTReport.jar" to execute the project and generate the report.</span><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">4. I got an exception: SEVERE: DriverClassLoader failed to load class: com.mysql.jdbc.Driver </span><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot load JDBC Driver class: com.mysql.jdbc.Driver.</span><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">5. I understand that I need to add the driver jar file to "org.eclipse.birt.runtime/drivers". Since org.eclipse.birt.runtime is a jar file, I unjarred it, put the driver in the drivers directory and jarred it back up. I have this exception now: Exception in thread "main" java.lang.NoClassDefFoundError: org/eclipse/birt/core/framework/PlatformConfig</span><br><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">I probably shouldn't unjar and jar the BIRT runtime plugin but am not sure how to add the driver.</span><br><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">Please advise,</span><br><br><span style="font-family:'Open Sans', 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;background-color:rgb(244,244,244);">Neil</span></p>
