This should help http://nhforge.org/blogs/nhibernate/archive/2008/09/06/prepare-your-system-for-nhibernate.aspx
Tuna Toksöz http://tunatoksoz.com http://turkiyealt.net http://twitter.com/tehlike Typos included to enhance the readers attention! On Sat, Mar 7, 2009 at 1:46 AM, robcar <[email protected]> wrote: > > It seems that this is a confirmed bug > http://jira.nhibernate.org/browse/NH-1617 > > And it seems it is fixed in the trunk version. > > To show myself as the complete newbie I am. How do I go about > downloading the this version and compiling it? > > /Robin > > On 6 Mar, 11:55, robcar <[email protected]> wrote: > > Is there anyway to hook into the executing of the SQL so that I can > > alter the SQL before it is executed? > > > > Or anyway to stop NHibernate from being "smart". > > > > The SQL NHibernate tries to execute as a result of the configuration > > (with the formula) is this: > > SELECT this_.PriceId as PriceId0_0_, > > this_.Multiplier as Multiplier0_0_, > > this_.EffectiveDate as Effectiv3_0_0_, > > (ROW_NUMBER() this_.OVER (this_.PARTITION BY this_.AgreementId > ORDER > > BY this_.EffectiveDate DESC)) as formula0_0_ > > FROM Price this_ > > > > I just need to change this to: > > > > SELECT this_.PriceId as PriceId0_0_, > > this_.Multiplier as Multiplier0_0_, > > this_.EffectiveDate as Effectiv3_0_0_, > > (ROW_NUMBER() OVER (PARTITION BY this_.AgreementId ORDER BY > > this_.EffectiveDate DESC)) as formula0_0_ > > FROM Price this_ > > > > Please anyone? > > > > On 5 Mar, 19:36, robcar <[email protected]> wrote: > > > > > > > > > Thanks guys, my bad! > > > > > I did some testing enclosing it in parenthesis and messed up when > > > posting. > > > Unfortunately this isn't the problem. NHibernate still doesn't > > > recognize OVER and PARTITION as reserved words. > > > > > I also think I messed up with adding a column alias, so the "correct" > > > formula (that stil causes an exception) is: > > > ROW_NUMBER() OVER (PARTITION BY AgreementId ORDER BY EffectiveDate > > > DESC)- Dölj citerad text - > > > > - Visa citerad text - > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
