CLOB « hsqldb « Java Database Q&A

  1. Java Database Q&A
  2. hsqldb
  3. CLOB




1. Storing long strings (CLOB) in Hsqldb databases?    stackoverflow.com

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 ...

2. Using HSQLDB trying to store large data HTML source code clobs not implemented?    coderanch.com

Im trying to use a clob data type to store html source code because those files can get pretty large. However, it appears none of the setters to write clobs are currently supported? How else can I store this kind of data to a column in my hsqld? varchar is too small? Please any help will be greatly appreciated. Here what ...