java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Syntax error when querying SQLite
    via Stack Overflow by java progammera
    ,
  • Bad query string
    via GitHub by samueltardieu
    ,
    • java.sql.SQLException: Problems executing Android query: SELECT * FROM `file` WHERE (`path` = '/Marketing/Datasheets/What's_New.pdf' AND `persisted` = 1 ) at com.j256.ormlite.misc.SqlExceptionUtil.create(SqlExceptionUtil.java:22) at com.j256.ormlite.android.AndroidCompiledStatement.getCursor(AndroidCompiledStatement.java:184) at com.j256.ormlite.android.AndroidCompiledStatement.runQuery(AndroidCompiledStatement.java:65) at com.j256.ormlite.stmt.StatementExecutor.queryForFirst(StatementExecutor.java:96) at com.j256.ormlite.dao.BaseDaoImpl.queryForFirst(BaseDaoImpl.java:233) at com.j256.ormlite.stmt.QueryBuilder.queryForFirst(QueryBuilder.java:375) at com.j256.ormlite.stmt.Where.queryForFirst(Where.java:517) at removed.database.daos.FileDaoImpl.queryFile(FileDaoImpl.java:75) at removed.database.daos.FileDaoImpl.create(FileDaoImpl.java:271) at removed.database.daos.FileDaoImpl.create(FileDaoImpl.java:25) at removed.operations.network.GetFilesNetworkOperation$Request.execute(GetFilesNetworkOperation.java:148) at removed.services.OperationService.processOperationRequest(OperationService.java:225) at removed.services.OperationService.access$000(OperationService.java:32) at removed.services.OperationService$ServiceHandler.handleMessage(OperationService.java:347) at android.os.Handler.dispatchMessage(Handler.java:102) at android.os.Looper.loop(Looper.java:157) at android.os.HandlerThread.run(HandlerThread.java:61) Caused by: 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(SQLiteConnection.java) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1113) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:690) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58) at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1430) at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1369) at com.j256.ormlite.android.compat.JellyBeanApiCompatibility.rawQuery(JellyBeanApiCompatibility.java:21) at com.j256.ormlite.android.AndroidCompiledStatement.getCursor(AndroidCompiledStatement.java:180) at com.j256.ormlite.android.AndroidCompiledStatement.runQuery(AndroidCompiledStatement.java:65) at com.j256.ormlite.stmt.StatementExecutor.queryForFirst(StatementExecutor.java:96) at com.j256.ormlite.dao.BaseDaoImpl.queryForFirst(BaseDaoImpl.java:233) at com.j256.ormlite.stmt.QueryBuilder.queryForFirst(QueryBuilder.java:375) at com.j256.ormlite.stmt.Where.queryForFirst(Where.java:517) at removed.database.daos.FileDaoImpl.queryFile(FileDaoImpl.java:75) at removed.database.daos.FileDaoImpl.create(FileDaoImpl.java:271) at removed.database.daos.FileDaoImpl.create(FileDaoImpl.java:25) at removed.operations.network.GetFilesNetworkOperation$Request.execute(GetFilesNetworkOperation.java:148) at removed.services.OperationService.processOperationRequest(OperationService.java:225) at removed.services.OperationService.access$000(OperationService.java:32) at removed.services.OperationService$ServiceHandler.handleMessage(OperationService.java:347) at android.os.Handler.dispatchMessage(Handler.java:102) at android.os.Looper.loop(Looper.java:157)

    Users with the same issue

    Indri Yunita
    2 times, last one,
    Aria Pahlavan
    8 times, last one,
    Unknown visitor1 times, last one,
    mrokay97
    2 times, last one,
    Unknown visitor1 times, last one,
    107 more bugmates