java.sql.SQLException: Unexpected token: GENERATED in statement \[create table MYTABLE (ID\_ bigint generated by default as identity (start with 1), primary key (ID\_))\]

hsqldb | tombaeyens | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Unexpected token: GENERATED

    hsqldb | 1 decade ago | tombaeyens
    java.sql.SQLException: Unexpected token: GENERATED in statement \[create table MYTABLE (ID\_ bigint generated by default as identity (start with 1), primary key (ID\_))\]
  2. 0

    GLOBAL TEMPROARY TABLES multiple connection

    hsqldb | 1 decade ago | csplrj
    java.sql.SQLException: Column already exists in statement \[CREATE TABLE UtilityRelationship (AId INTEGER,MasterTableId INTEGER,MasterTableId INTEGER,MasterColumn VARCHAR,ChildColumn VARCHAR,MasterColumnGetSet VARCHAR,ChildColumnGetSet VARCHAR,RelationshipTypeId INTEGER,ExtraFieldFieldName VARCHAR,ExtraFieldIndex INTEGER,TableListSingleRecord BOOLEAN,TableListWidth INTEGER)\]
  3. 0

    Assert failed

    hsqldb | 1 decade ago | arunkr
    java.sql.SQLException: Assert failed in statement \[SELECT \*  FROM TLM\_EVENT\_HISTORY WHERE eh\_id = (SELECT MAX(eh\_id) FROM TLM\_EVENT\_HISTORY WHERE process\_id=? AND version=? AND domain=? AND instance=? AND run\!=0)\]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    out of memory? DB-confusion?!

    hsqldb | 1 decade ago | cswolf123
    java.sql.SQLException: File input/output error: java.io.IOException: end of line characters not allowed in statement \[insert into REPORTS (RID,PRID,CID,CNAME,CPERSON,HASH,DRIVETIME,RDATE,KMSTART,KMEND,KMPRIV,AMID,STATUS,SENDSTART,SENT,CSPEAKING,CAR,BAKKMSTART,BAKKMEND,BAKKMPRIV,BAKRDATE,DISABLED) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?);\]
  6. 0

    object serialization exception in server mod

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: Serialization failure: cygnus.sqa.testing.Trial      in statement \[INSERT INTO TEST1 (id,obj) values (1,'aced0005737200186     379676e75732e7371612e74657374696e672e547269616cf7b0748bab1d870b0200014     900046e436e7478700000000a')\]     at org.hsqldb.Trace.getError(Unknown Source)

    Root Cause Analysis

    1. java.sql.SQLException

      Unexpected token: GENERATED in statement \[create table MYTABLE (ID\_ bigint generated by default as identity (start with 1), primary key (ID\_))\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcPreparedStatement.execute
      1. org.hsqldb.Trace.getError(Trace.java:263)
      2. org.hsqldb.jdbcResultSet.<init>(jdbcResultSet.java:6660)
      3. org.hsqldb.jdbcConnection.executeStandalone(jdbcConnection.java:3001)
      4. org.hsqldb.jdbcConnection.execute(jdbcConnection.java:2579)
      5. org.hsqldb.jdbcStatement.fetchResult(jdbcStatement.java:1804)
      6. org.hsqldb.jdbcStatement.execute(jdbcStatement.java:728)
      7. org.hsqldb.jdbcPreparedStatement.execute(jdbcPreparedStatement.java:1279)
      7 frames
    3. Unknown
      HsqldbTest.testHypersonic
      1. HsqldbTest.testHypersonic(HsqldbTest.java:16)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    5. JUnit
      TestSuite.run
      1. junit.framework.TestCase.runTest(TestCase.java:154)
      2. junit.framework.TestCase.runBare(TestCase.java:127)
      3. junit.framework.TestResult$1.protect(TestResult.java:106)
      4. junit.framework.TestResult.runProtected(TestResult.java:124)
      5. junit.framework.TestResult.run(TestResult.java:109)
      6. junit.framework.TestCase.run(TestCase.java:118)
      7. junit.framework.TestSuite.runTest(TestSuite.java:208)
      8. junit.framework.TestSuite.run(TestSuite.java:203)
      8 frames
    6. JUnit3 Runner
      RemoteTestRunner.main
      1. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
      2. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
      3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
      3 frames