[birt-report-designer-dev] multiple report generation causing mysql driv

[jr85 <john.rellis@xxxxxxxxxxxxxxx>]

Hi all,

Sorry if anyone on the Birt-Dev list got this already as i posted in the
wrong forum and i apologise!

I have wrote a Java class to deploy a birt report to a specified directory
in html format. It is pretty much a carbon copy of that found on the BIRT
Eclipse wiki. The class will work fine when i run it once, however if i put
it within a for loop and run it more than once within the loop, all but the
first one fails with the exception:

"03-Jun-2008 10:38:08 org.eclipse.birt.report.data.oda.jdbc.JDBCDriverMa
nager findDriver
WARNING: Failed to load JDBC driver class: com.mysql.jdbc.Driver
03-Jun-2008 10:38:08 org.eclipse.birt.data.engine.odaconsumer.Connectio
nManager openConnection
SEVERE: Cannot open connection.
org.eclipse.birt.report.data.oda.jdbc.JDBCExceptio n: Cannot load JDBC
Driver class: com.mysql.jdbc.Driver"

The fact that the database driver is found first time suggests to me that
all is set up correctly on my machine, i could be suffering from code
blindness as i have read over the class so many times but i cant see
anything wrong. I have attached the class and a test report that uses the
classic models database that should reproduce the error. If anyone could
take a look and give me some feedback that would be great. Any help is as
always greatly appreciated! I have comments in the main method that
hopefully make it easy to run!
Thanks,
John
(p.s. Birt 2.2.2)
http://www.nabble.com/file/p17758642/new_report.rptdesign
new_report.rptdesign 
http://www.nabble.com/file/p17758642/testerclass.txt testerclass.txt 
-- 
View this message in context: http://www.nabble.com/multiple-report-generation-causing-mysql-driver-failure-tp17758642p17758642.html
Sent from the Eclipse BIRT - Report Designer - Dev mailing list archive at Nabble.com.