private void loadADSequences(){
  if (!isObjectExists("AD_Sequence",m_tables))   return;
  s_logger.log(Level.FINE,"loadADSequences",getDirection());
  String sql=s_dbEngine.sqlAD_getSequences(getVendor(),getCatalog(),getSchema());
  ResultSet rs=null;
  Statement stmt=null;
  m_sequenceSystem=new HashMap<String,Long>();
  m_sequenceUser=new HashMap<String,Long>();
  stmt=setStatement();
  rs=executeQuery(stmt,sql);
  while (getResultSetNext(rs)) {
    String seqName=getResultSetString(rs,"SEQ_NAME");
    if (seqName != null) {
      seqName=seqName.toUpperCase();
      long seqSystem=getResultSetLong(rs,"SEQ_SYS");
      long seqUser=getResultSetLong(rs,"SEQ_USER");
      m_sequenceSystem.put(seqName,seqSystem);
      m_sequenceUser.put(seqName,seqUser);
    }
  }
  releaseResultSet(rs);
  releaseStatement(stmt);
  s_logger.log(Level.FINE,"adSequencesLoaded",Integer.toString(m_sequenceSystem.size()));
  s_logger.flush();
  return;
}

private void loadADSequences ( ) { if ( ! isObjectExists ( "AD_Sequence" , m_tables ) ) return ; s_logger . log ( Level . FINE , "loadADSequences" , getDirection ( ) ) ; String sql = s_dbEngine . sqlAD_getSequences ( getVendor ( ) , getCatalog ( ) , getSchema ( ) ) ; ResultSet rs = null ; Statement stmt = null ; m_sequenceSystem = new HashMap < String , Long > ( ) ; m_sequenceUser = new HashMap < String , Long > ( ) ; stmt = setStatement ( ) ; rs = executeQuery ( stmt , sql ) ; while ( getResultSetNext ( rs ) ) { String seqName = getResultSetString ( rs , "SEQ_NAME" ) ; if ( seqName != null ) { seqName = seqName . toUpperCase ( ) ; long seqSystem = getResultSetLong ( rs , "SEQ_SYS" ) ; long seqUser = getResultSetLong ( rs , "SEQ_USER" ) ; m_sequenceSystem . put ( seqName , seqSystem ) ; m_sequenceUser . put ( seqName , seqUser ) ; } } releaseResultSet ( rs ) ; releaseStatement ( stmt ) ; s_logger . log ( Level . FINE , "adSequencesLoaded" , Integer . toString ( m_sequenceSystem . size ( ) ) ) ; s_logger . flush ( ) ; return ; }
load sequence counters defined in application dictionary
