Unable to use dynamic named queries on hibernate-orm

[i96751414]

Describe the bug

Hello,

I just realised it is not possible to use typed queries (where the result class is an entity - annotated with @entity) for named queries which are created dynamically (using hibernate-orm).

When using the below approach:
entityManager.getEntityManagerFactory().addNamedQuery("name", entityManager.createNativeQuery("sql string", ResultClassEntity.class));

and then getting the created query through:
entityManager.createNamedQuery("name", ResultClassEntity.class)

the following exception is thrown:
java.lang.IllegalArgumentException: Named query exists, but did not specify a resultClass

Kindly

Expected behavior

No response

Actual behavior

No response

How to Reproduce?

No response

Output of uname -a or ver

No response

Output of java -version

No response

GraalVM version (if different from Java)

No response

Quarkus version or git rev

No response

Build tool (ie. output of mvnw --version or gradlew --version)

No response

Additional information

No response

[quarkus-bot]

/cc @Sanne (hibernate-orm), @gsmet (hibernate-orm), @yrodiere (hibernate-orm)

[yrodiere]

Hello,

Thanks for reporting.

It would help a lot if your could please provide a self-contained reproducer, i.e. a Quarkus project that attempts to do this and should work, but does not.

[yrodiere]

Hey,

Did you have time to work on a reproducer?

[i96751414]

Hello.

My apologies for not having submitted a reproducer - I will try to generate one until the end of the week.

Cheers

[yrodiere]

Hey @i96751414, any news on that reproducer?

Thanks.

[i96751414]

Apologies for the delay in creating the reproducer.
This is a very simple and quick example, which only does 2 things:
1 - Add an item to a DB
2 - Get the item from the DB (the part which is failing here)

See dynamic-named-queries.zip

[yrodiere]

Thank you @i96751414 , we will have a look.

[yrodiere]

So... this seems to be a bug in Hibernate ORM itself: https://hibernate.atlassian.net/browse/HHH-17566

I think you could work around the problem by using non-native (HQL) queries.

[yrodiere]

To clarify, I reported the bug to the Hibernate ORM team and we'll wait for it to be solved upstream.

Thanks for reporting!