Re: script bug?: unexpected token 'INFORMATION_SCHEMA'

This is a bug in 2.2.9 which has been fixed for version 2.3.0

Edit the .script file and remove the COLLATE
INFORMATION_SCHEMA.SQL_TEXT from CREATE TYPE statements. You can then
use the latest snapshot jar for 2.3.0 (no 35) to open and use the
database.

http://www.hsqldb.org/repos/org/hsqldb/hsqldb/SNAPSHOT/

Fred

On Sun, Feb 24, 2013, at 18:18, Luciano wrote:

  I've been building a demo db with hsqldb release 2.2.9,
  creating/deleting schemas via the sqltool. But I've found that now
  I'm unable to start the database. I get the following error when
  trying to load the DB:
  [Thread[HSQLDB Server @1b9b7dfa,5,main]]: Database [index=0,
  db=file:/var/lib/hsqldb-2/ectodb, alias=ectodb] did not open:
  org.hsqldb.HsqlException: error in script file line: 44 unexpected
  token: INFORMATION_SCHEMA
  The actual script file looks like this, up to the offending line
  #44:
  SET DATABASE UNIQUE NAME HSQLDB3CF40486C2
  SET DATABASE GC 0
  SET DATABASE DEFAULT RESULT MEMORY ROWS 0
  SET DATABASE EVENT LOG LEVEL 0
  SET DATABASE SQL NAMES FALSE
  SET DATABASE SQL REGULAR NAMES TRUE
  SET DATABASE SQL REFERENCES FALSE
  SET DATABASE SQL SIZE TRUE
  SET DATABASE SQL TYPES FALSE
  SET DATABASE SQL TDC DELETE TRUE
  SET DATABASE SQL TDC UPDATE TRUE
  SET DATABASE SQL TRANSLATE TTI TYPES TRUE
  SET DATABASE SQL CONCAT NULLS TRUE
  SET DATABASE SQL NULLS FIRST TRUE
  SET DATABASE SQL UNIQUE NULLS TRUE
  SET DATABASE SQL CONVERT TRUNCATE TRUE
  SET DATABASE SQL AVG SCALE 0
  SET DATABASE SQL DOUBLE NAN TRUE
  SET DATABASE SQL LONGVAR IS LOB FALSE
  SET DATABASE TRANSACTION CONTROL LOCKS
  SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
  SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE
  SET DATABASE TEXT TABLE DEFAULTS ''
  SET DATABASE DEFAULT TABLE TYPE CACHED
  SET FILES WRITE DELAY 500 MILLIS
  SET FILES BACKUP INCREMENT TRUE
  SET FILES CACHE SIZE 10000
  SET FILES CACHE ROWS 50000
  SET FILES SCALE 32
  SET FILES LOB SCALE 32
  SET FILES DEFRAG 0
  SET FILES NIO TRUE
  SET FILES NIO SIZE 256
  SET FILES LOG TRUE
  SET FILES LOG SIZE 50
  CREATE ROLE ECTOSA
  CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e'
  ALTER USER SA SET LOCAL TRUE
  CREATE SCHEMA PUBLIC AUTHORIZATION DBA
  CREATE SCHEMA ECTODB AUTHORIZATION ECTOSA
  CREATE DOMAIN ECTODB.TRADEWAY AS CHARACTER(1) CONSTRAINT
  SYS_CT_10104 CHECK((VALUE) IN (('B'),('S')))
  CREATE TYPE ECTODB.QUANTITY AS INTEGER
  CREATE TYPE ECTODB.PRICE AS DOUBLE
  CREATE TYPE ECTODB.BOOKID AS VARCHAR(5) COLLATE
  INFORMATION_SCHEMA.SQL_TEXT
  There are a number of similar statements further down the file (i.e.
  create type  ... collate information_schema.sql_text), so it doesn't
  appear to be corrupt. In my sql file I had something along the lines
  of:
  create  domain TRADE_WAY            as  char check (value in
  ('B','S'));
  create  type  BOOK_ID               as  varchar(5);
  Like I stated above, I did drop and recreate schemas several times,
  withouth checkpointing in between. And I think I restarted the
  system once without a clean shutdown in between. Is this a bug or am
  I doing something obviously wrong?
  Thanks in advance,
  Luciano

-----------------------------------------------------------------------
-------

Everyone hates slow websites. So do we.

Make your web apps faster with AppDynamics

Download AppDynamics Lite for free today:

[1]http://p.sf.net/sfu/appdyn_d2d_feb

_______________________________________________

Hsqldb-user mailing list

[2][email protected]

[3]https://lists.sourceforge.net/lists/listinfo/hsqldb-user

References

1. http://p.sf.net/sfu/appdyn_d2d_feb
2. mailto:[email protected]
3. https://lists.sourceforge.net/lists/listinfo/hsqldb-user

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user