How to query using NamedParameterJdbcTemplate.query() method?

[antsi klando]

I am not able to fetch two column values from the Database.

PFB the code

public List<Map<String, Object>> runSqlAndGetResult(String sql, List<Object> inputValues, List<String> outputKeyNames, DatabaseType dbType) {
Map<String, Object> paramMap = new HashMap<String, Object>();
for(int i =0; i< inputValues.size(); i++) {
			paramMap.put(String.valueOf(i+1), inputValues.get(i));
		}
		if(sql.trim().toLowerCase().startsWith("select")){
			EnvironmentContextHolder.setDatabaseType(dbType);
			GenericRowMapper rowMapper = new GenericRowMapper(outputKeyNames);
			// Select call.
			List<Map<String, Object>> result = namedParamJdbcTemplate.query(sql, paramMap, rowMapper);
s_logger.info("Result from this SQL: {}", result);
			return result;
}

where the sql query is "select po_no, created_dtm from purchase_order where cust_order_no =765765878"
outputKeyNames = [poNumber, created_dtm].

The problem is that it fetches the poNumber for the first time.For the created_dtm it returns null.

Please suggest a method.

[shai ban]

Check the date format/timezone in db.