android.database.sqlite.SQLiteDoneException Java Examples

public String getQName(int uid, String ip) {
    lock.readLock().lock();
    try {
        // Custom code
        if (readableDb == null)
            readableDb = this.getReadableDatabase();
        SQLiteDatabase db = readableDb;
        // There is a segmented index on resource
        String query = "SELECT d.qname";
        query += " FROM dns AS d";
        query += " WHERE d.resource = '" + ip.replace("'", "''") + "'";
        query += " ORDER BY d.qname";
        query += " LIMIT 1";
        // There is no way to known for sure which domain name an app used, so just pick the first one
        return db.compileStatement(query).simpleQueryForString();
    } catch (SQLiteDoneException ignored) {
        // Not found
        return null;
    } finally {
        lock.readLock().unlock();
    }
}
 

public String getQName(int uid, String ip) {
    lock.readLock().lock();
    try {
        SQLiteDatabase db = this.getReadableDatabase();
        // There is a segmented index on resource
        String query = "SELECT d.qname";
        query += " FROM dns AS d";
        query += " WHERE d.resource = '" + ip.replace("'", "''") + "'";
        query += " ORDER BY d.qname";
        query += " LIMIT 1";
        // There is no way to known for sure which domain name an app used, so just pick the first one
        return db.compileStatement(query).simpleQueryForString();
    } catch (SQLiteDoneException ignored) {
        // Not found
        return null;
    } finally {
        lock.readLock().unlock();
    }
}
 

public long getIDByIndex(int index) {
    SQLiteStatement downloadByIndex = getDownloadByIndexStatement();
    downloadByIndex.clearBindings();
    downloadByIndex.bindLong(1, index);
    try {
        return downloadByIndex.simpleQueryForLong();
    } catch (SQLiteDoneException e) {
        return -1;
    }
}
 

/**
 * Execute a statement that returns a 1 by 1 table with a numeric value.
 * For example, SELECT COUNT(*) FROM table.
 * Please see {@link SQLiteStatement#simpleQueryForLong()}.
 * <p>
 * catches a {@link SQLiteDoneException} if result is not found and returns 0. The error can safely be ignored.
 */
@Override
public long count(@NonNull DatabaseWrapper databaseWrapper) {
    try {
        String query = getQuery();
        FlowLog.log(FlowLog.Level.V, "Executing query: " + query);
        return SqlUtils.longForQuery(databaseWrapper, query);
    } catch (SQLiteDoneException sde) {
        // catch exception here, log it but return 0;
        FlowLog.log(FlowLog.Level.W, sde);
    }
    return 0;
}
 

private int getChannelCounter(UUID server, String channel) {
    synchronized (mDatabaseLock) {
        waitForDatabase();
        mGetNotificationCountStatement.bindString(1, server.toString());
        mGetNotificationCountStatement.bindString(2, channel);
        long ret;
        try {
            ret = mGetNotificationCountStatement.simpleQueryForLong();
        } catch (SQLiteDoneException e) {
            ret = 0;
        }
        mGetNotificationCountStatement.clearBindings();
        return (int) ret;
    }
}
 

private String getFirstMessageId(UUID server, String channel) {
    synchronized (mDatabaseLock) {
        waitForDatabase();
        mGetFirstMessageIdStatement.bindString(1, server.toString());
        mGetFirstMessageIdStatement.bindString(2, channel);
        String ret;
        try {
            ret = mGetFirstMessageIdStatement.simpleQueryForString();
        } catch (SQLiteDoneException ignored) {
            ret = null;
        }
        mGetFirstMessageIdStatement.clearBindings();
        return ret;
    }
}
 

public long getIDByIndex(int index) {
    SQLiteStatement downloadByIndex = getDownloadByIndexStatement();
    downloadByIndex.clearBindings();
    downloadByIndex.bindLong(1, index);
    try {
        return downloadByIndex.simpleQueryForLong();
    } catch (SQLiteDoneException e) {
        return -1;
    }
}
 

@SuppressWarnings("unchecked")
@androidx.annotation.Nullable
<V> V getFromStatement(@NonNull SupportSQLiteStatement stm) {
  try {
    return (V) valueParser.parseFromStatement(stm);
  } catch (SQLiteDoneException e) {
    // query returned no results
  }
  return null;
}
 

public long getIDByIndex(int index) {
    SQLiteStatement downloadByIndex = getDownloadByIndexStatement();
    downloadByIndex.clearBindings();
    downloadByIndex.bindLong(1, index);
    try {
        return downloadByIndex.simpleQueryForLong();
    } catch (SQLiteDoneException e) {
        return -1;
    }
}
 

public long getIDByIndex(int index) {
    SQLiteStatement downloadByIndex = getDownloadByIndexStatement();
    downloadByIndex.clearBindings();
    downloadByIndex.bindLong(1, index);
    try {
        return downloadByIndex.simpleQueryForLong();
    } catch (SQLiteDoneException e) {
        return -1;
    }
}
 

/**
 * {@inheritDoc}
 */
@Override
public Long getNextJobDelayUntilNs(boolean hasNetwork) {
    SQLiteStatement stmt =
            hasNetwork ? sqlHelper.getNextJobDelayedUntilWithNetworkStatement()
            : sqlHelper.getNextJobDelayedUntilWithoutNetworkStatement();
    synchronized (stmt) {
        try {
            stmt.clearBindings();
            return stmt.simpleQueryForLong();
        } catch (SQLiteDoneException e){
            return null;
        }
    }
}
 

public long getIDByIndex(int index) {
    SQLiteStatement downloadByIndex = getDownloadByIndexStatement();
    downloadByIndex.clearBindings();
    downloadByIndex.bindLong(1, index);
    try {
        return downloadByIndex.simpleQueryForLong();
    } catch (SQLiteDoneException e) {
        return -1;
    }
}
 

@Override
public boolean isRestrictionSet(PRestriction restriction) throws RemoteException {
	try {
		// No permissions required
		boolean set = false;

		SQLiteDatabase db = getDb();
		if (db != null) {
			// Precompile statement when needed
			if (stmtGetRestriction == null) {
				String sql = "SELECT restricted FROM " + cTableRestriction
						+ " WHERE uid=? AND restriction=? AND method=?";
				stmtGetRestriction = db.compileStatement(sql);
			}

			// Execute statement
			mLock.readLock().lock();
			try {
				db.beginTransaction();
				try {
					try {
						synchronized (stmtGetRestriction) {
							stmtGetRestriction.clearBindings();
							stmtGetRestriction.bindLong(1, restriction.uid);
							stmtGetRestriction.bindString(2, restriction.restrictionName);
							stmtGetRestriction.bindString(3, restriction.methodName);
							stmtGetRestriction.simpleQueryForLong();
							set = true;
						}
					} catch (SQLiteDoneException ignored) {
					}

					db.setTransactionSuccessful();
				} finally {
					db.endTransaction();
				}
			} finally {
				mLock.readLock().unlock();
			}
		}

		return set;
	} catch (Throwable ex) {
		Util.bug(null, ex);
		throw new RemoteException(ex.toString());
	}
}