ParameterizedSingleColumnRowMapper. Why doesn't normal constructor set requiredType?

[Edward Winchester]

Hello,

I had written the following code expecting it to work:

        List<Long> existingIds = jdbc.query(
                "SELECT AGENT_EMAIL_ID FROM AGENT_EMAIL WHERE AGENT_ID = ?",
                new ParameterizedSingleColumnRowMapper<Long>(), agentId);

It was actually creating a list of Integer objects, not Long objects! I now understand this is because the requiredType class wasn't being set within the mapper so it was looking at the result set meta data for the sql type and determining it was best mapped to Integer.

Replacing it with this form does the trick:

        List<Long> existingIds = jdbc.query(
                "SELECT AGENT_EMAIL_ID FROM AGENT_EMAIL WHERE AGENT_ID = ?",
                ParameterizedSingleColumnRowMapper.newInstance(Long.class), agentId);

Is it not possible for Spring to set the required type in the plain constructor form? Doesn't the ParameterizedSingleColumnRowMapper have access to the type that it's been parameterized with?

I'm annoyed that I've been caught out by this and suspect it won't be the first time!

Thanks,

Ed