JDBI ResultSetMapper: partially map row to a Class

Asked Jun 18 '14 at 07:03

Active Jun 18 '14 at 07:08

Viewed 1,898 times

When we define Mapper for a class, we have to fetch every column in sql queries in order to map with the Class in jdbc resultsetmapper

eg.

public class Mapper implements ResultSetMapper<MyClass>{
    public MyClass map(int index, ResultSet rs, StatementContext ctx) throws SQLException{
        MyClass mc = new MyClass();
        mc.setEntity1(rs.getString("column1"));
        mc.setEntity2(rs.getString("column2"));
        mc.setEntity3(rs.getString("column3"));
        return mc;
    }
}

For using this mapper, I have to fetch every column used in Mapper, but If I fetch only 2 columns it will throw PSQLException.

So instead of defining another Mapper for fetching 2 columns, is there any possible method to Use the same Mapper for mapping to MyClass?

edited Jun 18 '14 at 07:08

pingw33n

12,292
2
37
38

asked Jun 18 '14 at 07:03

Dheerendra

1,488
5
19
36

have you tried using `RowMapper` ? – Florescent Ticker Jun 18 '14 at 07:07
Post the exception's stack trace. – pingw33n Jun 18 '14 at 07:09
@pingw33n it says that "column3" is not found in resultset – Dheerendra Jun 18 '14 at 07:13
@FlorescentTicker I don't think that RowMapper will work as that also use ResultSet to map to columns – Dheerendra Jun 18 '14 at 07:15
So you want to fetch only columns that actually exist in the `ResultSet`? – pingw33n Jun 18 '14 at 07:16
@pingw33n yes. In some queries all columns can be present or in some queries only 2 or 1 columns can be present – Dheerendra Jun 18 '14 at 07:24
1

See http://stackoverflow.com/questions/3942583/how-to-check-that-a-resultset-contains-a-specifically-named-field. – pingw33n Jun 18 '14 at 07:25

JDBI ResultSetMapper: partially map row to a Class

0 Answers0