| ConstructorResultNativeQueryTest has @SqlResultSetMapping mappings like the following: {{@SqlResultSetMapping(
name = "person-id-and-name",
classes = {
@ConstructorResult(
targetClass = Person.class,
columns = { @ColumnResult( name = "id" ), @ColumnResult( name = "p_name" ) } )
}
)}} The corresponding constructor is: {{public Person(Integer id, String name) { this.id = id; this.name = name; } }} The problem is that, for Oracle, the Integer ID is mapped as a Number(10,0) column, so the value will be returned as a BigDecimal. Because the constructor takes an Integer argument (not a BigDecimal), no appropriate constructor can be found. The fix in this case is to specify the type in the @ColumnResult: @ColumnResult( name = "id", type=Integer.class ) |