First try removing this part
OR
actr.GrossAmount >
-(
select
sum(pmt2.Amount)
from AppliedPayment pmt2
join
pmt2.ChargeAccountTransaction actr2
where
actr2.Id = actr.Id
)
If it work the problem is there and we have to figure out how re-write it
On Wed, Jun 30, 2010 at 5: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]<nhusers%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>
--
Fabio Maulo
--
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.
