Bug 124767 - EDITING: External database jdbc hsqldb, Error in the New Record Base
Summary: EDITING: External database jdbc hsqldb, Error in the New Record Base
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-04-16 12:04 UTC by Krzysztof
Modified: 2019-04-16 13:07 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Krzysztof 2019-04-16 12:04:03 UTC
I am connecting to the database JDBC.
URL: JDBC:hsqldb:hsql://localhost:9001/xGR;default_schema=true
Class driver: org.hsqldb.jdbcDriver (hsqldb-2.4.1).

Everything is ok. I see tables.

I'm trying to add a row to the table ODBIORCA. I'm getting an error. Opening, adding a row I get:
"Error in the new record"
user lacks privilege or object not found: ODBIORCA in statement [INSERT INTO "ODBIORCA" ( "NAZWA","SKASOWANIE") VALUES ( ?,?)]

By executing the sql command "INSERT INTO ODBIORCA (NAZWA) VALUES ('Test')" getting:
"Error in the new record"
"user lacks privilege or object not found: ODBIORCA"

The table was created with the dbeaver program:
CREATE CACHED TABLE ODBIORCA (
	ID INTEGER PRIMARY KEY NOT NULL IDENTITY,
	NAZWA VARCHAR(60) NOT NULL UNIQUE,
	TELEFON_KOMORKOWY VARCHAR(20),
	TELEFON_STACJONARNY VARCHAR(20),
	EMAIL VARCHAR(60),
	KOLEJNOSC SMALLINT,
	SKASOWANIE BOOLEAN DEFAULT FALSE NOT NULL,
);
Comment 1 Krzysztof 2019-04-16 13:07:56 UTC
You need to check your access rights carefully. SQL command: GRAND.