public static GenericDocumentJournalLineDao store(
      BlgDataSourceConfig blgDsFactory, GenericDocumentJournalLineDao ObjToStore) {
    if (ObjToStore == null) {
      return null;
    }
    try (Connection connection = blgDsFactory.getConnection()) {
      String query =
          "INSERT INTO "
              + GenericDocumentJournalLineDao.TABLE_NAME
              + " VALUES(→guid,→guid_doc_hdr,→guid_doc_line,→guid_glcode,→descr,→remarks,→amount_debit,→amount_credit,→comp_guid,→branch_txn_guid,→store_guid,→profit_center_guid,→segment_guid,→project_guid,→dimension_guid,→position_id,→date_txn,→log_json::jsonb,→status,→reference_num,→tx_type)";
      NamedParameterStatement stmt = new NamedParameterStatement(connection, query);
      stmt.setString("guid", ObjToStore.getGuid());
      stmt.setString("guid_doc_hdr", ObjToStore.getGuid_doc_hdr());
      stmt.setString("guid_doc_line", ObjToStore.getGuid_doc_line());
      stmt.setString("guid_glcode", ObjToStore.getGuid_glcode());
      stmt.setString("descr", ObjToStore.getDescr());
      stmt.setString("remarks", ObjToStore.getRemarks());
      stmt.setBigDecimal("amount_debit", ObjToStore.getAmount_debit());
      stmt.setBigDecimal("amount_credit", ObjToStore.getAmount_credit());
      stmt.setString("comp_guid", ObjToStore.getComp_guid());
      stmt.setString("branch_txn_guid", ObjToStore.getBranch_txn_guid());
      stmt.setString("store_guid", ObjToStore.getStore_guid());
      stmt.setString("profit_center_guid", ObjToStore.getProfit_center_guid());
      stmt.setString("segment_guid", ObjToStore.getSegment_guid());
      stmt.setString("project_guid", ObjToStore.getProject_guid());
      stmt.setString("dimension_guid", ObjToStore.getDimension_guid());
      stmt.setString("position_id", ObjToStore.getPosition_id());
      stmt.setTimestamp("date_txn", ObjToStore.getDate_txn());
      stmt.setString("log_json", ObjToStore.getLog_json());
      stmt.setString("status", ObjToStore.getStatus());
      stmt.setString("reference_num", ObjToStore.getReference_num());
      stmt.setString("tx_type", ObjToStore.getTx_type());
      int i = stmt.executeUpdate();

      if (i != 1) {
        throw new RuntimeException("Insert failed");
      }
    } catch (Exception e) {
      throw new RuntimeException(e);
    }
    return getObject(blgDsFactory, ObjToStore.getGuid());
  }
  public static AppMessageStoreDao store(
      BlgDataSourceConfig blg_ds, AppMessageStoreDao ObjToStore) {
    if (ObjToStore == null) {
      return null;
    }
    try (Connection connection = blg_ds.getConnection()) {
      String query =
          "INSERT INTO "
              + TABLE_NAME
              + " ("
              + GUID_STORE
              + "," // 01
              + TRIGGER_KEY
              + "," // 02
              + TXN_TYPE
              + "," // 03
              + PRIORITY
              + "," // 04
              + LOCAL_LOGIN_GUID
              + "," // 05
              + LOCAL_MESSAGE_TIME
              + "," // 06
              + LOCAL_CREATED_TIME
              + "," // 07
              + LOCAL_UPDATED_TIME
              + "," // 08
              + LOCAL_DELETED_TIME
              + "," // 09
              + LOCAL_STATUS
              + "," // 10
              + REMOTE_DEVICE_ID
              + "," // 11
              + REMOTE_USER_GUID
              + "," // 12
              + REMOTE_USER_ID
              + "," // 13
              + REMOTE_MESSAGE_GUID
              + "," // 14
              + REMOTE_CREATED_TIME
              + "," // 15
              + REMOTE_DOCUMENT_ID
              + "," // 16
              + DOCUMENT_JSON
              + "," // 17
              + REMARKS
              + "," // 18
              + STATUS
              + "," // 19
              + REMOTE_USER_PROFILE_JSON
              + "," // 20
              + CODE
              + "," // 21
              + NAME
              + "," // 22
              + DESCR
              + "," // 23
              + LOCAL_DEVICE_URL
              + "," // 24
              + REMOTE_DEVICE_URL
              + "," // 25
              + REFERENCE_NUMBER
              + "," // 26
              + REMOTE_DB_NAME
              + "," // 27
              + LOCAL_DB_NAME
              + "," // 28
              + REMOTE_TABLE_NAME
              + "," // 29
              + LOCAL_TABLE_NAME
              + "," // 30
              + LOCAL_DOCUMENT_ID
              + ")" // 31
              + " VALUES ("
              + "→"
              + GUID_STORE
              + "," // 01
              + "→"
              + TRIGGER_KEY
              + "," // 02
              + "→"
              + TXN_TYPE
              + "," // 03
              + "→"
              + PRIORITY
              + "," // 04
              + "→"
              + LOCAL_LOGIN_GUID
              + "," // 05
              + "→"
              + LOCAL_MESSAGE_TIME
              + "," // 06
              + "→"
              + LOCAL_CREATED_TIME
              + "," // 07
              + "→"
              + LOCAL_UPDATED_TIME
              + "," // 08
              + "→"
              + LOCAL_DELETED_TIME
              + "," // 09
              + "→"
              + LOCAL_STATUS
              + "," // 10
              + "→"
              + REMOTE_DEVICE_ID
              + "," // 11
              + "→"
              + REMOTE_USER_GUID
              + "," // 12
              + "→"
              + REMOTE_USER_ID
              + "," // 13
              + "→"
              + REMOTE_MESSAGE_GUID
              + "," // 14
              + "→"
              + REMOTE_CREATED_TIME
              + "," // 15
              + "→"
              + REMOTE_DOCUMENT_ID
              + "," // 16
              + "→"
              + DOCUMENT_JSON
              + "," // 17
              + "→"
              + REMARKS
              + "," // 18
              + "→"
              + STATUS
              + "," // 19
              + "→"
              + REMOTE_USER_PROFILE_JSON
              + "," // 20
              + "→"
              + CODE
              + "," // 21
              + "→"
              + NAME
              + "," // 22
              + "→"
              + DESCR
              + "," // 23
              + "→"
              + LOCAL_DEVICE_URL
              + "," // 24
              + "→"
              + REMOTE_DEVICE_URL
              + "," // 25
              + "→"
              + REFERENCE_NUMBER
              + "," // 26
              + "→"
              + REMOTE_DB_NAME
              + "," // 27
              + "→"
              + LOCAL_DB_NAME
              + "," // 28
              + "→"
              + REMOTE_TABLE_NAME
              + "," // 29
              + "→"
              + LOCAL_TABLE_NAME
              + "," // 30
              + "→"
              + LOCAL_DOCUMENT_ID
              + ")"; // 31

      NamedParameterStatement stmt = new NamedParameterStatement(connection, query);
      int i = 0;
      stmt.setString(GUID_STORE, ObjToStore.getGuid_store()); // 1
      stmt.setString(TRIGGER_KEY, ObjToStore.getTrigger_key()); // 2
      stmt.setString(TXN_TYPE, ObjToStore.getTxn_type()); // 3
      stmt.setInt(PRIORITY, ObjToStore.getPriority()); // 4
      stmt.setString(LOCAL_LOGIN_GUID, ObjToStore.getLocal_login_guid()); // 5
      stmt.setTimestamp(LOCAL_MESSAGE_TIME, ObjToStore.getLocal_message_time()); // 6
      stmt.setTimestamp(LOCAL_CREATED_TIME, ObjToStore.getLocal_created_time()); // 7
      stmt.setTimestamp(LOCAL_UPDATED_TIME, ObjToStore.getLocal_updated_time()); // 8
      stmt.setTimestamp(LOCAL_DELETED_TIME, ObjToStore.getLocal_deleted_time()); // 9
      stmt.setString(LOCAL_STATUS, ObjToStore.getLocal_status()); // 10
      stmt.setString(REMOTE_DEVICE_ID, ObjToStore.getRemote_device_id()); // 11
      stmt.setString(REMOTE_USER_GUID, ObjToStore.getRemote_user_guid()); // 12
      stmt.setString(REMOTE_USER_ID, ObjToStore.getRemote_user_id()); // 13
      stmt.setString(REMOTE_MESSAGE_GUID, ObjToStore.getRemote_message_guid()); // 14
      stmt.setTimestamp(REMOTE_CREATED_TIME, ObjToStore.getRemote_created_time()); // 15
      stmt.setString(REMOTE_DOCUMENT_ID, ObjToStore.getRemote_document_id()); // 16
      stmt.setString(DOCUMENT_JSON, new Gson().toJson(ObjToStore.getDocument_json())); // 17
      stmt.setString(REMARKS, ObjToStore.getRemarks()); // 18
      stmt.setString(STATUS, ObjToStore.getStatus()); // 19
      stmt.setString(REMOTE_USER_PROFILE_JSON, ObjToStore.getRemote_user_profile_json()); // 20
      stmt.setString(CODE, ObjToStore.getCode()); // 21
      stmt.setString(NAME, ObjToStore.getName()); // 22
      stmt.setString(DESCR, ObjToStore.getDescr()); // 23
      stmt.setString(LOCAL_DEVICE_URL, ObjToStore.getLocal_device_url()); // 24
      stmt.setString(REMOTE_DEVICE_URL, ObjToStore.getRemote_device_url()); // 25
      stmt.setString(REFERENCE_NUMBER, ObjToStore.getReference_number()); // 26
      stmt.setString(REMOTE_DB_NAME, ObjToStore.getRemote_db_name()); // 27
      stmt.setString(LOCAL_DB_NAME, ObjToStore.getLocal_db_name()); // 28
      stmt.setString(REMOTE_TABLE_NAME, ObjToStore.getRemote_table_name()); // 39
      stmt.setString(LOCAL_TABLE_NAME, ObjToStore.getLocal_table_name()); // 30
      stmt.setString(LOCAL_DOCUMENT_ID, ObjToStore.getLocal_document_id()); // 31

      stmt.executeUpdate();
    } catch (Exception ex) {
      ex.printStackTrace();
    }
    return getObject(blg_ds, ObjToStore.getGuid_store());
  }