Package com.cloud.utils.db

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

119
120
121
122
123
124
125
126
127
128
129
        ResultSet rs = null;
        HostVO host = null;
        TransactionLegacy txn = TransactionLegacy.currentTxn();

        try {
            pstmt = txn.prepareStatement(sql);
            pstmt.setLong(1, poolId);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                long id = rs.getLong(1);
                host = hostDao.findById(id);
View Full Code Here
363
364
365
366
367
368
369
370
371
372
373
        ResultSet rs = null;
        HostVO host = null;
        TransactionLegacy txn = TransactionLegacy.currentTxn();

        try {
            pstmt = txn.prepareStatement(sql);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                long id = rs.getLong(1);
                host = hostDao.findById(id);
            }
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
    public SnapshotDataStoreVO findLatestSnapshotForVolume(Long volumeId, DataStoreRole role) {
        TransactionLegacy txn = TransactionLegacy.currentTxn();
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            pstmt = txn.prepareStatement(findLatestSnapshot);
            pstmt.setString(1, role.toString());
            pstmt.setLong(2, volumeId);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                long sid = rs.getLong(1);
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
    public SnapshotDataStoreVO findParent(DataStoreRole role, Long storeId, Long volumeId) {
        TransactionLegacy txn = TransactionLegacy.currentTxn();
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {
            pstmt = txn.prepareStatement(parentSearch);
            pstmt.setLong(1, storeId);
            pstmt.setString(2, role.toString());
            pstmt.setLong(3, volumeId);
            rs = pstmt.executeQuery();
            while (rs.next()) {
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
    @Deprecated
    public boolean update(String name, String value) {
        TransactionLegacy txn = TransactionLegacy.currentTxn();
        PreparedStatement stmt = null;
        try {
            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
167
168
169
170
171
172
173
174
175
176
177
    public boolean update(String name, String category, String value) {
        TransactionLegacy txn = TransactionLegacy.currentTxn();
        PreparedStatement stmt = null;
        try {
            value = ("Hidden".equals(category) || "Secure".equals(category)) ? DBEncryptionUtil.encrypt(value) : value;
            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
261
262
263
264
265
266
267
268
269
270
271
        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
502
503
504
505
506
507
508
509
510
511
512
        List<EngineHostVO> result = new ArrayList<EngineHostVO>();
        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
173
174
175
176
177
178
179
180
181
182
183
        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
210
211
212
213
214
215
216
217
218
219
220
        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
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.