I have a legacy database table which we're trying to map to Hibernate. The table has about 50 columns, many records and the data will be displayed in a grid. Only a small subset of the columns will be displayed in the grid and the columns in that subset is configurable by the customer.

Is it possible to configure at runtime which fields were being fetched by Hibernate? I'd like Hibernate only to fetch the fields which the customer has specified they'd like to view.

Thanks for any and all help!
bg4

Hi,
You can use Hibernate Criteria queries with ResultTransformers.

Here's an example.

Criteria criteria = session.createCriteria(Car.class) ;
criteria.setProjection( Projections.projectionList() .add(Property.forName("name").as("name"))
.add(Property.forName("make").as("make"))
).setResultTransformer(new AliasToBeanResultTransformer(Car.class));
criteria.list() ;

Assume, Car has many more fields like top_speed, max_power etc. and user wants only name and make.

It is dynamic. Populate the projection list as per user preferences at run time.

The same can be realized using,
i) HQL Report queries.
ii) Native SQL queries.

ResultTransformer is not mandatory. You can omit it if are okay with handling object arrays.

----------------------------------------------------
Rate the reply if you find it helpful

Thank you! Very helpful