desktop-packages team mailing list archive

[Launchpad Bug Tracker <835662@xxxxxxxxxxxxxxxxxx>]

This bug was fixed in the package libreoffice - 1:3.4.3-1ubuntu3

---------------
libreoffice (1:3.4.3-1ubuntu3) oneiric; urgency=low

  * merge from debian up to 7eed0868b20d50c83a59d41d79d6543500e3d63d
    - fixes oosplash.bin crashed with SIGSEGV in XSetForeground() (LP: #835153)
    - reenables PostgreSQL SDBC (LP: #835662)
    - fixes report-builder (LP: #779798)
    - fixing -common/-core dependencies (LP: #841562) (LP: #850372)

libreoffice (1:3.4.3-2) UNRELEASED; urgency=low

  [ Rene Engelhard ]
  * debian/patches/no-deprecated-options-in-qstart-wrappers.diff: use --writer
    instead of -writer (closes: #638868)
  * debian/patches/fix-sample-icc-1.3.2-patch.diff: backport from master:
    re-enable patch hunk to fix PDF A/1-a export on 64bit archs, thanks lmamane
    for the patch (closes: #633480)
  * debian/patches/update-sdbc-postgresql.diff: update SDBC PostgreSQL
    driver to Lionels new LibreOffice version.
  * debian/patches/handle-NULL-display-gracefully.diff: backport from
    libreoffice-3-4

  * debian/control.in:
    - remove obsolete Pre-Depends on debconf in ure
    - add Breaks: on incompatible -cores on -common (basis-link symlink)
      (closes: #641357)
  * debian/control.postgresql.in: add (>= 8,4) to postgresql suggests to make
    more visible that we need >= 8.4 of PostgreSQL. Update Homepage for new
    LibreOffice location
  * debian/control.reportdesign.in: make -report-builder depend on
    -report-builder-bin (>= ${base-version}) (closes: #640900)
  * debian/rules:
    - re-enable -sdbc-postgresql
    - fix adding PYTHONPATH to unopkg (closes: #625878)
  * debian/libreoffice-common.links, debian/rules:
    - fix mimetype icon links for hicolor (closes: #641860)

  [ Lionel Elie Mamane ]
  * debian/rules: we need translate-toolkit (>= 1.9.0)
 -- Bjoern Michaelsen <bjoern.michaelsen@xxxxxxxxxxxxx>   Thu, 22 Sep 2011 12:46:37 +0200

** Changed in: libreoffice (Ubuntu)
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/835662

Title:
  LibreOffice Base forms become extremely slow after switching from
  currently unusable PostgreSQL SDBC driver to JDBC

Status in “libreoffice” package in Ubuntu:
  Fix Released

Bug description:
  We have been using OpenOffice/LibreOffice Base and SDBC for a long
  time to access our PostgreSQL databases. After SDBC has apparently
  gone defunct (tables are all read only), we had to switch to JDBC.
  However, opening and using forms via JDBC is extremely slow. Following
  suggestions from the PostgreSQL JDBC mailing list, I logged the
  queries issued by both drivers (log file is attached). While both
  drivers spend only a short while doing queries (JDBC: 0.65 s, SDBC:
  0.62 s in my test case), the difference in total time used is huge (at
  least 49 s with JDBC, 2 s with SDBC). It looks to me that JDBC itself
  cannot be blamed for this bad performance, so I consider this
  behaviour as a bug of LibreOffice base.

  Please let me know if you do need any additional information, for
  example about the used database tables. The table of the form I used
  for the attached example log is rather unwieldy (many columns), but it
  has only ~5.500 rows. Anyway, the effect is observable also with much
  simpler tables and the respective forms.

  I hope you will be able to track this down ...,
  Cheers, Ulf

  ProblemType: Bug
  DistroRelease: Ubuntu 11.04
  Package: libreoffice-base 1:3.3.3-1ubuntu2
  ProcVersionSignature: Ubuntu 2.6.38-11.48-generic 2.6.38.8
  Uname: Linux 2.6.38-11-generic x86_64
  Architecture: amd64
  Date: Sat Aug 27 17:29:31 2011
  EcryptfsInUse: Yes
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
  ProcEnviron:
   LANGUAGE=en_GB:en
   PATH=(custom, user)
   LANG=de_DE.UTF-8
   LC_MESSAGES=en_GB.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to natty on 2011-04-29 (119 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/835662/+subscriptions