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: 437

Filed under:

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

Related posts about hsqldb

HSQLDB connection error

as seen on Stack Overflow - Search for 'Stack Overflow'
I created a java program for connect the HSQLDB , the first one works well, public final static String DRIVER = "org.hsqldb.jdbcDriver"; public final static String URL = "jdbc:hsqldb:file:F:/hsqlTest/data/db"; public final static String DBNAME = "SA"; but these are not public final static String… >>> More
HSQLDB Constraint Violation & SQL Query Log for an HSQLDB in-memory setup

as seen on Stack Overflow - Search for 'Stack Overflow'
We have a setup where we are using an embedded HSQLDB for backing Hibernate/JPA unit tests in java, and we are using the in-memory database mode since we simply want the database thrown away after the test run. My problem is that one of the tests is failing due to a constraint violation and HSQLDB… >>> More
Getting java.lang.OutOfMemoryError: Java heap space

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting an Exception in thread "HSQLDB Connection @3c50507" java.lang.OutOfMemoryError: Java heap space, when running a JSP. what is the thing that is out of memory? eclipse, HSQLDB or Tomcat?? i am using all that in a Mac OS X 10.7.4 When i start HSQLDB, then i get by console this exception: [Server@122ce908]:… >>> More
Atomic INSERT/SELECT in HSQLDB

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I have the following hsqldb table, in which I map UUIDs to auto incremented IDs: SHORT_ID (BIG INT, PK, auto incremented) | UUID (VARCHAR, unique) Create command: CREATE TABLE table (SHORT_ID BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY, UUID VARCHAR(36) UNIQUE) In order to add… >>> More
HSQLDB how to manually insert records

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, My question is how can I manually add records to hsqldb database. I mean using command line or some client. I know I can use hsqldb manager but I cannot execute any query with it. It says that there is no table of specified name. What might be the problem? >>> More

Developer IT