438439440441442443444445446447448
pstmt.addBatch(); } pstmt.executeBatch(); txn.commit(); } catch (Exception ex) { txn.rollback(); s_logger.error("error saving usage records to cloud_usage db", ex); throw new CloudRuntimeException(ex.getMessage()); } } }
6768697071727374757677
pstmt.setLong(4, usage.getSecurityGroupId()); } pstmt.executeUpdate(); txn.commit(); } catch (Exception e) { txn.rollback(); s_logger.warn("Error updating UsageSecurityGroupVO", e); } finally { txn.close(); } }
138139140141142143144145146147148
} usageRecords.add(new UsageSecurityGroupVO(zoneId, acctId, dId, vmId, sgId, createdDate, deletedDate)); } } catch (Exception e) { txn.rollback(); s_logger.warn("Error getting usage records", e); } finally { txn.close(); }
6566676869707172737475
pstmt.setLong(1, accountId); pstmt.setLong(2, lbId); pstmt.executeUpdate(); txn.commit(); } catch (Exception e) { txn.rollback(); s_logger.warn("Error removing UsageLoadBalancerPolicyVO", e); } finally { txn.close(); } }
8687888990919293949596
pstmt.setLong(3, usage.getId()); } pstmt.executeUpdate(); txn.commit(); } catch (Exception e) { txn.rollback(); s_logger.warn("Error updating UsageLoadBalancerPolicyVO", e); } finally { txn.close(); } }
156157158159160161162163164165166
} usageRecords.add(new UsageLoadBalancerPolicyVO(lbId, zoneId, acctId, dId, createdDate, deletedDate)); } } catch (Exception e) { txn.rollback(); s_logger.warn("Error getting usage records", e); } finally { txn.close(); }
237238239240241242243244245246247
.getFirst()); bucketAdapter.deleteContainer( shost_storagelocation_pair.getSecond(), request.getBucketName()); } txn.rollback(); txn.close(); } return response; }
pstmt.setLong(4, usage.getNetworkOfferingId()); } pstmt.executeUpdate(); txn.commit(); } catch (Exception e) { txn.rollback(); s_logger.warn("Error updating UsageNetworkOfferingVO", e); } finally { txn.close(); } }
140141142143144145146147148149150
} usageRecords.add(new UsageNetworkOfferingVO(zoneId, acctId, dId, vmId, noId, nicId, isDefault, createdDate, deletedDate)); } } catch (Exception e) { txn.rollback(); s_logger.warn("Error getting usage records", e); } finally { txn.close(); }
979899100101102103104105106107
pstmt = txn.prepareAutoCloseStatement(sql); pstmt.setLong(1, maxEventTime); pstmt.executeUpdate(); txn.commit(); } catch (Exception ex) { txn.rollback(); s_logger.error("error deleting old usage disk stats", ex); } } @Override