java.sql.SQLException: SQL statement failed: CREATE INDEX `test_some_field_idx` ON `test` ( `some_field` )

ormlite | *anonymous | 5 years ago
  1. 0

    createTableIfNotExists and indexes

    ormlite | 5 years ago | *anonymous
    java.sql.SQLException: SQL statement failed: CREATE INDEX `test_some_field_idx` ON `test` ( `some_field` )
  2. 0

    An exception when creating/updating a string field

    ormlite | 5 years ago | *anonymous
    java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "This": syntax error)
  3. 0

    two remaining errors

    GitHub | 3 years ago | dflahaut
    java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "Automator": syntax error)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 9#56070909

    GitHub | 2 years ago | chipmunc56
    java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: history)

    2 unregistered visitors
    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

      [SQLITE_ERROR] SQL error or missing database (index test_some_field_idx already exists)

      at org.sqlite.DB.newSQLException()
    2. SQLite JDBC
      Conn.prepareStatement
      1. org.sqlite.DB.newSQLException(DB.java:383)
      2. org.sqlite.DB.newSQLException(DB.java:387)
      3. org.sqlite.DB.throwex(DB.java:374)
      4. org.sqlite.NativeDB.prepare(Native Method)
      5. org.sqlite.DB.prepare(DB.java:123)
      6. org.sqlite.PrepStmt.<init>(PrepStmt.java:42)
      7. org.sqlite.Conn.prepareStatement(Conn.java:404)
      8. org.sqlite.Conn.prepareStatement(Conn.java:399)
      8 frames
    3. ORMLite JDBC
      JdbcDatabaseConnection.compileStatement
      1. com.j256.ormlite.jdbc.JdbcDatabaseConnection.compileStatement(JdbcDatabaseConnection.java:84)
      1 frame
    4. ORMLite Core
      TableUtils.doStatements
      1. com.j256.ormlite.table.TableUtils.doStatements(TableUtils.java:451)
      1 frame