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.
