Our application uses HSQLDB database with external server process. Using LO v22.214.171.124, clicking on a database table owned by PUBLIC shows no records. Using a table owned by non-PUBLIC user shows all records as expected.
Steps to Reproduce:
1. Open BASE app with tables owned by PUBLIC and non-PUBLIC users.
2. Open table owned by non-PUBLIC user, verify records displayed
3. Open table owned by PUBLIC user
No records displayed
All records displayed
User Profile Reset: No
Version: 126.96.36.199 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
@Andrew : did this work correctly in a previous version of LibreOffice ?
How do you manage the difference between PUBLIC and non-PUBLIC users with regard to schema access ?
Can you give us an example of the connection string entered in the ODB JDBC driver configuration (obviously anonymizing any credentials or IP addresses, if any) ?
Can't test on macOS, unfortunately, changing the JAR for server access hoses the access to my existing embedded hsqldb files.
Created attachment 175035 [details]
HSQLDB *.script file (redacted)
The *.script for for the external database.
Note all persistent database objects are created under schema "PUBLIC". Temporary tables are under non-"PUBLIC" schemas.
@Alex, this bad behavior seems to have been introduced in the LO 7.x releases. I cannot say exactly when it first appeared. I developed our application using LO 6.x, and used the table record viewer extensively at this time. Only on doming recent maintenance did I discover the bad behavior.
I have uploaded the HSQLDB *.script file so you can clearly see how the database objects are defined. I suspect this my be related to object ownership/privilege's as the viewer works fine for objects owned by the current user.
Here is the JDBC connection string (using localhost instead of true IP address).
I see this problem on both Windows and MacOS environments.
I verified the following LO version does NOT have this issue, "PUBLIC" tables content is displayed as expected. So something changed in the LO 7.x timeframe.
Version: 188.8.131.52 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: GL; VCL: win;
Locale: en-US (en_US); UI-Language: en-US
Quieres comprar Cama nido 135x190? ¡Encuentralos aquí! ✓ Todo en stock y envío rápido. Si buscas comprar muebles online al mejor precio, esta es tu tienda.