Andreas Säger wrote:
Am 26.05.2012 22:13, Girvin R. Herr wrote:
Andreas,
Yes! Plus the "com.mysql.jdbc.Driver" class and the "MySQL (JDBC)"
connection type option.
And I am using the "MySQL-connector-java-5.0.7-bin.jar" in the class
path and the MySQL 5.0.67 server.
Sun (Oracle) Java version 1.6.0_30
All test okay, of course.
Thanks.
Girvin
Install Java 1.6.0_22 or LibreOffice 3.5.x and things will run with
normal speed.
Andreas,
Here is some more data on the subject. I opened LO in a shell so I
could catch any LO errors and then started my report build. The
following enclosure was then displayed in the shell.
Note that the first 2 errors regarding library version information come
up when I invoke LO, before I open ORB. My research informed me that
these version errors are not fatal, despite the "required" tag. They are
just a minor mismatch between my libraries and the ones compiled with
LO. However, the "pentaho" errors, whatever pentaho is, may be
significant, especially the Null Pointer errors.
----------------------------------------- Start of enclosure
501:$libreoffice3.5
/opt/libreoffice3.5/program/../ure-link/bin/javaldx:
/usr/lib/libxml2.so.2: no version information available (required by
/opt/libreoffice3.5/ure/bin/../lib/libjvmfwk.so.3)
/opt/libreoffice3.5/program/soffice.bin: /usr/lib/libpng12.so.0: no
version information available (required by
/opt/libreoffice3.5/program/libcairo.so.2)
May 27, 2012 12:36:40 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibSerializer 1.1.6.10682 started.
May 27, 2012 12:36:40 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibBase 1.1.6.10682 started.
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibLoader 1.1.6.10682 started.
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibRepository 1.1.6.10682 started.
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibFonts 1.1.6.10682 started.
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibLayout null started.
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibFormula 1.1.7.10682 started.
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: LibXML 1.1.7.10682 started.
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module:
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.common.SwingCommonModule}
java.lang.NullPointerException
at
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
at
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
at
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module:
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.html.SwingHtmlModule}
java.lang.NullPointerException
at
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
at
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
at
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module:
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.pdf.SwingPdfModule}
java.lang.NullPointerException
at
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
at
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
at
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module:
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.preview.SwingPreviewModule}
java.lang.NullPointerException
at
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
at
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
at
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.PackageManager loadModule
WARNING: Exception while loading module:
org.pentaho.reporting.libraries.base.boot.DefaultModuleInfo={ModuleClass=org.jfree.report.modules.gui.swing.printing.SwingPrintingModule}
java.lang.NullPointerException
at
org.pentaho.reporting.libraries.base.boot.PackageManager.containsModule(PackageManager.java:369)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.loadModule(PackageManager.java:436)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.addModule(PackageManager.java:330)
at
org.pentaho.reporting.libraries.base.boot.PackageManager.load(PackageManager.java:199)
at org.jfree.report.JFreeReportBoot.performBoot(Unknown Source)
at
org.pentaho.reporting.libraries.base.boot.AbstractBoot.start(AbstractBoot.java:197)
at
com.sun.star.report.pentaho.PentahoReportEngine.<init>(PentahoReportEngine.java:45)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.createReportJob(SOReportJobFactory.java:328)
at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:222)
May 27, 2012 12:36:41 PM
org.pentaho.reporting.libraries.base.boot.AbstractBoot start
INFO: Pentaho Reporting Flow-Engine null started.
---------------------------------------- End of enclosure
Null pointers are _*not*_ a good sign.
No further messages were output and I terminated the report generation
process before it completed.
I would like to resolve this ORB problem, since the Calc solution has a
couple problems with it. Mainly, I remembered last night that several
of my reports have so much data in each record that they are printed
with two or more lines of text in the report, which I don't believe can
be done neatly in Calc.
Hope this helps resolve this problem.
Girvin
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted