https://bugs.documentfoundation.org/show_bug.cgi?id=156471

--- Comment #16 from Lionel Elie Mamane <lio...@mamane.lu> ---
(In reply to prrvchr from comment #14)
> screenshots: New database Wizard with url sdbc:embedded:sqlite
> Does not show a embedded database Wizard. We have three steps in the browser
> (including one to choose the connection url)

Why do you need the extra step to choose the connection URI? Since you already
added an extra entry to the drop-down menu in the choice for "Embedded
database", why doesn't making that choice also set the correct URI and that's
it?

> The problem is that to declare a driver in embedded mode the only solution
> is to use the url: sdbc:embedded:hsqldb.

Well, that is clearly not true, since the firebird embedded driver doesn't use
URI sdbc:embedded:hsqldb but uses sdbc:embedded:firebird.

I feel we are not understanding each other at some level.

>> So the data will be saved when changing the row and not when closing my Base 
>> file - with all the problems of loosing data while file couldn't be closed 
>> right way.

> With the HsqlDriverOOo and SQLiteOOo extensions which work in integrated
> mode (everything is in the odb file) if you insert 2 rows in a table, you
> kill the soffice daemon, you open LibreOffice again: you have lost
> nothing... Anyway that's what I checked with HsqlDB.

LibreOffice has battled with corruption issues in the ZIP structure of the odb
file with embedded database since ages. If you have found a robust solution,
that works on any mix of changes of the table data and the other content of the
odb file (queries, reports, forms, ...),  I'd be very happy to have it applied
to all embedded databases (historic HSQLDB, Firebird, ...).

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to