Yes, that is how you usually would handle such things, because it is specific for each dialect. Another option is to change the schema so you can perform hierarchical queries using standard relations, in effect, de-normalizing the association.
On Sep 7, 9:36 pm, Ricardo Peres <[email protected]> wrote: > Hi, > > I have asked this before, but got no answer, so here I go again: what > is the best way to perform hierarchical queries, such as Oracle's > CONNECT BY PRIOR and SQL Server's WITH? > > I thought about having SQL queries (<sql-query> elements) and then > using a AliasToBean transformer, the problem is that I would need > different queries for each DB engine. > > Thanks, > > RP --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
