java.sql.SQLException: Problems executing Android query: SELECT * FROM `file` WHERE (`path` = '/Marketing/Datasheets/What's_New.pdf' AND `persisted` = 1 )

ormlite | cuak | 2 years ago
  1. 0

    JellyBeanApiCompatibility bug with apostrophes

    ormlite | 2 years ago | cuak
    java.sql.SQLException: Problems executing Android query: SELECT * FROM `file` WHERE (`path` = '/Marketing/Datasheets/What's_New.pdf' AND `persisted` = 1 )
  2. 0

    Why does my createOrUpdate() call fail?

    Stack Overflow | 1 year ago | John Ernest Guadalupe
    java.sql.SQLException: queryForLong from database failed: SELECT COUNT(*) FROM `table` WHERE `id` = ?
  3. 0

    Syntax error when querying SQLite

    Stack Overflow | 11 months ago | java progammera
    android.database.sqlite.SQLiteException: near "(": syntax error (code 1): , while compiling: select * from appointments_table where strftime ('%d.%m.%Y', date) > now.strftime('%d.%m.%Y')
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    `SQLiteException: no such collation sequence: JSON` on Barnes & Noble NOOK HD/HD+

    GitHub | 2 years ago | Takhion
    android.database.sqlite.SQLiteException: no such collation sequence: JSON: , while compiling: SELECT key, value, docid, revs.sequence, revid, json FROM maps, revs, docs WHERE maps.view_id=? AND key in (?) AND revs.sequence = maps.sequence AND docs.doc_id = revs.doc_id ORDER BY key LIMIT ? OFFSET ?
  6. 0

    SQL error in getConflictingRevisions()

    GitHub | 4 years ago | pegli
    android.database.sqlite.SQLiteException: near "OFFSET": syntax error: , while compiling: SELECT revid FROM revs WHERE doc_id=? AND current ORDER BY revid DESC OFFSET 1
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. android.database.sqlite.SQLiteException

    near "s_New": syntax error (code 1): , while compiling: SELECT * FROM `file` WHERE (`path` = '/Marketing/Datasheets/What's_New.pdf' AND `persisted` = 1 )

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.rawQuery
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1113)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:690)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    6. android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
    7. android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
    8. android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1430)
    9. android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1369)
    9 frames
  3. ORMLite Android
    AndroidCompiledStatement.runQuery
    1. com.j256.ormlite.android.compat.JellyBeanApiCompatibility.rawQuery(JellyBeanApiCompatibility.java:21)
    2. com.j256.ormlite.android.AndroidCompiledStatement.getCursor(AndroidCompiledStatement.java:180)
    3. com.j256.ormlite.android.AndroidCompiledStatement.runQuery(AndroidCompiledStatement.java:65)
    3 frames
  4. ORMLite Core
    Where.queryForFirst
    1. com.j256.ormlite.stmt.StatementExecutor.queryForFirst(StatementExecutor.java:96)
    2. com.j256.ormlite.dao.BaseDaoImpl.queryForFirst(BaseDaoImpl.java:233)
    3. com.j256.ormlite.stmt.QueryBuilder.queryForFirst(QueryBuilder.java:375)
    4. com.j256.ormlite.stmt.Where.queryForFirst(Where.java:517)
    4 frames
  5. removed.database.daos
    FileDaoImpl.create
    1. removed.database.daos.FileDaoImpl.queryFile(FileDaoImpl.java:75)
    2. removed.database.daos.FileDaoImpl.create(FileDaoImpl.java:271)
    3. removed.database.daos.FileDaoImpl.create(FileDaoImpl.java:25)
    3 frames
  6. removed.operations.network
    GetFilesNetworkOperation$Request.execute
    1. removed.operations.network.GetFilesNetworkOperation$Request.execute(GetFilesNetworkOperation.java:148)
    1 frame
  7. removed.services
    OperationService$ServiceHandler.handleMessage
    1. removed.services.OperationService.processOperationRequest(OperationService.java:225)
    2. removed.services.OperationService.access$000(OperationService.java:32)
    3. removed.services.OperationService$ServiceHandler.handleMessage(OperationService.java:347)
    3 frames
  8. Android Platform
    Looper.loop
    1. android.os.Handler.dispatchMessage(Handler.java:102)
    2. android.os.Looper.loop(Looper.java:157)
    2 frames