How can I modify the generated SQL query of hibernate?

Question

I'm a little curious, is there a way to modify the hibernate's core so i can customize the generated SQL query. For example, to add functionality in the generated query to use connect by prior (oracle) or any other clause that I want to customize.

Martin Klinke · Accepted Answer · 2011-03-03 21:38:58Z

3

At first, such questions always ring some warning bells in me. You have been warned...

AFAIK, hibernate uses so called dialects for specific optimizations. Maybe you could extend one of the existing Oracle dialects or supply your own.

answered Mar 3, 2011 at 21:38

Martin Klinke

7,3426 gold badges44 silver badges64 bronze badges

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

Comments

limc · Accepted Answer · 2011-03-03 21:37:40Z

3

You can create your custom dialect by subclassing the Oracle dialect. That should be the easier approach, in my opinion. I really don't think you want to mess with the Hibernate Core.

answered Mar 3, 2011 at 21:37

limc

40.3k22 gold badges106 silver badges145 bronze badges

1 Comment

Garis M Suero Over a year ago

+1 for "I really don't think you want to mess with the Hibernate Core"... I really don't want to! :P

axtavt · Accepted Answer · 2011-03-04 09:18:11Z

1

DBMS-specific features such as CONNECT BY are usually used in Hibernate applications by issuing native SQL queries. Their results can be mapped to entities so that you can use them almost the same way as regular HQL queries.

Attempts to make Hibernate generate them would be an overkill.

See also:

Chapter 18. Native SQL

answered Mar 4, 2011 at 9:18

axtavt

243k42 gold badges518 silver badges486 bronze badges

Collectives™ on Stack Overflow

How can I modify the generated SQL query of hibernate?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related