Tomcat & Database Replication

fccobb

Hi

I have a Birt report that renders data from MySQL straight to PDF and doesn't go to the viewer. It works just fine and takes a little over 20 seconds to produce the file.

However, when I switch database replication on the report takes nearly four minutes to render.

I can't think of a reason why this should be but I do need to sort it out.

The only thing I can think of is that with MySQL database replication you have to remove the bind address of 127.0.0.1 in the my.cnf file which stops the MySQL server responding to localhost.

This shouldn't make a difference because I am going via a JNDI URL and connection pooling so it should get its database connection information from there and I know that is working because I have Lambda Probe set up and the JNDI reference is working without a hitch.

I would be grateful if anyone can think of a reason why this might be ?

Thanks

Chris

fccobb

Just as further information in case anyone can help.

I have looked in the logs and I get the following messages:

Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec
INFO: Ignoring UnsupportedOperationException thrown by ODA driver (org.eclipse.birt.report.data.oda.jdbc); cannot set query specification before prepare.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec
INFO: Ignoring UnsupportedOperationException thrown by ODA driver (org.eclipse.birt.report.data.oda.jdbc); cannot set query specification before prepare.
Dec 3, 2009 5:49:25 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:26 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:26 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:26 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:26 PM org.eclipse.birt.report.engine.layout.pdf.util.HTMLStyleProcessor execute
SEVERE: There is a invalid value for property SIZE of element FONT in the HTML.
Dec 3, 2009 5:49:26 PM org.eclipse.birt.data.engine.odaconsumer.Connection setOdaQuerySpec
INFO: Ignoring UnsupportedOperationException thrown by ODA driver (org.eclipse.birt.report.data.oda.jdbc); cannot set query specification before prepare.

I have checked the jdbc driver and it looks fine.

I have tried it with Open JDK and Sun JDK and the results are the same.

I have now removed database replication temporarily and it still takes the same excessive time so maybe replication is not the key here.

Any help from anyone I would be very grateful.

Thanks

Chris