java.sql.SQLException

Unexpected token: TEMPORARY in statement \[CREATE TEMPORARY TABLE UtilityRelationship (Id INTEGER,MasterTableId INTEGER,ChildTableId INTEGER,MasterColumn VARCHAR,ChildColumn VARCHAR,MasterColumnGetSet VARCHAR,ChildColumnGetSet VARCHAR,RelationshipTypeId INTEGER,ExtraFieldFieldName VARCHAR,ExtraFieldIndex INTEGER,TableListSingleRecord BIT,TableListWidth INTEGER)\]

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web132

  • via hsqldb by tombaeyens
    ,
  • via hsqldb by arunkr
    ,
  • Stack trace

    • java.sql.SQLException: Unexpected token: TEMPORARY in statement \[CREATE TEMPORARY TABLE UtilityRelationship (Id INTEGER,MasterTableId INTEGER,ChildTableId INTEGER,MasterColumn VARCHAR,ChildColumn VARCHAR,MasterColumnGetSet VARCHAR,ChildColumnGetSet VARCHAR,RelationshipTypeId INTEGER,ExtraFieldFieldName VARCHAR,ExtraFieldIndex INTEGER,TableListSingleRecord BIT,TableListWidth INTEGER)\] at org.hsqldb.Trace.getError(Unknown Source) at org.hsqldb.jdbcResultSet.<init>(Unknown Source) at org.hsqldb.jdbcConnection.executeStandalone(Unknown Source) at org.hsqldb.jdbcConnection.execute(Unknown Source) at org.hsqldb.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbcStatement.execute(Unknown Source) at org.hsqldb.jdbcPreparedStatement.execute(Unknown Source) at javaapplication1.Main.a(Main.java:37) at javaapplication1.Main.main(Main.java:28)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,