Re: [hibernate-dev] 6.0 - ResultTransformer

So again, this all boils down to the interplay with (Result|Tuple|ResultList)Transformer, dynamic instantiations, and result-types. So let's look at some specific cases... First some cases I think are perfectly valid: session.createQuery( "select new map(...) ...", Map.class ) - returns a List<Map<String,?>> session.createQuery( "select new list(...) ...", List.class ) - returns a List<List> (rather than List<Object[]>) session.createQuery( "select new DTO(...), DTO.class ) - returns a List<DTO> Ok, so I cheated there by not including transformers :) So let's look at adding transformers into this mix[1]. session.createQuery( "select new map(...) ...", Map.class ) .setTupleTransformer( new TupleTranformer<SomeNonMap>() {...} ) this one is illegal. It defines the Query resultType as Map, but the applied TupleTranformer is transforming those to SomeNonMap -> CCE. This should be either: session.createQuery( "select new map(...) ...", SomeNonMap.class ) .setTupleTransformer( new TupleTranformer<SomeNonMap>() {...} ) or (non-typed): session.createQuery( "select new map(...) ..." ) .setTupleTransformer( new TupleTranformer<SomeNonMap>() {...} ) In both of those cases, the TupleTranformer is handed a Object[] where the only element is the Map. I guess too that defines the blueprint for what is and what is not supported and how the various pieces apply. But I am still not sure about the semantic wrt TupleTransformer and/or dynamic-instantiation in combination with Tuple. I kind of think those should just be illegal combos: session.createQuery( "select ...", Tuple.class ) .setTupleTransformer( () -> ... ) Unless the TupleTransformer is building a Tuple, I that is a bad combo for sure. I thik dynamic-instantiation and TupleTransformer is ok: session.createQuery( "select new DTO(...) ..." ) .setTupleTransformer( () -> ... ) Here the TupleTransformer would get Object[] with the long element being the DTO; the "query result" is whatever the TupleTransformer returns. Any other specific combos we should clarify? [1] I am using the new TupleTransformer and ResultListTransformer breakdowns I have defined on 6.0 : https://gist.github.com/sebersole/bc721caa20a5e4a97cbde44567b0b2ea On Tue, Sep 13, 2016 at 8:52 AM Steve Ebersole <steve(a)hibernate.org&gt; wrote: