I don't have a solution, but I can point you to some directions. It looks like you are doing some complex queries, I think you should look into HQL or native SQL queries.
About heiracharhical queries, you don't need "Oracle's CONNECT BY PRIOR and SQL Server's WITH", however I don't know what you're doing that make it complex. Sincerely, Will On Sep 7, 2: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 -~----------~----~----~----~------~----~------~--~---
