Storing long strings (CLOB) in Hsqldb databases?

Question

So here's some code:

statement.executeUpdate("CREATE TABLE SomeTable(id INTEGER IDENTITY, " +
    "text CLOB)");

which throws an exception "Wrong data type: CLOB in statement [...]". Is there a way to store CLOBs in Hsqldb databases? The documentation says it is. Or maybe my knowledge of SQL is so rusty that I forgot how to define them.

Answer 1

Try LONGVARCHAR instead of CLOB