Skip to content

JdbcTemplate.queryForObject(sql, <primitive>.class) produces TypeMismatchDataAccessException [SPR-13220] #17811

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
spring-projects-issues opened this issue Jul 10, 2015 · 1 comment
Assignees
Labels
in: data Issues in data modules (jdbc, orm, oxm, tx) type: enhancement A general enhancement
Milestone

Comments

@spring-projects-issues
Copy link
Collaborator

spring-projects-issues commented Jul 10, 2015

Rob Winch opened SPR-13220 and commented

The following code

int i = jdbcTemplate.queryForObject(sql,int.class);

produces

org.springframework.dao.TypeMismatchDataAccessException: Type mismatch affecting row number 0 and column type 'null': Value [22] is of type [java.lang.Integer] and cannot be converted to required type [int]
	at org.springframework.jdbc.core.SingleColumnRowMapper.mapRow(SingleColumnRowMapper.java:101)
	at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93)
	at org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60)
	at org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:459)
	at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:404)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470)
	at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:480)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:490)
	at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:496)

Instead, Spring should convert the Integer to an int.

Migrating from Spring 4.1 to 4.2

This bug is much more apparent now that Spring 4.2 removed methods like int queryForInt(String sql). It seems that many users may update the following Spring pre 4.2 code:

int i = jdbcTemplate.queryForInt(sql);

to be

int i = jdbcTemplate.queryForObject(sql, int.class);

which would produce the above TypeMismatchDataAccessException. Obviously one could easily do:

int i = jdbcTemplate.queryForObject(sql, Integer.class);

to workaround the issue.


Affects: 4.2 RC2

Issue Links:

Referenced from: pull request #836, and commits e032930

@spring-projects-issues
Copy link
Collaborator Author

Juergen Hoeller commented

Fixed through a ClassUtils.resolvePrimitiveIfNecessary call in SingleColumnRowMapper.setRequiredType now, not involving NumberUtils itself. This avoids any kind of unchecked casts or other deviations from the generically specified Number parameter type in the actual conversion algorithm.

Juergen

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
in: data Issues in data modules (jdbc, orm, oxm, tx) type: enhancement A general enhancement
Projects
None yet
Development

No branches or pull requests

2 participants