Hibernate DS : ResultTransformer

[sidharth1917]

Hi Team,

We are using the Hibernate DS with correct foreign key associations for multiple collections in the domain object.

When we fetch multiple collections, we are getting multiple entries for the same record(just like Hibernate does as the query generated uses ‘left join fetch’).

To prevent this, in Hibernate, we can use the property ‘query.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)’. Is there anything like this that we can set on the Hibernate DS in SmartGWT.

Thanks.

[Isomorphic]

We don’t currently provide a way to apply this setting to the query object we automatically generate, so doing this would involve doing the entire query yourself (in a DMI for example) so that you can return your own results.