Examples with DbConnection com.zimbra.cs.db.DbPool.DbConnection used on opensource projects

Example 1 with DbConnection

use of com.zimbra.cs.db.DbPool.DbConnection in project zm-mailbox by Zimbra.

the class DataSourceCallback method lookupAccountsFromDB.

// look up all accounts on this server
private List<Account> lookupAccountsFromDB(Provisioning prov) throws ServiceException {
    Set<String> accountIds = null;
    List<Account> accts = new ArrayList<Account>();
    DbConnection conn = null;
    try {
        conn = DbPool.getConnection();
        accountIds = DbMailbox.listAccountIds(conn);
    } finally {
        DbPool.quietClose(conn);
    }
    for (String accountId : accountIds) {
        Account account = null;
        try {
            account = prov.get(AccountBy.id, accountId);
        } catch (ServiceException e) {
            ZimbraLog.datasource.debug("Unable to look up account for id %s: %s", accountId, e.toString());
        }
        if (account != null) {
            accts.add(account);
        }
    }
    return accts;
}

Example 2 with DbConnection

use of com.zimbra.cs.db.DbPool.DbConnection in project zm-mailbox by Zimbra.

the class DataSourceManager method updateSchedule.

/**
     *
     * Updates scheduling data for this <tt>DataSource</tt> both in memory and in the
     * <tt>data_source_task</tt> database table.
     *
     * @param account Account for the DataSource, cannot be null.
     * @param ds The DataSource.  Ignored if cancelSchedule is true.
     * @param dsId zimbraId of the DataSource.
     * @param cancelSchedule cancel scheduling for the DataSource.
     * @throws ServiceException
     */
private static void updateSchedule(Account account, DataSource ds, String dsId, boolean cancelSchedule) throws ServiceException {
    if (!LC.data_source_scheduling_enabled.booleanValue()) {
        return;
    }
    String accountId = account.getId();
    ZimbraLog.datasource.debug("Updating schedule for account %s, data source %s", accountId, dsId);
    int mboxId = MailboxManager.getInstance().lookupMailboxId(account.getId());
    if (mboxId == -1)
        return;
    if (cancelSchedule) {
        ZimbraLog.datasource.info("Data source %s was deleted.  Deleting scheduled task.", dsId);
        ScheduledTaskManager.cancel(DataSourceTask.class.getName(), dsId, mboxId, false);
        DbScheduledTask.deleteTask(DataSourceTask.class.getName(), dsId);
        deleteManaged(accountId, dsId);
        return;
    }
    if (!ds.isEnabled()) {
        ZimbraLog.datasource.info("Data source %s is disabled.  Deleting scheduled task.", dsId);
        ScheduledTaskManager.cancel(DataSourceTask.class.getName(), dsId, mboxId, false);
        DbScheduledTask.deleteTask(DataSourceTask.class.getName(), dsId);
        return;
    }
    ZimbraLog.datasource.info("Updating schedule for data source %s", ds.getName());
    DbConnection conn = null;
    try {
        conn = DbPool.getConnection();
        ScheduledTaskManager.cancel(conn, DataSourceTask.class.getName(), ds.getId(), mboxId, false);
        if (ds.isScheduled()) {
            DataSourceTask task = new DataSourceTask(mboxId, accountId, dsId, ds.getPollingInterval());
            ZimbraLog.datasource.debug("Scheduling %s", task);
            ScheduledTaskManager.schedule(conn, task);
        }
        conn.commit();
    } catch (ServiceException e) {
        ZimbraLog.datasource.warn("Unable to schedule data source %s", ds.getName(), e);
        DbPool.quietRollback(conn);
    } finally {
        DbPool.quietClose(conn);
    }
}

Example 3 with DbConnection

use of com.zimbra.cs.db.DbPool.DbConnection in project zm-mailbox by Zimbra.

the class DbMailItem method getById.

