java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "This": syntax error)

ormlite | *anonymous | 5 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 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)
  2. 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` )
  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 5 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 (near "This": syntax error)

    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
    StatementExecutor.update
    1. com.j256.ormlite.stmt.mapped.MappedPreparedStmt.compile(MappedPreparedStmt.java:40)
    2. com.j256.ormlite.stmt.StatementExecutor.update(StatementExecutor.java:353)
    2 frames