Package com.dotmarketing.common.db

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

39
40
41
42
43
44
45
46
47
48
49
          Logger.error(this, e.getMessage(), e);
        }
      }else if(DbConnectionFactory.getDBType().equals(DbConnectionFactory.MSSQL)){
        dc.setSQL(MSCREATESQL);
        try {
          dc.loadResult();
        } catch (DotDataException e) {
          Logger.error(this, e.getMessage(), e);
        }
      }else{
        dc.setSQL(OCLCREATESQL);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
          Logger.error(this, e.getMessage(), e);
        }
      }else{
        dc.setSQL(OCLCREATESQL);
        try {
          dc.loadResult();
          dc.setSQL(ORACLESEQSQL);
          dc.loadResult();
          dc.setSQL(ORACLETRIGGER);
          dc.loadResult();
        } catch (DotDataException e) {
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
      }else{
        dc.setSQL(OCLCREATESQL);
        try {
          dc.loadResult();
          dc.setSQL(ORACLESEQSQL);
          dc.loadResult();
          dc.setSQL(ORACLETRIGGER);
          dc.loadResult();
        } catch (DotDataException e) {
          Logger.error(this, e.getMessage(), e);
        }     
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
        try {
          dc.loadResult();
          dc.setSQL(ORACLESEQSQL);
          dc.loadResult();
          dc.setSQL(ORACLETRIGGER);
          dc.loadResult();
        } catch (DotDataException e) {
          Logger.error(this, e.getMessage(), e);
        }     
      }
    }finally{
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
    dc.addParam(notification.getMessage());
    dc.addParam(UtilMethods.isSet(notification.getType())?notification.getType().name():NotificationType.GENERIC.name());
    dc.addParam(notification.getLevel().name());
    dc.addParam(notification.getUserId());
    dc.addParam(new Date());
    dc.loadResult();
    CacheLocator.getNewNotificationCache().remove(notification.getUserId());
  }

  public Notification findNotification(String notificationId) throws DotDataException {
      DotConnect dc = new DotConnect();
View Full Code Here
31
32
33
34
35
36
37
38
39
40
41
        DotConnect dc = new DotConnect();
        dc.setSQL( "update identifier set asset_name = ? where id = ?" );
        dc.addParam( "system host" );
        dc.addParam( Host.SYSTEM_HOST );

        dc.loadResult();

        //Verify if we already have a contentlet version for the SYSTEM_HOST contentlet
        dc = new DotConnect();
        dc.setSQL( "select identifier from contentlet_version_info where identifier = ?" );
        dc.addParam( Host.SYSTEM_HOST );
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
                }
                dc.addObject( null );
                dc.addParam( new Date() );
                dc.addParam( new Date() );

                dc.loadResult();
            } else {
                throw new DotRuntimeException( "Error querying SYSTEM_HOST contentlet." );
            }
        }
View Full Code Here
149
150
151
152
153
154
155
156
    if(!UtilMethods.isSet(userId)) return;

    dc.setSQL("update notification set was_read = "+ DbConnectionFactory.getDBTrue()
        + " where was_read = "+ DbConnectionFactory.getDBFalse()+" and user_id = ?");
    dc.addParam(userId);
    dc.loadResult();
  }
}
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
      String stInode = tree.get("parent");
      String containerInode = tree.get("child");
      dc.setSQL("UPDATE containers set structure_inode = ? where inode = ?");
      dc.addParam(stInode);
      dc.addParam(containerInode);
      dc.loadResult();
    }
  }
 
  private void htmlpageTableChanges() throws SQLException, DotDataException {
    DotConnect dc = new DotConnect();
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
      String templateId = tree.get("parent");
      String htmlpageInode = tree.get("child");
      dc.setSQL("UPDATE htmlpage set template_id = ? where inode = ?");
      dc.addParam(templateId);
      dc.addParam(htmlpageInode);
      dc.loadResult();
    }
    addTriggerToHTMLPage();
  }
 
  private void triggerChanges() throws SQLException {
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.