One more thing, this seems to run fine Nhibernate Query Analyzer. G
On Jun 30, 1:21 pm, gary lucas <[email protected]> wrote: > I'm in the process of migrating a fairly large application to > nHibernate 2.1.2 and most queries work, however this one is > problematic. > > ---------------------------------- > {"Exception of type 'Antlr.Runtime.NoViableAltException' was thrown. > [ > from Account act > left join fetch act.AccountTransactions actr > left join fetch actr.ChargeAppliedPayments cap > left join fetch actr.PaymentAppliedPayments pap > left join fetch actr.Type typ > where act.Id = :Id > and typ.ClassCode <> :payment > and ( > NOT EXISTS > (select > pmt1.Id > from > AppliedPayment pmt1 > join pmt1.ChargeAccountTransaction actr1 > where > actr1.Id = actr.Id > ) > OR > actr.GrossAmount > > -( > select > sum(pmt2.Amount) > from AppliedPayment pmt2 > join > pmt2.ChargeAccountTransaction actr2 > where > actr2.Id = actr.Id > ) > ) > ORDER BY actr.Id asc > -------------------------------------- > > in searching the forums I couldn't find allot of definitive answers on > the subject of antlr errors... I know the issue resides in the > subquery... However this worked in 1.2, and seems to have issues > now... > > Thank you > > Gary -- 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.
