Пример #1
0
  private void initialize(String configPath, String batchId) throws SQLException {
    LoadConfigXml configXmlHelper = LoadConfigXml.getConfig(configPath);
    DataClearDAO dataClearDAO = new DataClearDAO(configPath, false);
    // get table list for the special batch
    TableList tableList = configXmlHelper.getBatch(batchId).getTableList();
    TargetTableList trgtList = configXmlHelper.getBatch(batchId).getTargetTableList();
    // String[] xmlType = configXmlHelper.getOutputXMLTypeList(batchId);
    // CommonTableCondition ctc = configXmlHelper.getBatch(batchId).getCommonTableCondition();

    try {
      // truncate temp tables for the special batch
      dataClearDAO.initializeDataBase(tableList);
      // delete data from databox table.
      dataClearDAO.deleteCommData(trgtList);
      // commit transaction.
      dataClearDAO.commit();
    } catch (SQLException e) {
      logger.error("Error occured while initialize.", e);
      if (dataClearDAO != null) dataClearDAO.rollback();
      throw new SQLException(e.getMessage());
    } finally {
      if (dataClearDAO != null) dataClearDAO.close();
    }
  }
Пример #2
0
 /**
  * ************************************************************************* PARAMETER 1: String:
  * configPath PARAMETER 2: String: batchId
  * ************************************************************************
  */
 public static void main(String[] args) {
   String batchId = null;
   String configPath = null;
   // TableList tableList = null;
   DatabaseInitialize databaseInitialize = null;
   // check paramter,if param is null, out print 1 and return;
   if (args.length < 2) {
     //			logger
     //					.error("configPath and BatchId can not be null,need input paramters");
     System.out.println("-1");
     return;
   } else {
     configPath = args[0];
     batchId = args[1];
   }
   logger = Logger.getLogger(args[0], DatabaseInitialize.class);
   logger.info(
       "configPath: " + configPath + ",BatchId: " + batchId + ",DataBase initialize start.");
   try {
     databaseInitialize = new DatabaseInitialize();
     databaseInitialize.initialize(configPath, batchId);
     logger.info(
         "configPath: "
             + configPath
             + ",BatchId: "
             + batchId
             + ",DataBase initialize successful.");
     System.out.println("0");
   } catch (NullPointerException e) {
     logger.error(
         "configPath: " + configPath + ",BatchId: " + batchId + ",NullPointerException ?.", e);
     logger.error(
         "configPath: "
             + configPath
             + ",BatchId: "
             + batchId
             + " can not been found,DataBase initialize fail.");
     System.out.println("1");
   } catch (SQLException e) {
     logger.error("configPath: " + configPath + ",BatchId: " + batchId + ",SQLException ?.", e);
     System.out.println("1");
   }
 }