private static void fillChangeLog(){
  ArrayList<Integer> list=new ArrayList<Integer>(40);
  String sql="SELECT t.AD_Table_ID FROM AD_Table t " + "WHERE t.IsChangeLog='Y'" + " OR EXISTS (SELECT * FROM AD_Column c "+ "WHERE t.AD_Table_ID=c.AD_Table_ID AND c.ColumnName='EntityType') "+ "ORDER BY t.AD_Table_ID";
  PreparedStatement pstmt=null;
  ResultSet rs=null;
  try {
    pstmt=DB.prepareStatement(sql,null);
    rs=pstmt.executeQuery();
    while (rs.next())     list.add(new Integer(rs.getInt(1)));
  }
 catch (  Exception e) {
    s_log.log(Level.SEVERE,sql,e);
  }
 finally {
    DB.close(rs,pstmt);
    rs=null;
    pstmt=null;
  }
  s_changeLog=new int[list.size()];
  for (int i=0; i < s_changeLog.length; i++) {
    Integer id=(Integer)list.get(i);
    s_changeLog[i]=id.intValue();
  }
  s_log.info("#" + s_changeLog.length);
}

private static void fillChangeLog ( ) { ArrayList < Integer > list = new ArrayList < Integer > ( 40 ) ; String sql = "SELECT t.AD_Table_ID FROM AD_Table t " + "WHERE t.IsChangeLog='Y'" + " OR EXISTS (SELECT * FROM AD_Column c " + "WHERE t.AD_Table_ID=c.AD_Table_ID AND c.ColumnName='EntityType') " + "ORDER BY t.AD_Table_ID" ; PreparedStatement pstmt = null ; ResultSet rs = null ; try { pstmt = DB . prepareStatement ( sql , null ) ; rs = pstmt . executeQuery ( ) ; while ( rs . next ( ) ) list . add ( new Integer ( rs . getInt ( 1 ) ) ) ; } catch ( Exception e ) { s_log . log ( Level . SEVERE , sql , e ) ; } finally { DB . close ( rs , pstmt ) ; rs = null ; pstmt = null ; } s_changeLog = new int [ list . size ( ) ] ; for ( int i = 0 ; i < s_changeLog . length ; i ++ ) { Integer id = ( Integer ) list . get ( i ) ; s_changeLog [ i ] = id . intValue ( ) ; } s_log . info ( "#" + s_changeLog . length ) ; }
fill log with tables to be logged
