Package org.jugile.util

Examples of org.jugile.util.DBPool

37
38
39
40
41
42
43
44
45
46
47
48
    p1 = d.getPersons().q("==", "name", "jukka-pekka").unique();
    p1.setName("foo");
    d.commit();
   
    // check db directly
    DBPool db = DBPool.getPool();
    DBConnection c = db.getConnection();
    List<List> rows = c.select("select name_f,id_f,vers from person_t where id_f="+p1.id());
    c.free();
    assertEquals(1,rows.size());
    List row = rows.get(0);
    assertEquals("foo",row.get(0));
View Full Code Here
736
737
738
739
740
741
742
743
744
745
746
747
  /**
   * Read current version from db immediately.
   */
  public void refresh() {
    DBPool db = DBPool.getPool();
    DBConnection c = db.getConnection();
    DomainData dd = DomainCore.cd();
    try {
      c.prepare("select "+_getSelectFlds()+" from "+table() +" where id_f=?");
      c.param(id());
      List<List> rows = c.select();
View Full Code Here
766
767
768
769
770
771
772
773
774
775
776
777
 
  /**
   * Write to db immediately.
   */
  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
View Full Code Here
940
941
942
943
944
945
946
947
948
949
950
951
  private void setArchived(boolean v) {
    isArchived = v;
    String a = "0";
    if (v) a = "1";
    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);
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
    nextid = nid;
  }
 
  public static long getNextIdHiFromDb(String obj) {   
    long nid = 0;
    DBPool pool = DBPool.getPool();
    DBConnection c = pool.getConnection();
    try {
      c.writeTx();
      c.prepare("select nextid from idpool where obj=?");
      c.param(obj);
      List<List> res = c.select();
View Full Code Here
243
244
245
246
247
248
249
250
251
252
253
254
 
  protected int saveAllToDB() {
    uow(); // starts readTx
    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) {
View Full Code Here
291
292
293
294
295
296
297
298
299
300
301
302
  } 
 
  protected abstract Class<Bo>[] classes();
 
  private int doLoadFromDB() throws Exception {
    DBPool db = DBPool.getPool();
    DBConnection c = db.getConnection();
    int count = 0;
    try {
      //reset();
      count = cd().loadFromDB(c,classes());
    } catch (Exception e) {
View Full Code Here
323
324
325
326
327
328
329
330
331
332
333
334
  protected int readDeltasFromQueue(int max) throws Exception {
    return cd().readDeltasFromQueue(node(),max);
  }

  private int modifyDbAndSendMsg(String delta) {
    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;
View Full Code Here
305
306
307
308
309
310
311
312
313
314
315
316
    Bo bo = getProto();
    if (sql == null) sql = "where " + q2.toSql();
    sql = "select " + bo._getSelectFlds() +" from " + bo.table() + " " + sql;

    List<E> res = new ArrayList<E>();
    DBPool db = DBPool.getPool();
    DBConnection c = db.getConnection();
    try {
      c.prepare(sql);
      for (List<Object> row : c.select()) {
        long id = (Integer)row.get(0);
        E o = (E)bo.createOld(bo.getClass(), id);
View Full Code Here
18
19
20
21
22
23
24
25
26
27
28
29
  public final static long DONE = 2L;
  public final static long ERROR = 3L;

  public static void writeMessage(String msg, String node, String nodes[]) {
    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);
View Full Code Here
TOP

Related Classes of org.jugile.util.DBPool

  • org.jugile.daims.Bo
  • org.jugile.daims.BoCollection
  • org.jugile.daims.DBTest
  • org.jugile.daims.DomainCore
  • org.jugile.daims.UpdateDBTest
  • org.jugile.util.DBQueue
  • org.jugile.util.HiLo
  • java.sql.Driver
  • java.sql.Connection
    • Copyright © 2018 www.massapicom. 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.