[Libreoffice-bugs] [Bug 119431] External database jdbc hsqldb, Crash in the case of SELECT, SQL query, access to the database

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to Krzysztof from comment #5)
> (In reply to Xisco Faulí from comment #3)
> > You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
> > else confirms it.
> 
> Sorry I do not know. This is my first bug report.

Ok - well, I have some time this afternoon to look at this.

Unfortunately I'll be using Linux so that me be invalid if this is a MS Windows
issue. For instance I have libreOfffice 6.1.03 open right now a HSQL embedded
file open and working without any problems.

Before I start though I can tell  you that if you are attempting to use the
schema in the first comment, including user accounts, in an embedded database
that was in the past problematic. It worked fine if you access all your
tables/queries/forms/reports via scripts in which you create a separate
connection with the none sysdba user account, but the Base UI had real problems
as it always defaults to the default sysdba account. BTW that also allows full
(meaning multi-table/edit) transaction control in an embedded Base file,
something the Base UI interface doesn't fully support.

Secondly there was an old issue regarding external HSQL drivers. In the
Options->Advanced dialog you not only can set the Java install to use (for
instance I have both 10.02 and 1.8.0_181 available, I use 10.02) but with the
'Class path' you can also pick an external hsql driver over the LibreOffice
supplied file - this was necessary in a few builds for the external connection
to work, but then made it impossible to work with the embedded Base files.

If you picked an external jdbc driver with that class parameter that could be
the problem with the embedded Base file.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180823/67a011a5/attachment.html>