User lacks privilege or object not found using HSQLDB connection

MLe_Cloerec1596550144 — Sat, 16 Nov 2024 01:44:37 GMT

Hi everyone,

I'm currently doing a comparision between Stambia and Talend. For this, I wanted to use the same data. So I tried to use the data available for Stambia tutorials. These are coming from an HSQL Database.

For this, I made a HSQLDB Sever with simples proprieties :

server.database.0 = file:hsqldb/demodb

server.dbname.0 = testdb

After that, I added the script whose coming from Stambia into my new database "demodb", you can find it into demodb.txt

Now, I made an HSQLDB connection in Talend and I retrieve schema, so I have every tables of base_datamart in Talend.

I created a job with a source (delimited file) to charge my DIM_Discount table through a tMap.

But when I run the job, I get the error : Exception in component tHSQLDbOutput_1 (Load_DIM_DISCOUNT)

java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: DIM_DISCOUNT

I made research for about 2 days but I didn't find any solutions... if someone ever faced this problem, or has any idea for this, I would be really pleased.

Have a good day, thanks.

Re: User lacks privilege or object not found using HSQLDB connection

manodwhb — Tue, 04 Aug 2020 15:16:16 GMT

@Maxim Le Cloerec ,check the below link and check for that table may be case sensitive. try to use lower case of table name.

https://stackoverflow.com/questions/38415734/hsql-database-user-lacks-privilege-or-object-not-found-error

Thanks,

Manohar

topic User lacks privilege or object not found using HSQLDB connection in Talend Studio

User lacks privilege or object not found using HSQLDB connection

Re: User lacks privilege or object not found using HSQLDB connection