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;
 }