2.4
2.3
2.2
2.0
1.8
URL format | jdbc:hsqldb:file:file |
---|---|
Ships with MigrateDB Command-line | Yes |
Maven Central coordinates | org.hsqldb:hsqldb:2.4.1 |
Supported versions | 1.8 and later |
Default Java class | org.hsqldb.jdbcDriver |
BEGIN ATOMIC ... END;
block/* Single line comment */
CREATE TABLE usertable (
value VARCHAR(25) NOT NULL PRIMARY KEY
);
/*
Multi-line
comment
*/
-- Sql-style comment
-- Placeholder
INSERT INTO ${tableName} (name) VALUES ('Mr. T');
CREATE TRIGGER uniqueidx_trigger BEFORE INSERT ON usertable
REFERENCING NEW ROW AS newrow
FOR EACH ROW WHEN (newrow.name is not null)
BEGIN ATOMIC
IF EXISTS (SELECT * FROM usertable WHERE usertable.name = newrow.name) THEN
SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'duplicate name';
END IF;
END;
SELECT ... FOR UPDATE
locking