public static List<UnderlyingData> getById(Mailbox mbox, Collection<Integer> ids, MailItem.Type type) throws ServiceException {
    if (Mailbox.isCachedType(type)) {
        throw ServiceException.INVALID_REQUEST("folders and tags must be retrieved from cache", null);
    }
    List<UnderlyingData> result = new ArrayList<UnderlyingData>();
    if (ids.isEmpty()) {
        return result;
    }
    List<UnderlyingData> conversations = new ArrayList<UnderlyingData>();
    DbConnection conn = mbox.getOperationConnection();
    PreparedStatement stmt = null;
    ResultSet rs = null;
    Iterator<Integer> it = ids.iterator();
    for (int i = 0; i < ids.size(); i += Db.getINClauseBatchSize()) {
        try {
            int count = Math.min(Db.getINClauseBatchSize(), ids.size() - i);
            stmt = conn.prepareStatement("SELECT " + DB_FIELDS + " FROM " + getMailItemTableName(mbox, "mi") + " WHERE " + IN_THIS_MAILBOX_AND + DbUtil.whereIn("id", count));
            int pos = 1;
            pos = setMailboxId(stmt, mbox, pos);
            for (int index = i; index < i + count; index++) {
                stmt.setInt(pos++, it.next());
            }
            rs = stmt.executeQuery();
            while (rs.next()) {
                UnderlyingData data = constructItem(rs);
                MailItem.Type resultType = MailItem.Type.of(data.type);
                if (!MailItem.isAcceptableType(type, resultType)) {
                    throw MailItem.noSuchItem(data.id, type);
                } else if (Mailbox.isCachedType(resultType)) {
                    throw ServiceException.INVALID_REQUEST("folders and tags must be retrieved from cache", null);
                }
                if (resultType == MailItem.Type.CONVERSATION) {
                    conversations.add(data);
                }
                result.add(data);
            }
        } catch (SQLException e) {
            throw ServiceException.FAILURE("fetching " + ids.size() + " items: " + getIdListForLogging(ids), e);
        } finally {
            DbPool.closeResults(rs);
            DbPool.closeStatement(stmt);
        }
    }
    if (!conversations.isEmpty()) {
        completeConversations(mbox, conn, conversations);
    }
    return result;
}

Example 4 with DbConnection

use of com.zimbra.cs.db.DbPool.DbConnection in project zm-mailbox by Zimbra.

the class DbMailItem method persistCounts.

public static void persistCounts(MailItem item, Metadata metadata) throws ServiceException {
    Mailbox mbox = item.getMailbox();
    DbConnection conn = mbox.getOperationConnection();
    PreparedStatement stmt = null;
    try {
        stmt = conn.prepareStatement("UPDATE " + getMailItemTableName(item) + " SET size = ?, unread = ?, metadata = ?, mod_metadata = ?, change_date = ?, mod_content = ?" + " WHERE " + IN_THIS_MAILBOX_AND + "id = ?");
        int pos = 1;
        stmt.setLong(pos++, item.getSize());
        stmt.setInt(pos++, item.getUnreadCount());
        stmt.setString(pos++, checkMetadataLength(metadata.toString()));
        stmt.setInt(pos++, item.getModifiedSequence());
        if (item.getChangeDate() > 0) {
            stmt.setInt(pos++, (int) (item.getChangeDate() / 1000));
        } else {
            stmt.setNull(pos++, Types.INTEGER);
        }
        stmt.setInt(pos++, item.getSavedSequence());
        pos = setMailboxId(stmt, mbox, pos);
        stmt.setInt(pos++, item.getId());
        stmt.executeUpdate();
    } catch (SQLException e) {
        throw ServiceException.FAILURE("writing metadata for mailbox " + item.getMailboxId() + ", item " + item.getId(), e);
    } finally {
        DbPool.closeStatement(stmt);
    }
}

Example 5 with DbConnection

use of com.zimbra.cs.db.DbPool.DbConnection in project zm-mailbox by Zimbra.

the class DbMailItem method checkNamingConstraint.

private static void checkNamingConstraint(Mailbox mbox, int folderId, String name, int modifiedItemId) throws ServiceException {
    if (name == null || name.equals("")) {
        return;
    }
    if (Db.supports(Db.Capability.UNIQUE_NAME_INDEX) && !Db.supports(Db.Capability.CASE_SENSITIVE_COMPARISON)) {
        return;
    }
    DbConnection conn = mbox.getOperationConnection();
    PreparedStatement stmt = null;
    ResultSet rs = null;
    try {
        stmt = conn.prepareStatement("SELECT COUNT(*) FROM " + getMailItemTableName(mbox) + " WHERE " + IN_THIS_MAILBOX_AND + "folder_id = ? AND id <> ? AND " + Db.equalsSTRING("name"));
        int pos = 1;
        pos = setMailboxId(stmt, mbox, pos);
        stmt.setInt(pos++, folderId);
        stmt.setInt(pos++, modifiedItemId);
        stmt.setString(pos++, StringUtil.trimTrailingSpaces(name));
        rs = stmt.executeQuery();
        if (!rs.next() || rs.getInt(1) > 0) {
            throw MailServiceException.ALREADY_EXISTS(name);
        }
    } catch (SQLException e) {
        throw ServiceException.FAILURE("checking for naming conflicts", e);
    } finally {
        DbPool.closeResults(rs);
        DbPool.closeStatement(stmt);
    }
}