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

hsqldb | csplrj | 1 decade ago
  1. 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)\]
  2. 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\_))\]
  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

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

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcPreparedStatement.execute
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.jdbcResultSet.<init>(Unknown Source)
      3. org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      4. org.hsqldb.jdbcConnection.execute(Unknown Source)
      5. org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      6. org.hsqldb.jdbcStatement.execute(Unknown Source)
      7. org.hsqldb.jdbcPreparedStatement.execute(Unknown Source)
      7 frames