Hi,

I am new to Hibernate and currently evaluating it. One important thing in the app I am currently working on is to generate SQL statement based on some complex logic at runtime, currently this is done by using special SQL generators we wrote.

If possible, in Hibernate 3, is there anyway to plug in my own SQL generator to handle this kind of senario?

Thanks

depends much on what that "complex sql logic is" - but providing your own Persister or extending the BasicEntityPersister and its friends then you can do about anything you want ,)

one example will be : if (a) then add Where clause1
else if (b) then add where clause2
else ....

In the App, 80% time, sql are predefined, so they can be put into XML, another 20% time, the sql is not known until runtime, in this case, can I handle the way you mentioned?

yes i would think so - at least you CAN (but i'm not saying its extremely easy ,)

...feature request for specific extensions points is welcome in the jira.