desktop-packages team mailing list archive

Thread
Date
[Bug 782292] Re: Base cannot add/edit records using postgres sdbc driver

To: desktop-packages@xxxxxxxxxxxxxxxxxxx
From: Bug Watch Updater <782292@xxxxxxxxxxxxxxxxxx>
Date: Thu, 24 Nov 2011 09:21:46 -0000
Reply-to: Bug 782292 <782292@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Launchpad has imported 26 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=35784.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2011-03-29T23:28:14+00:00 EricW wrote:

When using Base to access a postgresql database with the postgresql
driver, it is impossible to insert-update-delete rows in the database.

The bug is reproducible with a minimal postgresql database containing the following table :
create table test_table (
  id serial primary key,
  label text
);

Libreoffice 3.3.1 OOO330m19 (Build:8)
Postgresql 8.4
Ubuntu 10.04LTS

Regards

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/0

------------------------------------------------------------------------
On 2011-03-30T00:56:42+00:00 Alex Thurgood wrote:

Also known as OOo bug :

http://openoffice.org/bugzilla/show_bug.cgi?id=117280


Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/1

------------------------------------------------------------------------
On 2011-05-18T02:22:56+00:00 Jürgen Sauer wrote:

Also here. It's a nasty bug. I see this Bug as critical, because major
database operations are impossible.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/4

------------------------------------------------------------------------
On 2011-05-18T08:02:51+00:00 Alex Thurgood wrote:

Hi Juergen,

The workaround, until someone decides to fix it, is to use the JDBC3
driver, which still works.

Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/5

------------------------------------------------------------------------
On 2011-05-18T08:04:37+00:00 Alex Thurgood wrote:

Correcting the title to reflect the actual issue, which is one of the
SDBC postgres driver and not being unable to work with postgres in
general.

It is also not a blocker if you can work with another driver in the
meantime.

Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/6

------------------------------------------------------------------------
On 2011-05-18T08:05:41+00:00 Alex Thurgood wrote:

Affects all platforms. Changing platform status accordingly.

Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/7

------------------------------------------------------------------------
On 2011-05-24T03:01:57+00:00 Alex Thurgood wrote:

Setting CONFIRMED status on whiteboard.

Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/9

------------------------------------------------------------------------
On 2011-06-05T02:17:31+00:00 Ferry Toth wrote:

This reported also on launchpad:

https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/782292

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/10

------------------------------------------------------------------------
On 2011-06-05T02:21:03+00:00 Ferry Toth wrote:

I think this bug should be a blocker.

The alternative JDBC driver does work but is 10x slower. The performance
difference is so big that it cannot be considered a 'real' alternative.

See for details: https://bugs.freedesktop.org/show_bug.cgi?id=35944

(comment 8)

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/11

------------------------------------------------------------------------
On 2011-06-05T02:22:41+00:00 Ferry Toth wrote:

Maybe related problem:

Setting the 'properties' of the database (via menu: <edit><database>) is
not possible anymore.

I suspect this is unintentionally disabled.

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/12

------------------------------------------------------------------------
On 2011-06-05T02:26:02+00:00 Ferry Toth wrote:

Are we depending on jbu (OO) to fix this bug?

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/13

------------------------------------------------------------------------
On 2011-06-05T02:57:08+00:00 Alex Thurgood wrote:

Hi Ferry,

Probably - there is no one in the LibO dev team at the moment with a
particular interest / availability for fixing DB related issues, so it
is not just postgres.

I can not even find the postgres SDBC driver source code anymore (the
connectivity/postgres directory has disappeared from the LibO repo), so
unless Joerg or someone else is willing to help out then it might just
die.


Alex

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/14

------------------------------------------------------------------------
On 2011-06-05T04:43:15+00:00 Ferry Toth wrote:

Alex, do you mean that LO is only half a fork from OO?

That would be a bad thing, which would force me to go back to OO, or at
least go-oo 3.2.1.

If needed I would build OO 3.2.1 in a Ubuntu ppa just to make sure I do
not loose database functionality.

BTW: sources for postgresql SDBC are part of Debian and Ubuntu as they
build a package libreoffice-sdbc-postgresql from their libreoffice
source package.

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/15

