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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/782292 Title: Base cannot add/edit records using postgres sdbc driver To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/782292/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
