<p>I created a report using Birt Designer (non-pro). It connects to a mySQL database over the internet using the mySQL JDBC driver, which is a .jar file which I downloaded and specified my report to use. It works perfectly fine when run from the report designer, but when I upload the report to a remote iHub F-type server, it fails to connect because it doesn't load the driver properly. I tried putting it in the jdbc drivers folder on the server (at /iHub/jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_4.4.0.v20150206-1039/drivers/mysql-connector-java-5.1.22-bin.jar ) but that didn't work. I ended up putting the driver in a separate folder on the server (e.g. /home/jbdc-drivers/mysql-connector-java-5.1.22-bin.jar ) and manually editing the report XML so that the "jarList" property was the path on the server's filesystem, instead of on my local machine.</p>
<p> </p>
<p>This ended up working, but seems like an awkward/hacky work-around. Is there a better solution? Am I doing something wrong? I don't want to have to manually edit every report before uploading it to ihub f-type. </p>
<p> </p>
<p>I created the report on windows 8 using the eclipse-based open source BIRT designer. The iHub F-type server is running on an Amazon EC2 image, and the mySQL server is also running using AWS. </p>