------------------------------------------------------------------------
On 2011-06-05T11:46:49+00:00 Cno wrote:

added to #35673 and will try to wake some initial interest from devs.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/18

------------------------------------------------------------------------
On 2011-06-16T13:12:49+00:00 Ferry Toth wrote:

I set regression as this problem did not occur in go-oo 3.2.1.

I can also confirm it to occur on Linux x86/x86-64 and Windows.

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/19

------------------------------------------------------------------------
On 2011-06-26T10:30:31+00:00 Ferry Toth wrote:

I just tried a little LO Basic code, to help me understand how all this
postgres driver code is supposed to work internally.

There seems to be a problem with the privileges, but
setting IgnoreDriverPrivileges on the driver doesn't seem to work. When a resultset is created it seems to have the wrong privileges.

I have the sources here and they do build, but I have no clue which
sources changed from 3.2.1 to 3.3.2. Which sources files should I look
at?

Ferry

Note: table TestTable is empty

This is the code:
Sub Main
   dbcontext = createunoservice("com.sun.star.sdb.DatabaseContext")
   dbsource = dbcontext.getByName("Exalon Office")

'putting a watch here on dbsource.Settings.IgnoreDriverPrivileges shows
this == TRUE
'on OO3.2.1 this is by default, on LO3.3.2 this is manual by setting in
the XCU file as you suggested

   dbsource.settings.EscapeDateTime = false    ' old hack donated by FS

' test starts here
   RowSet = createUnoService("com.sun.star.sdb.RowSet")
    RowSet.DataSourceName = "Exalon Office"
    RowSet.CommandType = com.sun.star.sdb.CommandType.TABLE
    RowSet.Command = "public.TestTable"
    ResultSetType= com.sun.star.sdbc.ResultSetType.SCROLL_INSENSITIVE

ResultSetConcurrency=com.sun.star.sdbc.ResultSetConcurrency.UPDATABLE
    RowSet.execute()
    RowSet.moveToInsertRow()

'on OO3.2.1 this command completes
'on LO3.3.2 this command fails with and com.sun.star.sdbc.SQLException
' Message: privilege INSERT is not available
'inspecting Rowset.Privileges shows
' on OO3.2.1 == 511
'on LO3.3.2 == 1
'the Rowset.Privileges is RO, so I can not change it

End Sub

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/21

------------------------------------------------------------------------
On 2011-08-09T14:14:54+00:00 Lionel Elie Mamane wrote:

I'm working to improve the postgresql native sdbc driver overall, but in
the meantime, here's a minimal patch that fixes this particular bug.

You need to also increment the version number, or LibreOffice won't
install / register the new oxt file.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/23

------------------------------------------------------------------------
On 2011-08-09T14:16:38+00:00 Lionel Elie Mamane wrote:

Created attachment 50080
minimal patch

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/24

------------------------------------------------------------------------
On 2011-08-15T01:12:25+00:00 Ferry Toth wrote:

Lionel,

I have the sources of LO 3.3.4 and are not exactly sure how to a apply a
patch so that the version number increases.

Instead I just made the patch manually while the build of LO commences
(plenty of time to do that :-) ) resulting in a deb with the same
version number as in the repository. This I 'reinstalled', and it
appears to solve the problem.

Thanks so much.

I did discover some new regressions (fixed in the past by Frank
Schonheit): applying filters on 'date' type colums do not seems to work,
neither in forms nor tables.

This filters are quite useful to users to 'drill down' the data in the
tables to find a particular record and it would be nice if these would
work.

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/25

------------------------------------------------------------------------
On 2011-09-04T12:37:39+00:00 Ulf Mehlig wrote:

