I have a requirement to create dynamic query. its native as some specific database keyword which only works it that DB,
I am using Spring boot.
Issue is I can not use the Entity Manger out of the box as we have seen issues if do so.
can u please guide the resources or some example to do so
If you can’t use Hibernate or JPA APIs, your question probably is better suited to a Spring forum, rather than the Hibernate forum. Having said that, AFAIK dynamic native queries can only be done by calling EntityManager.createNativeQuery. So ditch these Spring abstractions and use Hibernate directly.
Issue is I can not use the Entity Manger out of the box as we have seen issues if do so.
Then tell us what issues you are facing and we might be able to help you.