Spring-RowMapper-DB2-Stored Procedure

[suresh saro]

Am trying to execute the below program:

Am getting the resultset as blank (i.e) []

CAN ANYONE PLEASE HELP ME ON THIS?
Thanks in Advance!!

public class AgentInfoDAOImpl extends BaseJdbcDAO implements AgentInfoDAO {
	private static final Log log = LogFactory.getLog(AgentInfoDAOImpl.class);
	private static final String RETURN_SUCCESS = "000";
	private String dbSchema;
	private AgencyProfileDTO agProfile;
	private ProducerDetailsDTO prodDetails;
	private Map input = new HashMap();
	private String licenseStatus;
	 
	/**
	* Uses the Inner Class StoredProcAGSIM028, to create the Database connection and execute the stored procedure.
	* @see com.nationwide.ag.persistence.dao.jdbc.AgentInfoDA O#getProducerList(com.nationwide.ag.dto.AgInfoSear chCriteriaDTO)
	*/
	public ProducerDetailsDTO getProducerList(
			AgInfoSearchCriteriaDTO agSCriteria) throws ResourceException {
		StoredProcAGSIM028 storedProc = new StoredProcAGSIM028(getJdbcTemplate());
		 
		prodDetails = new ProducerDetailsDTO();
		buildInput(agSCriteria, "AGSIM028");
		storedProc.executeStoredProc(input);
		return prodDetails;
	}
	 
	private void buildInput(AgInfoSearchCriteriaDTO agSCriteria, String ticket) {
		if (ticket.equals("AGSIM028")) {
			input.put("I_AGCY", "00000869");
			input.put("I_PRODUCER", "");
			input.put("C_STATUS", "AC");
		}
	}
	 
	private DataAccessException buildDataAccessException(final Map inParams,
			final org.springframework.dao.DataAccessException exception,
			final String storedProcedureName) {
		String msg = "Failed to execute stored procedure " +
		storedProcedureName + " because of database reason " +
		exception.getMessage();
		 
		DataAccessException dataException = new DataAccessException(msg,
		ErrorCode.DEFAULT, exception);
		dataException.addDataItem("inParams", inParams);
		log.error(msg, exception);
		 
		return dataException;
	}
	 
	/**
	* @return Returns the dbSchema.
	*/
	public String getDbSchema() {
		return dbSchema;
	}
	 
	/**
	* @param aDBSchema The dbSchema to set.
	*/
	public void setDbSchema(final String aDBSchema) {
		dbSchema = aDBSchema;
	}
	private class StoredProcAGSIM028 extends StoredProcedure {
		public static final String SQL = "AGSIM028";
	 
		/**
		* Constructor to define the stored proc parameters (INPUT & OUTPUT).
		* @param jdbcTemplate
		*/
		public StoredProcAGSIM028(final JdbcTemplate jdbcTemplate) {
			super(jdbcTemplate, getDbSchema() + "." + SQL);
			declareParameter(new SqlReturnResultSet("T_FIRST_NAME", new DataMapper()));
			declareParameter(new SqlParameter("I_AGCY", Types.CHAR));
			declareParameter(new SqlParameter("I_PRODUCER", Types.CHAR));
			declareParameter(new SqlParameter("C_STATUS", Types.CHAR));
			declareParameter(new SqlOutParameter("AG2_RC", Types.CHAR));
			declareParameter(new SqlOutParameter("AG2_RC_CAUSE", Types.CHAR));
			declareParameter(new SqlOutParameter("AG2_SQLCA", Types.CHAR));
			declareParameter(new SqlOutParameter("AG2_SQLCODE",
					Types.DECIMAL));
			declareParameter(new SqlOutParameter("AG2_SQLCERM", Types.CHAR));
			compile();
		}
	 
		/**
		* Executes the stored procs.
		* @param inParams - a Map containing the input parameters to the stored procedure
		* @throws DataAccessException when execution of stored procs fails
		*/
		public void executeStoredProc(final Map inParams)
				throws DataAccessException {
			Map out = null;
			startTimer();
			 
			try {
				out = execute(inParams);
				List productList = (List) out.get("T_FIRST_NAME");
				List l = (List)out.get("T_FIRST_NAME");
				System.out.println(l);
			} catch (org.springframework.dao.DataAccessException e) {
				throw buildDataAccessException(null, e, SQL);
			}
			stopTimer("Execute Stored Proc...." + SQL);
		}
	 
	}
	 
	/**
	* DataMapper is an Inner class which implements the RowMapper.
	*/
	private class DataMapper implements RowMapper {
		/**
		* Method to map the ResultSet to the Object.
		* @param ResultSet
		* @param Number of Rows
		*/
		public Object mapRow(ResultSet rs, int rowNum)
				throws SQLException {
			return rs.getString("T_FIRST_NAME");
		}
	}
}