[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 Alex Thurgood changed: What|Removed |Added Resolution|--- |WORKSFORME

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #37 from Alex Thurgood --- (In reply to Robert Großkopf from comment #36) > (In reply to Alex Thurgood from comment #35) > 3) Set the Advanced Parameters to Respect Driver Privileges (last tick box > on Advanced Settings -

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #36 from Robert Großkopf --- (In reply to Alex Thurgood from comment #35) Hi Alex, > > Error message: > SQLite only supports TYPE_FORWARD_ONLY cursors Sometimes I also have to look what I have written in Base Handbuch. You

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #35 from Alex Thurgood --- Still not working for me with Version: 7.5.0.0.beta1 (AARCH64) / LibreOffice Community Build ID: 3aca23eec42e9d6fbe57071d7633ae1fc4bc5fcc CPU threads: 8; OS: Mac OS X 13.0.1; UI render: default;

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #34 from Robert Großkopf --- Have tried also the attachment https://bugs.documentfoundation.org/attachment.cgi?id=117649 (Db schema). Tables will be created, could input data, but relations won't work as expected. But this

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #33 from Robert Großkopf --- Tried this one with LO 7.4.3.2 and sqlite-jdbc-3.40.0.0.jar Could create a table in SQLite, could input new rows, could change content of existing rows. No buggy behavior appears. System here:

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #32 from Alex Thurgood --- Bug still present in Version: 7.2.5.2 / LibreOffice Community Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5 CPU threads: 8; OS: Mac OS X 12.2.1; UI render: default; VCL: osx Locale: fr-FR

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #31 from Tyler --- Still reproducible with- Version: 6.4.3.2 (x64) Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8 CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; Locale: en-US (en_US);

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #30 from Alex Thurgood --- (In reply to Alex Thurgood from comment #29) > Problem still reproducible with > > Version: 6.4.0.0.alpha0+ > Build ID: e04b6f3c0cdacf2a3cdcd3f34bad54c8764ff1ed > CPU threads: 4; OS: Mac OS X

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #29 from Alex Thurgood --- Problem still reproducible with Version: 6.4.0.0.alpha0+ Build ID: e04b6f3c0cdacf2a3cdcd3f34bad54c8764ff1ed CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; Locale: fr-FR

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #28 from QA Administrators --- Dear Alex Thurgood, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #27 from Alex Thurgood --- Still reproducible with Xerial JDBC driver : 3.14.2.1 and Version: 6.2.0.0.alpha0+ Build ID: fa7ebc82bbcee15cd75b42d1e7b8ef66ed719225 CPU threads: 4; OS: Mac OS X 10.13.5; UI render: default;

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #26 from Julien Nabet --- On pc Debian x86-64 with master sources updated yesterday + sqlite-jdbc-3.21.0.jar (2017-11-14), I don't reproduce this because I got the message: SQLite JDBC: inconsistent

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 Alex Thurgood changed: What|Removed |Added Keywords||haveBacktrace

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #25 from Tyler --- Just wanted to add a bit of information- When creating a new query in Base, running the query results in the same error, and setting it to "Run SQL Directly" completes, but

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #24 from Tyler --- Still reproducible with- LibreOffice Version: 5.4.3.2 (x64) Build ID: 92a7159f7e4af62137622921e809f8546db437e5 CPU threads: 4; OS: Windows 6.19; UI render: default; Locale:

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #23 from Alex Thurgood --- Still reproducible with Version: 5.3.4.2 Build ID: f82d347ccc0be322489bf7da61d7e4ad13fe2ff3 Threads CPU : 4; Version de l'OS :Mac OS X 10.12.5; UI Render : par défaut; Moteur de

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #22 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 Alex Thurgood changed: What|Removed |Added Status|UNCONFIRMED |NEW

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 Alex Thurgood changed: What|Removed |Added Version|4.4.5.2 release |4.4.3.2

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #20 from Alex Thurgood --- (In reply to Lionel Elie Mamane from comment #3) > Is the Primary Key showed in "edit table"? If not, the primary key is likely > not shown as such by the JDBC driver, i.e. (in

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 Alex Thurgood changed: What|Removed |Added OS|Mac OS X (All) |All -- You

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #21 from Alex Thurgood --- On Linux Mint 17.2 with LO Version: 4.4.3.2 Build ID: 40m0(Build:2) Locale : fr_FR the pre-created SQLite3 tables remain read-only. Not only can one not display the data in any

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #17 from Alex Thurgood ipla...@yahoo.co.uk --- It would appear from this : https://groups.google.com/d/msg/ward-tools-dev/3hHnFuzFfIw/jOkXy4m0qJMJ that a similar problem exists with the Zentus JDBC driver, i.e. a connection

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #18 from Alex Thurgood ipla...@yahoo.co.uk --- So perhaps one of the questions should be : why doesn't LO support TYPE_FORWARD_ONLY cursors ? Or, does it, and it just can't understand the Zentus and Xerial drivers. Note that

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #14 from Julien Nabet serval2...@yahoo.fr --- I missed have missed something but if the problem is Xerial driver, why shouldn't we put this one NOTOURBUG? -- You are receiving this mail because: You are the assignee for the

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #15 from Alex Thurgood ipla...@yahoo.co.uk --- (In reply to Julien Nabet from comment #14) I missed have missed something but if the problem is Xerial driver, why shouldn't we put this one NOTOURBUG? Because the Xerial

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #16 from Julien Nabet serval2...@yahoo.fr --- (In reply to Alex Thurgood from comment #15) (In reply to Julien Nabet from comment #14) I missed have missed something but if the problem is Xerial driver, why shouldn't we

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #11 from Alex Thurgood ipla...@yahoo.co.uk --- Enclosing bt. The first SIGSEV occurs after loading the ODB file and clicking on the Tables icon. I pulled a bt from that before continuing. The bt in thread 39 seems to indicate

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #12 from Alex Thurgood ipla...@yahoo.co.uk --- Created attachment 117648 -- https://bugs.documentfoundation.org/attachment.cgi?id=117648action=edit bt on master -- You are receiving this mail because: You are the assignee

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #13 from Alex Thurgood ipla...@yahoo.co.uk --- Created attachment 117649 -- https://bugs.documentfoundation.org/attachment.cgi?id=117649action=edit SQLite3 Db schema - salespeople database -- You are receiving this mail

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #8 from Alex Thurgood ipla...@yahoo.co.uk --- DBVisualiser relies on the Xerial JDBC driver and enables editing of SQLite databases from within DbVisualiser, so the problem would appear to lie with the way LibreOffice talks to

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #9 from Alex Thurgood ipla...@yahoo.co.uk --- If I create a fresh database from within LO using the Xerial jdbc driver, I can create a new table, eg : Table rainfall id INTEGER NOT NULL qty REAL Set id as Primary Key via GUI

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #10 from Alex Thurgood ipla...@yahoo.co.uk --- (In reply to Alex Thurgood from comment #8) DBVisualiser relies on the Xerial JDBC driver and enables editing of SQLite databases from within DbVisualiser, so the problem would

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 --- Comment #7 from Alex Thurgood ipla...@yahoo.co.uk --- (In reply to Rolf Leggewie from comment #6) that indeed does sound a lot like the Xerial driver has some issue with primary keys in sqlite databases. I remember you were

[Libreoffice-bugs] [Bug 93094] Editing - sqlite3 tables read only even when defined with primary key using Xerial jdbc driver

https://bugs.documentfoundation.org/show_bug.cgi?id=93094 Alex Thurgood ipla...@yahoo.co.uk changed: What|Removed |Added Summary|Editing - sqlite3 tables|Editing -