Query with nested constructor

Question

When i try this query with nested constructor with my custum DTO.

select new DTO.foo ( new DTO.boo( ... ) , new DTO.boo( ... ) ) from Foo

I got this error :

org.hibernate.hql.internal.ast.QuerySyntaxException: 
unexpected token: new near line 1, column 23 [ select new DTO.foo ( new DTO.boo( ... ) , .....

SOLUTION
Since we cannot have a constructor within a constructor because it's illegal in JPQL We resolve this issue by following the same approach over here : https://stackoverflow.com/a/12742926/1383538

it's a QuerySyntaxException so there is no generated hibernate query yet — Hayi
– Hayi, Commented Jul 27, 2016 at 18:26

Neil Stockton · Accepted Answer · 2016-07-27 18:22:18Z

6

That is illegal JPQL, as per the JPQL BNF notation

constructor_expression ::= NEW constructor_name ( constructor_item {, constructor_item}* )
constructor_item ::= single_valued_path_expression | scalar_expression | aggregate_expression |
    identification_variable

You cannot have a constructor within a constructor (i.e constructor_item cannot be a constructor_expression). See the JPA spec

answered Jul 27, 2016 at 18:22

Neil Stockton

11.6k3 gold badges36 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

acarlstein Over a year ago

Any ideas on how to go around it?

Collectives™ on Stack Overflow

Query with nested constructor

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related