Package java.sql

Examples of java.sql.PreparedStatement.clearBatch()

410
411
412
413
414
415
416
417
418
419
420
            // first create a new entry in the rules table
            PreparedStatement insertRule = getPreparedStatement("rules.insert");
            PreparedStatement addProgramRule = getPreparedStatement("programs.add_rule");
            synchronized (insertRule) {
                insertRule.clearBatch();
                addProgramRule.clearBatch();

                for(Rule rule : program.getRules()) {
                    if(!old.getRules().contains(rule)) {
                        rule.setId(getNextSequence("seq.rules"));
View Full Code Here
574
575
576
577
578
579
580
581
582
583
584
        // 1. delete all rule associations and rules including the justifications they depend on
        PreparedStatement deleteProgramRule = getPreparedStatement("programs.delete_rule");
        PreparedStatement deleteRule        = getPreparedStatement("rules.delete_by_id");
        synchronized (deleteProgramRule) {
            deleteProgramRule.clearBatch();
            deleteRule.clearBatch();
            for(Rule rule : program.getRules()) {
                deleteProgramRule.setLong(1, program.getId());
                deleteProgramRule.setLong(2, rule.getId());
                deleteProgramRule.addBatch();
View Full Code Here
592
593
594
595
596
597
598
599
600
601
602
        }

        // 2. delete all namespaces
        PreparedStatement deleteProgramNS = getPreparedStatement("programs.delete_ns");
        synchronized (deleteProgramNS) {
            deleteProgramNS.clearBatch();
            for(Map.Entry<String,String> ns : program.getNamespaces().entrySet()) {
                deleteProgramNS.setLong(1,   program.getId());
                deleteProgramNS.setString(2, ns.getKey());
                deleteProgramNS.setString(3, ns.getValue());
                deleteProgramNS.addBatch();
View Full Code Here
628
629
630
631
632
633
634
635
636
637
638
        PreparedStatement justificationAddRule   = getPreparedStatement("justifications.add_rule");

        synchronized (insertJustification) {
            insertJustification.clearBatch();
            justificationAddTriple.clearBatch();
            justificationAddRule.clearBatch();

            for(Justification j : justifications) {
                if(j.getId() != null) {
                    log.warn("justification is already stored in database, not persisting again (database ID: {})", j.getId());
                } else {
View Full Code Here
705
706
707
708
709
710
711
712
713
714
715
        PreparedStatement deleteJustificationTriples = getPreparedStatement("justifications.del_triple");

        synchronized (deleteJustification) {
            deleteJustification.clearBatch();
            deleteJustificationRules.clearBatch();
            deleteJustificationTriples.clearBatch();

            while(justifications.hasNext()) {
                Justification j = justifications.next();
                if(j.getId() == null) {
                    log.error("cannot delete justification since it does not have a database ID");
View Full Code Here
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
        pStmt.addBatch();
        pStmt.setInt(1, 2);
        pStmt.addBatch();
        pStmt.setInt(1, 3);
        pStmt.addBatch();
        pStmt.clearBatch();
        /* there were 0 statements in the batch,
         * update count length should be 0 */
        assertBatchUpdateCounts(new int[] {}, pStmt.executeBatch());

        println("Positive Prepared Stat: " +
View Full Code Here
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
        pStmt.addBatch();
        pStmt.setInt(1, 2);
        pStmt.addBatch();
        pStmt.setInt(1, 3);
        pStmt.addBatch();
        pStmt.clearBatch();
        pStmt.setInt(1, 1);
        pStmt.addBatch();
        pStmt.setInt(1, 2);
        pStmt.addBatch();
        pStmt.setInt(1, 3);
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
        }

        // 2) create namespace entries in the reasoner_program_namespaces table
        PreparedStatement insertNamespaces = getPreparedStatement("programs.add_ns");
        synchronized (insertNamespaces) {
            insertNamespaces.clearBatch();
            for(Map.Entry<String,String> entry : program.getNamespaces().entrySet()) {
                insertNamespaces.clearParameters();
                insertNamespaces.setLong(1, program.getId());
                insertNamespaces.setString(2,entry.getKey());
                insertNamespaces.setString(3,entry.getValue());
View Full Code Here
263
264
265
266
267
268
269
270
271
272
273
                insertNamespaces.setString(2,entry.getKey());
                insertNamespaces.setString(3,entry.getValue());
                insertNamespaces.addBatch();
            }
            insertNamespaces.executeBatch();
            insertNamespaces.clearBatch();
        }


        // 3) create rules in the reasoner_rules table
        for(Rule rule : program.getRules()) {
View Full Code Here
275
276
277
278
279
280
281
282
283
284
285
        }

        // 4) add relation between program and rules to the reasoner_program_rules table
        PreparedStatement insertRuleRelation = getPreparedStatement("programs.add_rule");
        synchronized (insertRuleRelation) {
            insertRuleRelation.clearBatch();
            for(Rule rule : program.getRules()) {
                insertRuleRelation.clearParameters();
                insertRuleRelation.setLong(1,program.getId());
                insertRuleRelation.setLong(2,rule.getId());
                insertRuleRelation.addBatch();
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.