Error "user lacks privilege or object not found" after table creation

[artem78]

Hi @prrvchr !

I hope you're not tired of me, but I have another problem. This time with HyperSQLOOo extension.

I have installed both jdbcDriverOOo and HyperSQLOOo to LibreOffice as described here for using modern HsqlDB 2.7.

I created new database with embedded HsqlDB with one simple table.

Next when I open this table for data insertion this error shows:

Error details:

SQL Status: 42501
Error code: -5501

I run this SQL query manually to show all tables:

SELECT *
FROM   INFORMATION_SCHEMA.TABLES

But my table not listed in the output.

Issue described here reproduced both in Linux and Windows, also with latest LibreOffice 7.6.3 release.

Sample database file: mydb.odb.zip

[prrvchr]

Hi artem78,

This is not an error, we cannot create a table in the INFORMATION_SCHEMA schema, this is a schema reserved for the system and we must either create a new schema or use the default PUBLIC schema.

It is true that it would be good if the HyperSQLOOo driver gave an error rather than letting people believe that the table was created... I will try to correct this...

[prrvchr]

I just pushed jdbcDriverOOo version 1.0.7. Now an error appears instead of making it appear that the table was created...
Thanks for helping to improve the extensions...

[artem78]

Thanks.