Tag: hsqldb

Integrity constraint violation: unique constraint or index violation HSQLDB

For example if I add new Department(new BigInteger(“50”), “ODD”, “SPB”), all work, it values are insert into database. But if I want again insert for example new Department(new BigInteger(“50”), “ODDMOD”, “SPBMOD”), appear java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: unique constraint or index violation; SYS_PK_10092 table: DEPARTMENT. I know that can not insert values with the same primary key, but how can update

Unique Indexes query for HSQLDB

hsqldb sql

I’ve got a query that selects unique indexes from a MySQL DB table: I am looking to create the equivalent query that works for HSQLDB Any help is much appreciated! Answer That’s available in information_schema.system_indexinfo

“Object not found” error when using multiple table expressions in WITH…AS inside of CREATE VIEW

hsqldb intellij-idea sql

I am trying to create a view based on complex query in HSQLDB (version 2.5.1). The query looks like this (simplified for clarity), also includes DDL for the tables: However, it fails with the following error: [42501][-5501] user lacks privilege or object not found: JOIN in statement [CREATE VIEW TEST_VIEW AS…… The same query runs fine when used as a

Tag: hsqldb

Integrity constraint violation: unique constraint or index violation HSQLDB

Unique Indexes query for HSQLDB

“Object not found” error when using multiple table expressions in WITH…AS inside of CREATE VIEW

org.hsqldb.HsqlException: discrepancy in the number of rows counted

sql syntax error with liquibase using join tables

Perform SQL statement after each DELETE

Avoid duplicate entries using full JOIN with SUM and GROUP BY

Need to perform ORDER by Twice