multiple report generation causing mysql driver failure

[johnrellis]

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)
new_report.rptdesign
testerclass.txt

[Tal.K]

Please remove me from mailing list!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

-----Original Message-----
From: birt-report-designer-dev-bounces@...
[mailto:birt-report-designer-dev-bounces@...] On Behalf Of jr85
Sent: Tuesday, June 10, 2008 6:47 PM
To: birt-report-designer-dev@...
Subject: [birt-report-designer-dev] multiple report generation causing
mysqldriver failure


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-failur
e-tp17758642p17758642.html
Sent from the Eclipse BIRT - Report Designer - Dev mailing list archive at
Nabble.com.

_______________________________________________
birt-report-designer-dev mailing list
birt-report-designer-dev@...
https://dev.eclipse.org/mailman/listinfo/birt-report-designer-dev


_______________________________________________
birt-report-designer-dev mailing list
birt-report-designer-dev@...
https://dev.eclipse.org/mailman/listinfo/birt-report-designer-dev