Isolated the issue:
------
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
----------------
The parser can't seem to handle the '-' sign in 'OR actr.GrossAmount
> -'
Gary
On Jul 6, 3:55 pm, gary lucas <[email protected]> wrote:
> I did try (random re-writing) commenting out one then the other parts
> of the subquery...
>
> Both returned the same error.
>
> I'll take another look at it tomorow.
>
> Thank you both.
>
> Gary
>
> On Jul 5, 2:29 pm, Fabio Maulo <[email protected]> wrote:
>
>
>
> > 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.
