I have been developing BIRT reports for a few years now. I am trying to get the BIRT Report viewer working in Tomcat on a remote server but I am getting an error Cannot load JDBC Driver class: com.mysql.jdbc.Driver when I try to run reports on the server where the BIRT Viewer is located.<br />
<br />
I am trying to install BIRT Viewer 3.7.2 on a Windows 2008 remote server. I have been following the guidance in the document <a class='bbc_url' href='
http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php'>http://www.eclipse.org/birt/phoenix/deploy/viewerSetup.php</a><br />
<br />
Here is what I have done so far:<br />
<ul class='bbc'><li>I am sure that the installation of Tomcat is working because I can access the Tomcat /manager/html screen from the local server and from a remote machine through a browser</li><li>I am also sure that the BIRT Viewer is working because I can access the test reports locally via <a class='bbc_url' href='
http://localhost:8080/birt-viewer/run?__report=test.rptdesign'>http://localhost:8080/birt-viewer/run?__report=test.rptdesign</a> and <a class='bbc_url' href='
http://localhost:8080/birt-viewer/run?__report=test1.rptdesign'>http://localhost:8080/birt-viewer/run?__report=test1.rptdesign</a> and via a browser from a remote machine</li><li>I have copied the file mysql-connector-java-5.1.25-bin.jar to the folder on the server Tomcat 7.0\webapps\birt-viewer\WEB-INF\lib (I also tried copying this jar file to birt-viewer\WEB-INF\platform\plugins\org.eclipse.birt.report.data.oda.jdbc\drivers which I believe is for an earlier version of the viewer but that didn't work either)</li><li> The report I am trying to run on the remote server that accesses a remote data source is pretty simple and works just fine on my local machine.</li><li> From the server I can ping back to my local machine so the server does not seem to be blocking outbound traffic.</li><li> I tried opening the server to all inbound traffic and that did not work either.</li></ul>
<br />
I'm out of ideas. Can anyone help me out?
