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

ormlite | *anonymous | 6 years 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

    createTableIfNotExists and indexes

    ormlite | 6 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 | 4 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 | 3 years ago | chipmunc56
    java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (no such table: history)

  1. linxiaolong 36 times, last 6 months ago
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