> > If you want write always multi-RDBMS HQL you should ensure to use > multi-RDBMS functions and, where you need something special, you > should extend each dialect properly. > Ok. Just to put us on the same page let's take an example. We have a Meeting class (StartDate, Duration). We need get answer for the question "Get all meetings that end on
or after the given date/time" That's basically what original post was about. Assumming that we have to support MsSql 2000, 2005, 2008, Oracel9, MySql and PosgressSQL. According to what you mentioned I think I can to do the following: 1. Use HQL "from Meeting m where IsPointAfterTimeslot(:timeToCompare, m.StartDate, m.Duration)" 2. Create a function IsPointAfterTimeslot that takes 3 parameters for each Database. 3. Extend all the dialects I have to support with additional function. Is it the best approach or you can suggest something better? Cheers, Dmitriy. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
