Package org.uengine.util.dao

Examples of org.uengine.util.dao.IDAO.select()

38
39
40
41
42
43
44
45
46
47
48
 
  public static int getCurrnetRunningCount(TransactionContext tc,String defVerId,String tracingTag) throws Exception {
    IDAO dao = (IDAO)ConnectiveDAO.createDAOImpl(tc, currnetRunningCount_SQL, IDAO.class);
    dao.set("defVerId", defVerId);
    dao.set("tracingTag", tracingTag);
    dao.select();
    if(dao.next()){
      return ((Number)dao.get("CNT")).intValue();
    }
   
    return 0;
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
   
  protected Map retreiveTargetStartingPoints() throws Exception{
    Map targetKeys = new HashMap();
   
    IDAO targetKeysDAO = GenericDAO.createDAOImpl(getTargetConnectionFactory(), SQL_RETREIVETARGETSTARTINGPOINTS, IDAO.class);
    targetKeysDAO.select();
    if(targetKeysDAO.size() ==0) throw new UEngineException("Failed to retreive starting points from source server: No rows are returned.");
   
    while(targetKeysDAO.next()){
      Date recentModified = (Date)targetKeysDAO.get("recentModified");
      Number lastKey = (Number)targetKeysDAO.get("lastkey");
View Full Code Here
195
196
197
198
199
200
201
202
203
204
205
     * Retreives the source data first.
     */
   
    IDAO sourceDAO = GenericDAO.createDAOImpl(getSourceConnectionFactory(), SQL_RETREIVE_SOURCE, IDAO.class);
    sourceDAO.set("key", startingKey);
    sourceDAO.select();
   
    AbstractGenericDAO implSourceDAO = (AbstractGenericDAO)sourceDAO.getImplementationObject();
   
    /**
     * Change the connection information of the source data in order to store to the target server.
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
      System.out.print("  . "+ keyFieldName +"=["+ sourceDAO.get(keyFieldName) + "]");

      // this will check if the source value already exists
      IDAO testDAO = ConnectiveDAO.createDAOImpl(targetConnectionFactoryInTransaction, "select 1 from " + objectName + " where " + keyFieldName +" = ?key", IDAO.class);
      testDAO.set("key", sourceDAO.get(keyFieldName));
      testDAO.select();

      if(testDAO.size() > 0){
        implSourceDAO.setSqlStmt(updateSql);
        System.out.println(" [UPDATE]" + sourceDAO);
      }else{
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
    return "Oracle";
  }

  public Calendar getNow() throws Exception {
    IDAO nowQuery = (IDAO)create(IDAO.class, "SELECT TO_CHAR( SYSDATE , 'YYYYMMDDHH24MISS' ) as NOW from dual");
    nowQuery.select();
   
    if(nowQuery.next()){
      Calendar now = Calendar.getInstance();
     
      String dateTimeStr = (String)nowQuery.get("NOW");
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
          IDAO gdao = ConnectiveDAO.createDAOImpl(
              getConnectionFactory(),
              "select isNull(max(seq),0) + 1 as lastKey from bpm_seq where tbname = '" + forTableName + "'",
              IDAO.class
            );
            gdao.select();
            if(gdao.next()){
              Number currKey = (Number)gdao.get("lastKey");
            key = new Long(currKey.longValue());
            } else {
              key = new Long(1);
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
  }
 
  public Calendar getNow() throws Exception {
    //IDAO nowQuery = (IDAO)create(IDAO.class, "select convert(varchar(10), getdate(), 120) as now");
    IDAO nowQuery = (IDAO)create(IDAO.class, "select getdate() as now");
    nowQuery.select();
   
    if(nowQuery.next()){
      Calendar now = Calendar.getInstance();
      now.setTime((Date)nowQuery.get("now"));
     
View Full Code Here
158
159
160
161
162
163
164
165
166
167
168
      dao.getImplementationObject().setKeyField(keyFieldName);
      dao.set(keyFieldName, keyFieldValue);

      if(!isNew){
        dao.getImplementationObject().createSelectSql();
        dao.select();
        if(!dao.next()) throw new UEngineException("No Such "+tableName+" where "+keyFieldName+" is " + keyFieldValue);
      }
     
      String sharedContextKey = tableName + "@" + keyFieldValue;
      sharedContextKey = sharedContextKey.toUpperCase();
View Full Code Here
83
84
85
86
87
88
89
90
91
92
93
          sql = sql + " with ur";
       
        dao = ConnectiveDAO.createDAOImpl(instance.getProcessTransactionContext(), sql, IDAO.class);
       
        dao.set(getCorrelationFieldName(), keyValue);
        dao.select();

        if(dao.next()){
          instance.getProcessTransactionContext().setSharedContext(sharedContextKey, dao);
        }else
          return null;
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
            IDAO.class
        );
       
        roleUser.set("roleCode", getRoleId());
        roleUser.set("groupCode", getGroupId());
        roleUser.select();
      } else if ( getReferenceRole() != null && getReferenceRole().getMapping(instance) != null ) {
        roleUser = GenericDAO.createDAOImpl(
            DefaultConnectionFactory.create(),
            "select R.EMPCODE from EMPTABLE E, (select PARTCODE, EMPCODE from EMPTABLE where EMPCODE= ?empCode) T, ROLEUSERTABLE R where E.ISDELETED='0' and E.PARTCODE =  T.PARTCODE and R.ROLECODE = ?roleCode and R.EMPCODE = E.EMPCODE ",
            IDAO.class
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.