Package com.dotmarketing.common.db

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

442
443
444
445
446
447
448
449
450
451
452
                    " WHERE NOT EXISTS (SELECT p.id FROM dist_process p, dist_journal j " +
                                      " WHERE p.object_to_index = j.object_to_index AND  p.serverid=j.serverid AND " +
                                      " p.journal_type=j.journal_type AND p1.id = p.id) " +
                           " AND id <=? GROUP BY object_to_index, serverid, journal_type");
                dc.addParam(max);
                dc.loadResult(con);

                dc.setSQL("DELETE FROM dist_process WHERE id<=?");
                dc.addParam(max);
                dc.loadResult(con);
            }
View Full Code Here
446
447
448
449
450
451
452
453
454
455
456
                dc.addParam(max);
                dc.loadResult(con);

                dc.setSQL("DELETE FROM dist_process WHERE id<=?");
                dc.addParam(max);
                dc.loadResult(con);
            }

        } catch (SQLException e1) {
            throw new DotDataException(e1.getMessage(), e1);
        } finally {
View Full Code Here
579
580
581
582
583
584
585
586
587
588
589
                    dc.addParam(inode);
                    if(live)
                        dc.addParam(inode);

                    try {
                      dc.loadResult();
                    } catch (DotDataException e) {
                      e.printStackTrace();
                    }
                }
            }
View Full Code Here
633
634
635
636
637
638
639
640
641
642
643
                    dc.setSQL("update contentlet_version_info set live_inode=? where identifier=? and lang=?");
                    dc.addParam(inode);
                    dc.addParam(identifier);
                    dc.addParam(langId);
                    dc.loadResult();
                }
            }
        } while(notDone);
    }
View Full Code Here
12
13
14
15
16
17
18
19
20
21
22
    public boolean forceRun() {
        try {
            DotConnect dc=new DotConnect();
            dc.setSQL("select publish_date,expire_date from identifier where publish_date>"
                      +DbConnectionFactory.getDBDateTimeFunction());
            dc.loadResult();
        }
        catch(Exception ex) {
            return true;
        }
        return false;
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
        String uuid = UUIDGenerator.generateUuid();
      dc.setSQL("insert into workflowtask_files(id,workflowtask_id,file_inode) values(?,?,?)");
      dc.addParam(uuid);
      dc.addParam(workflowTaskId);
      dc.addParam(fileInode);
      dc.loadResult();
      }
    dc.executeStatement(delete_task_file_relations);
  }
    private void workflowCommentChanges() throws SQLException, DotDataException{
      DotConnect dc = new DotConnect();
View Full Code Here
140
141
142
143
144
145
146
147
148
149
150
        String workflowCommentId = relation.get("child");
        String workflowTaskId = relation.get("parent"); 
        dc.setSQL("UPDATE workflow_comment set workflowtask_id = ? where id = ?");
      dc.addParam(workflowTaskId);
      dc.addParam(workflowCommentId);
      dc.loadResult();
      }
      dc.executeStatement(deleteFromTree);
  }
    private void workflowHistoryChanges() throws SQLException, DotDataException{
      String dropInode = "";
View Full Code Here
201
202
203
204
205
206
207
208
209
210
211
        String workflowHistoryInode = relation.get("child");
        String workflowTaskInode = relation.get("parent"); 
        dc.setSQL("UPDATE workflow_history set workflowtask_id = ? where id = ?");
      dc.addParam(workflowTaskInode);
      dc.addParam(workflowHistoryInode);
      dc.loadResult();
      }
     
      dc.executeStatement(deleteFromTree);
    }
    private void dropWorkFlowTaskIndexes() throws SQLException{
View Full Code Here
25
26
27
28
29
30
31
32
33
34
35
    try{
      DotConnect dc = new DotConnect();
      if(DbConnectionFactory.getDBType().equals(DbConnectionFactory.POSTGRESQL)){
        dc.setSQL(PGCREATESQL);
        try {
          dc.loadResult();
        } catch (DotDataException e) {
          Logger.error(this, e.getMessage(), e);
        }
      }else if(DbConnectionFactory.getDBType().equals(DbConnectionFactory.MYSQL)){
        dc.setSQL(MYCREATESQL);
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
          Logger.error(this, e.getMessage(), e);
        }
      }else if(DbConnectionFactory.getDBType().equals(DbConnectionFactory.MYSQL)){
        dc.setSQL(MYCREATESQL);
        try {
          dc.loadResult();
        } catch (DotDataException e) {
          Logger.error(this, e.getMessage(), e);
        }
      }else if(DbConnectionFactory.getDBType().equals(DbConnectionFactory.MSSQL)){
        dc.setSQL(MSCREATESQL);
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.