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

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    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