Package com.cloud.utils.db

Examples of com.cloud.utils.db.Transaction.prepareStatement()

386
387
388
389
390
391
392
393
394
395
396
            }
           
           
            if (curr_index < userVmDataList.size()){
                int batch_size = (userVmDataList.size() - curr_index);
                pstmt = txn.prepareStatement(VM_DETAILS + getQueryBatchAppender(batch_size));
                // set the vars value
                for (int k=1,j=curr_index;j<curr_index+batch_size;j++,k++){
                    pstmt.setLong(k, userVmDataList.get(j).getId());
                }
                ResultSet rs = pstmt.executeQuery();
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
    //Use update method with category instead
    @Override @Deprecated
    public boolean update(String name, String value) {
      Transaction txn = Transaction.currentTxn();
    try {
      PreparedStatement stmt = txn.prepareStatement(UPDATE_CONFIGURATION_SQL);
      stmt.setString(1, value);
      stmt.setString(2, name);
      stmt.executeUpdate();
      return true;
    } catch (Exception e) {
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
    @Override
    public boolean update(String name, String category, String value) {
      Transaction txn = Transaction.currentTxn();
    try {
      value = ("Hidden".equals(category) || "Secure".equals(category)) ? DBEncryptionUtil.encrypt(value) : value;
      PreparedStatement stmt = txn.prepareStatement(UPDATE_CONFIGURATION_SQL);
      stmt.setString(1, value);
      stmt.setString(2, name);
      stmt.executeUpdate();
      return true;
    } catch (Exception e) {
View Full Code Here
369
370
371
372
373
374
375
376
377
378
379
            int curr_index=0;
           
            List<UserVmData> userVmDataList = new ArrayList(userVmDataHash.values());
           
            if (userVmDataList.size() > VM_DETAILS_BATCH_SIZE){
                pstmt = txn.prepareStatement(VM_DETAILS + getQueryBatchAppender(VM_DETAILS_BATCH_SIZE));
                while ( (curr_index + VM_DETAILS_BATCH_SIZE) <= userVmDataList.size()){
                    // set the vars value
                    for (int k=1,j=curr_index;j<curr_index+VM_DETAILS_BATCH_SIZE;j++,k++){
                        pstmt.setLong(k, userVmDataList.get(j).getId());
                    }
View Full Code Here
395
396
397
398
399
400
401
402
403
404
405
            }
           
           
            if (curr_index < userVmDataList.size()){
                int batch_size = (userVmDataList.size() - curr_index);
                pstmt = txn.prepareStatement(VM_DETAILS + getQueryBatchAppender(batch_size));
                // set the vars value
                for (int k=1,j=curr_index;j<curr_index+batch_size;j++,k++){
                    pstmt.setLong(k, userVmDataList.get(j).getId());
                }
                ResultSet rs = pstmt.executeQuery();
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
    PreparedStatement pstmt = null;
    List<VMTemplateStoragePoolVO> result = new ArrayList<VMTemplateStoragePoolVO>();
    ResultSet rs = null;
    try {
      String sql = DOWNLOADS_STATE_DC_POD;
      pstmt = txn.prepareStatement(sql);
     
      pstmt.setLong(1, datacenterId);
      pstmt.setLong(2, podId);
      pstmt.setLong(3, templateId);
      pstmt.setString(4, downloadState.toString());
View Full Code Here
199
200
201
202
203
204
205
206
207
208
209
    PreparedStatement pstmt = null;
    List<VMTemplateStoragePoolVO> result = new ArrayList<VMTemplateStoragePoolVO>();
    ResultSet rs = null;
    try {
      String sql = HOST_TEMPLATE_SEARCH;
      pstmt = txn.prepareStatement(sql);
     
      pstmt.setLong(1, hostId);
      pstmt.setLong(2, templateId);
      rs = pstmt.executeQuery();
      while (rs.next()) {
View Full Code Here
248
249
250
251
252
253
254
255
256
257
258
    PreparedStatement pstmt = null;
    List<VMTemplateHostVO> result = new ArrayList<VMTemplateHostVO>();
    ResultSet rs = null;
    try {
      String sql = DOWNLOADS_STATE_DC_POD;
      pstmt = txn.prepareStatement(sql);
     
      pstmt.setLong(1, datacenterId);
      pstmt.setLong(2, podId);
      pstmt.setLong(3, templateId);
      pstmt.setString(4, downloadState.toString());
View Full Code Here
180
181
182
183
184
185
186
187
188
189
190
        Transaction txn = Transaction.open(Transaction.CLOUD_DB);
        txn.start();
        try {
            String request = "SELECT vm.id, uservm.account_id, vm.group from vm_instance vm, user_vm uservm where vm.group is not null and vm.removed is null and vm.id=uservm.id order by id";
            System.out.println(request);
            PreparedStatement statement = txn.prepareStatement(request);
            ResultSet result = statement.executeQuery();
            while (result.next()) {
                vmId = result.getLong(1);
                accountId = result.getLong(2);
                groupName = result.getString(3);
View Full Code Here
629
630
631
632
633
634
635
636
637
638
639
        PreparedStatement pstmt = null;
        List<HostVO> result = new ArrayList<HostVO>();
        ResultSet rs = null;
        try {
            String sql = "select h.id from host h left join  cluster c on h.cluster_id=c.id where h.mgmt_server_id is not null and h.last_ping < ? and h.status in ('Up', 'Updating', 'Disconnected', 'Connecting') and h.type not in ('ExternalFirewall', 'ExternalLoadBalancer', 'TrafficMonitor', 'SecondaryStorage', 'LocalSecondaryStorage', 'L2Networking') and (h.cluster_id is null or c.managed_state = 'Managed') ;" ;
            pstmt = txn.prepareStatement(sql);
            pstmt.setLong(1, timeout);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                long id = rs.getLong(1); //ID column
                result.add(findById(id));
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.