(In reply to comment #8)
> The alternative JDBC driver does work but is 10x slower. The performance
> difference is so big that it cannot be considered a 'real' alternative.

same here:

https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/835662

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/27

------------------------------------------------------------------------
On 2011-09-07T09:47:03+00:00 Lionel Elie Mamane wrote:

(In reply to comment #18)

> I have the sources of LO 3.3.4 and are not exactly sure how to a apply a patch
> so that the version number increases.

FWIIW, this was about the version number of the postgresql-sdbc
extension, not of LO.

> Instead I just made the patch manually while the build of LO commences (plenty
> of time to do that :-) ) resulting in a deb with the same version number as in
> the repository. This I 'reinstalled', and it appears to solve the problem.

Ah yes, if you go the .deb route, it works. I was thinking of rebuilding
just postgresql-sdbc and installing the resulting .oxt in LibreOffice.
If the version number has not changed, LO does not do it; one has to
either uninstall and install,or use "unopkg add --force".

> I did discover some new regressions (fixed in the past by Frank Schonheit):
> applying filters on 'date' type colums do not seems to work, neither in forms
> nor tables.

Fixed; see http://wiki.documentfoundation.org/PostgreSQL-SDBC for how to
get the new source code.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/28

------------------------------------------------------------------------
On 2011-10-09T13:08:35+00:00 Ferry Toth wrote:

I just downloaded the Kubuntu 11.10 with LO 3.4.3 and the SDBC driver
0.8.

With this I still can not add/modify records (as opposed to the minimal
patch in comment #17 which did solve the problem).

Things that I can think of that cause this:
- I am not using a password on the database server
- The psql version on the server is 8.3
- I might need to set IgnoreDriverPrivileges

Any/all tips appreciated.

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/29

------------------------------------------------------------------------
On 2011-10-10T01:14:41+00:00 Lionel Elie Mamane wrote:

(In reply to comment #21)
> Kubuntu 11.10 with LO 3.4.3 and the SDBC driver 0.8.

> With this I still can not add/modify records (as opposed to the minimal patch
> in comment #17 which did solve the problem).

> Things that I can think of that cause this:
> - The psql version on the server is 8.3

This is the most likely culprit in my opinion. I use the array function
"unnest" in the driver, and "unnest"  appeared in PostgreSQL 8.4. Take a
look at http://wiki.postgresql.org/wiki/Array_Unnest, it contains
instructions on how to add "unnest" to PostgreSQL 8.3 and lower.

> - I might need to set IgnoreDriverPrivileges

This might indeed work around this particular issue, but I think adding
"unnest" function will be more robust, as it is used also in other parts
of the driver.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/30

------------------------------------------------------------------------
On 2011-10-12T09:24:17+00:00 Ferry Toth wrote:

Lionel,

I can confirm this driver works (tested with Kubuntu Oneric beta) with
postgres 8.4 from debian squeeze (stable).

Thank you so much!

I believe Base connected to postgresql 8.4 now to be giving the best
functionality and performance using the sdbc driver (compared to hsql,
mysql, sqlite using jdbc, odbc or sdbc drivers).

I guess this combination will not be available to windows/mac users
until someone builds the extension and puts it one the extension
website.

I must admit although we have a MS compiler here we have no clue what
the effort would be to build the driver for windows and package it into
an extension.

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/31

------------------------------------------------------------------------
On 2011-11-23T02:03:30+00:00 Lionel Elie Mamane wrote:

We are trying to get my new PostgreSQL-SDBC (which has this bug fixed)
directly integrated in LibreOffice 3.5 beta0. Stay tuned.

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/34

------------------------------------------------------------------------
On 2011-11-23T13:27:43+00:00 Ferry Toth wrote:

That is certainly good news for my Windows using colleagues. As a
Kubuntu user I'm am already happy of course.

Is there a todo list for the driver?

Ferry

Reply at: https://bugs.launchpad.net/df-
libreoffice/+bug/782292/comments/35


** Changed in: df-libreoffice
       Status: Confirmed => In Progress

** Bug watch added: openoffice.org/bugzilla/ #117280
   http://openoffice.org/bugzilla/show_bug.cgi?id=117280

** Bug watch added: freedesktop.org Bugzilla #35944
   https://bugs.freedesktop.org/show_bug.cgi?id=35944

-- 
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/782292

Title:
  Base cannot add/edit records using postgres sdbc driver

Status in LibreOffice Productivity Suite:
  In Progress
Status in “libreoffice” package in Ubuntu:
  Invalid
Status in “libreoffice” package in Debian:
  Fix Released

Bug description:
  Binary package hint: libreoffice

  Open a form or table in base, find there is no add record button.

  Also you can not change any exiting records.

  This problem applies to Natty and LO 3.3.2 when using the postgres
  SDBC driver.

  Ferry

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/782292/+subscriptions