WWWW

 public ArrayList getReportSource(String appId)  throws MSSApplicationException {   String methodName = "getReportSource";  ArrayList repSource = new ArrayList();  Connection connection = null;  ResultSet rs = null;  PreparedStatement stmt = null;  String sqlStmt = helper.getQuery("ReportQueryHelper.getReportSource");

  if (sqlStmt == null) {   MSSApplicationException re =    new MSSApplicationException(     getClass().getName(),     "getReportSource",     MSSGlobalMessages.I_PARAM_NULL, MSSGlobalMessages.PARAM_NULL,     "sqlStmt",null,"",getLoggedOnUser(),     MSSGlobalConstants.NON_CRITICAL_SEVERITY_CODE);   SSCLoggerToDB.getInstance().logToDB(re);   throw re;  }

  try {   connection = makeConnection();   stmt = connection.prepareStatement(sqlStmt);   stmt.setString(1, appId);   rs = stmt.executeQuery();

   while (rs.next()) {    ReportSourceValueObject myObj = new ReportSourceValueObject();

    myObj.appId = rs.getString("app_id");    myObj.sourceId = rs.getString("source_id");    myObj.sourceName = rs.getString("source_name");    myObj.host_url = rs.getString("host_url");    myObj.volume = rs.getString("volume");    myObj.login_userId = rs.getString("login_userid");    myObj.login_host = rs.getString("login_host");    //** Wang Hongwei Feb 07,2007    myObj.volume_type = rs.getString("volume_type");    //**end Wang Hongwei Feb 07, 2007

    repSource.add(myObj);   }

  } catch (SQLException sqlEx) {//   Add UxCode, Pengfei Shi, 25Jan2005   Uxcode.error("UXMSS104","SQLException - Failed to excute SQL statement");//   End UxCode    MSSApplicationException re =    new MSSApplicationException(     getClass().getName(),     "getReportSource",     MSSGlobalMessages.I_SQL_EXCEPTION, MSSGlobalMessages.SQL_EXCEPTION,     "",     sqlEx,     sqlStmt,     getLoggedOnUser(),     MSSGlobalConstants.NON_CRITICAL_SEVERITY_CODE);   SSCLoggerToDB.getInstance().logToDB(re);   log.error(methodName,maeID+re.getInstanceUniqueID(),sqlEx);   throw re;  } finally {      releaseDBResource(connection,stmt,rs);  }

  return repSource; }