Script stops working on HSQLDB 1.9.0-rc6
Posted
by jacklty
on Stack Overflow
See other posts from Stack Overflow
or by jacklty
Published on 2009-11-20T21:19:41Z
Indexed on
2010/06/08
1:02 UTC
Read the original article
Hit count: 430
hsqldb
DROP VIEW V1 IF EXISTS;
DROP TABLE T1 IF EXISTS;
CREATE TABLE T1 (id INT, name VARCHAR(32), age int);
CREATE VIEW V1 AS (SELECT * FROM T1 WHERE age < 21);
I have no problem to execute the SQL statement above in one JDBC statement or on the SWING Manager from HSQLDB. Now it stops working on 1.9.0-rc6. This is error message I got - "user lacks privilege or object not found: T1 / Error Code: -5501 / State: 42501"
Does anyone know what have changed in 1.9.0-XX which made it not working?
Thanks
© Stack Overflow or respective owner