Package org.jugile.util

Examples of org.jugile.util.DBConnection.commit()

754
755
756
757
758
759
760
761
762
763
764
        o.version = (Integer)row.get(3);
        o._setFlds(dd,bi(),row,countSelectHeaderFlds());
        // copy fields to copy
        o.copy(bi(),this);
      }
      c.commit();
    } catch (Exception e) {
      try { c.rollback(); fail(e); } catch (Exception e2) { fail(e2); }
    } finally {
      try { c.free(); } catch (Exception e2) { fail(e2); }
    }
View Full Code Here
770
771
772
773
774
775
776
777
778
779
780
  public void flush() {
    DBPool db = DBPool.getPool();
    DBConnection c = db.getConnection();   
    try {
      this._dbWriteFlds(c, bi());
      c.commit();
      modified = false; // not modified anymore
      // _modified Time still remains
      incrVersion();
    } catch (Exception e) {
      try { c.rollback(); fail(e); } catch (Exception e2) { fail(e2); }
View Full Code Here
944
945
946
947
948
949
950
951
952
953
954
    String sql = "update " + table() + " set archived="+a+" where id_f="+getId();
    DBPool db = DBPool.getPool();
    DBConnection c = db.getConnection();
    try {
      c.update(sql);
      c.commit();
    } catch (Exception e) {
      log.error("dbread failed",e);
      try { c.rollback(); } catch (Exception e2) { fail(e2);}
    } finally {
      try { c.free(); } catch (Exception e) {}
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
      nid = (Integer)res.get(0).get(0);
      c.prepare("update idpool set nextid=? where obj=?");
      c.param(nid+idIncrement);
      c.param(obj);
      c.execute();
      c.commit();
    } catch (Exception e) {
      try { c.rollback(); } catch (Exception e2) { } fail(e);
    } finally {
      try { c.free(); } catch (Exception e) { log.fatal("could not free connection",e); }     
    }
View Full Code Here
247
248
249
250
251
252
253
254
255
256
257
    try {
      DBPool db = DBPool.getPool();
      DBConnection c = db.getConnection();
      try {
        int res = cd().saveToDB(c); // whole core domain cd()
        c.commit();
        return res;
      } catch (Exception e) {
        try { c.rollback(); fail(e); } catch (Exception e2) { fail(e2); }
      } finally {
        try { c.free(); } catch (Exception e2) { fail(e2); }
View Full Code Here
328
329
330
331
332
333
334
335
336
337
338
    DBPool db = DBPool.getPool();
    DBConnection c = db.getConnection();
    try {
      int res = uow().writeToDB(c, classes());
      DBQueue.writeMessage(delta, node(), nodes(), c);
      c.commit();
      return res;
    } catch (Exception e) {
      try { c.rollback(); } catch (Exception e2) { fail(e2); }
      log.error("could not write db changes",e);
      fail(e);
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
    if (nodes == null) return;
    DBPool pool = DBPool.getPool();
    DBConnection c = pool.getConnection();
    try {
      writeMessage(msg,node,nodes,c);
      c.commit();
    } catch (java.sql.SQLNonTransientConnectionException se) {
      log.info("connection error in write. retrying in 30 sec: " + node);
      // sleep 30 sec and retry
      try {
        Thread.sleep(30000);
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
      c.param(node);
      c.param(NEW);
      for (Long id : ids) { c.param(id); }
      int count = c.execute();
      if (count != ids.size()) fail("inconsistent status write: " + count + "/"+ ids.size());
      c.commit();
      log.debug("read messages from :" + node + " size: " + count);
      return msgs;
    } catch (java.sql.SQLNonTransientConnectionException se) {
      log.info("connection error in read. retrying in 30 sec: " + node);
      // sleep 30 sec and retry
View Full Code Here
160
161
162
163
164
165
166
167
168
169
170
    try {
      String sql = "delete from dbmq_queue_t where nodeid=?";
      c.prepare(sql);
      c.param(name);
      int res = c.execute();
      c.commit();
      return res;
    } catch (java.sql.SQLNonTransientConnectionException se) {
      fail("connection error in flush: " + name);
    } catch (Exception e) {
      try { c.rollback();  } catch (Exception e2) { fail(e2);}
View Full Code Here
181
182
183
184
185
186
187
188
189
190
191
    try {
      String sql = "delete from dbmq_queue_t where nodeid=? and status!=0";
      c.prepare(sql);
      c.param(name);
      int res = c.execute();
      c.commit();
      return res;
    } catch (java.sql.SQLNonTransientConnectionException se) {
      fail("connection error in flush: " + name);
    } catch (Exception e) {
      try { c.rollback();  } catch (Exception e2) { fail(e2);}
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.