HSQLDB 2.0.0: unexpected token: TO

Help
2012-11-26
2014-01-19
  • Matt Stromske

    Matt Stromske - 2012-11-26

    Hello,
      I'm attempting to upgrade from 1.8.1 to 2.0.0.  When I open the database, I get the following exception:

      java.sql.SQLException: error in script file line: 39 unexpected token: TO
          at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
          at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
          at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
          at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
          at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)
          at java.sql.DriverManager.getConnection(DriverManager.java:582)
          at java.sql.DriverManager.getConnection(DriverManager.java:185)
          at org.hsqldb.util.ConnectionDialogSwing.createConnection(Unknown Source)
          at org.hsqldb.util.DatabaseManagerSwing.main(Unknown Source)
          Caused by: org.hsqldb.HsqlException: error in script file line: 39 unexpected token: TO
          at org.hsqldb.error.Error.error(Unknown Source)
          at org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source)
          at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
          at org.hsqldb.persist.Log.processScript(Unknown Source)
          at org.hsqldb.persist.Log.open(Unknown Source)
          at org.hsqldb.persist.Logger.openPersistence(Unknown Source)
          at org.hsqldb.Database.reopen(Unknown Source)
          at org.hsqldb.Database.open(Unknown Source)
          at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
          at org.hsqldb.DatabaseManager.newSession(Unknown Source)
          … 7 more
          Caused by: org.hsqldb.HsqlException: unexpected token: TO
          at org.hsqldb.error.Error.parseError(Unknown Source)
          at org.hsqldb.ParserBase.unexpectedToken(Unknown Source)
          at org.hsqldb.ParserBase.checkIsNonCoreReservedIdentifier(Unknown Source)
          at org.hsqldb.ParserDQL.checkIsSchemaObjectName(Unknown Source)
          at org.hsqldb.ParserDQL.readNewSchemaObjectName(Unknown Source)
          at org.hsqldb.ParserDDL.compileRightGrantOrRevoke(Unknown Source)
          at org.hsqldb.ParserDDL.compileGrantOrRevoke(Unknown Source)
          at org.hsqldb.ParserCommand.compilePart(Unknown Source)
          at org.hsqldb.ParserCommand.compileStatement(Unknown Source)
          at org.hsqldb.Session.compileStatement(Unknown Source)
          … 16 more

    Script contains (line numers included)
    .
    .
    .
    35 GRANT DBA TO SA
    36 GRANT ALL ON PUBLIC.GRP_ROLE_JOIN TO BRLAP
    37 GRANT ALL ON PUBLIC.ROLE TO BRLAP
    38 GRANT ALL ON PUBLIC.USR_ROLE_JOIN TO BRLAP
    39 GRANT ALL ON PUBLIC.SEQUENCE TO BRLAP
    40 GRANT ALL ON PUBLIC.USR_GRP_JOIN TO BRLAP
    .
    .
    .

    Any idea what is causing this?
    Thanks,
    Matt

     
  • Fred Toussi

    Fred Toussi - 2012-11-26

    Is probably has a problem with the table named SEQUENCE in the public schema.

    Please use the latest version, which is currently 2.2.9.  You can also use the latest jar snapshot from the "support" page.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks