Package com.dotmarketing.common.db

Examples of com.dotmarketing.common.db.DotConnect.loadResult()


                " select distinct c.identifier,c.identifier,"+REINDEX_JOURNAL_PRIORITY_STRUCTURE_REINDEX+"," +
                    REINDEX_ACTION_REINDEX_OBJECT + "," + TIMESTAMPSQL  + " from contentlet c " +
                        " where c.structure_inode = ? and c.identifier is not null";
            dc.setSQL(sql);
            dc.addParam(structureInode);
            dc.loadResult();

        } catch (Exception ex) {
            Logger.fatal(this,"Error  unlocking the reindex journal table" +  ex);
        }
    }
View Full Code Here


    protected void cleanDistReindexJournal() throws DotDataException {
        DotConnect dc = new DotConnect();
        dc.setSQL("DELETE From dist_reindex_journal where priority =? or priority=?");
        dc.addParam(REINDEX_JOURNAL_PRIORITY_NEWINDEX);
        dc.addParam(REINDEX_JOURNAL_PRIORITY_NEWINDEX-10);
        dc.loadResult();
    }

    @Override
    protected void deleteContentIndexEntries(String serverId, long id)
            throws DotDataException {
View Full Code Here

        try {
            dc.setSQL("DELETE FROM dist_journal where serverid = ? and journal_type = ? and id < ?");
            dc.addParam(serverId);
            dc.addParam(JOURNAL_TYPE_CONTENTENTINDEX);
            dc.addParam(id + 1);
            dc.loadResult();
        } catch (Exception e1) {
            throw new DotDataException(e1.getMessage(), e1);
        } finally {
            try {
                HibernateUtil.closeSession();
View Full Code Here

        DotConnect dc = new DotConnect();
        dc.setSQL(deleteLikeReindexRecords);
        dc.addParam(serverId);
        dc.addParam(ijournal.getIdentToIndex());
        dc.addParam(ijournal.getId());
        dc.loadResult();
    }

    @Override
    protected void deleteReindexEntryForServer(IndexJournal<T> iJournal) throws DotDataException {
        DotConnect dc = new DotConnect();
View Full Code Here

    @Override
    protected void deleteReindexEntryForServer(IndexJournal<T> iJournal) throws DotDataException {
        DotConnect dc = new DotConnect();
        dc.setSQL("DELETE FROM dist_reindex_journal where id = ?");
        dc.addParam(iJournal.getId());
        dc.loadResult();
    }

    @Override
    protected void deleteReindexEntryForServer(List<IndexJournal<T>> recordsToDelete) throws DotDataException {
        DotConnect dc = new DotConnect();
View Full Code Here

        dc.setSQL(sql.toString());
        Connection con = null;
    try {
      con = DbConnectionFactory.getDataSource().getConnection();
      con.setAutoCommit(true);
      dc.loadResult(con);
    } catch (SQLException e) {
      Logger.error(ESDistributedJournalFactoryImpl.class,e.getMessage(),e);
    }finally{
      try {
        con.close();
View Full Code Here

    @Override
    public boolean forceRun() {
        try {
            DotConnect dc=new DotConnect();
            dc.setSQL("select * from sitelic");
            dc.loadResult();
            return false;
        }
        catch(Exception ex) {
            return true;
        }
View Full Code Here

        DotConnect dc = new DotConnect();
        String serverId = ConfigUtils.getServerId();
        dc.setSQL(reindexJournalCleanupSql.toString());
        dc.addParam(serverId);
        dc.loadResult();
    }

    private void deleteCacheEntries(String serverId, long id, Connection con)
            throws DotDataException {
        DotConnect dc = new DotConnect();
View Full Code Here

        try {
            dc.setSQL("DELETE FROM dist_journal where serverid = ? and journal_type = ? and id < ?");
            dc.addParam(serverId);
            dc.addParam(JOURNAL_TYPE_CACHE);
            dc.addParam(id + 1);
            dc.loadResult(con);
        } catch (Exception e1) {
            throw new DotDataException(e1.getMessage(), e1);
        }
    }
View Full Code Here

                call.close();
            } else if(DbConnectionFactory.isMsSql()) {
                // we need to make sure this setting is ON because of the READPAST we use
                // in the stored procedure
                dc.setSQL("SET TRANSACTION ISOLATION LEVEL READ COMMITTED;");
                dc.loadResult();

                dc.setSQL("load_records_to_index @server_id='"+serverId+"', @records_to_fetch=50");
                dc.setForceQuery(true);
                results = dc.loadObjectResults(con);
            } else if(DbConnectionFactory.isH2()) {
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.