You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@metamodel.apache.org by Balendra Singh <ba...@gmail.com> on 2014/04/15 12:14:19 UTC
Nested INNER query is not supported
I have a use-case in which I have to write a query having nested INNER
JOIN. Using Metamodel Api, we can write the query but while execution, it
is throwing following exception-
*org.eobjects.metamodel.query.parser.QueryParserException: Not capable of
parsing FROM token.*
It is throwing exception as in QueryParser.parse() function, it is trying
to fetch the from clause without considering that it can also have the
nested inner query as mentioned in the following screenshot -
[image: Inline images 1]
*Although <query>.toSql() is returning a valid query*.
So now I am trying to write query without nested inner query. If this is a
valid use-case so there should be provision to write it.
Thanks,
Balendra
Re: Nested INNER query is not supported
Posted by Kasper Sørensen <i....@gmail.com>.
Attachments doesnt work in the mailing lists AFAIK. So svare it via a JIRA
attachment or upload it somewhere and provide a link.
Den 16/04/2014 08.06 skrev "Henry Saputra" <he...@gmail.com>:
> Sorry Balendra, I do not see the attachment, anyone else saw it?
>
> Not sure if the mailing list drop the attachment or my gmail setting
>
> - Henry
>
>
> On Tue, Apr 15, 2014 at 10:36 PM, Balendra Singh
> <ba...@gmail.com> wrote:
> > Hi Henry,
> >
> > Attaching the image again.
> >
> >
> >
> > Thanks,
> > Balenrdra
> >
> >
> >
> > On 15 April 2014 23:14, Henry Saputra <he...@gmail.com> wrote:
> >>
> >> Hi Balendra,
> >>
> >> Hmm, seems like the image is not included in the mail to mailing list.
> >> Could you try to add it as attachment or link to external URL?
> >>
> >> - Henry
> >>
> >>
> >> On Tue, Apr 15, 2014 at 3:14 AM, Balendra Singh
> >> <ba...@gmail.com>wrote:
> >>
> >> > I have a use-case in which I have to write a query having nested INNER
> >> > JOIN. Using Metamodel Api, we can write the query but while execution,
> >> > it
> >> > is throwing following exception-
> >> >
> >> > *org.eobjects.metamodel.query.parser.QueryParserException: Not capable
> >> > of
> >> > parsing FROM token.*
> >>
> >> >
> >> > It is throwing exception as in QueryParser.parse() function, it is
> >> > trying
> >> > to fetch the from clause without considering that it can also have the
> >> > nested inner query as mentioned in the following screenshot -
> >> >
> >> > [image: Inline images 1]
> >> >
> >> > *Although <query>.toSql() is returning a valid query*.
> >>
> >> >
> >> > So now I am trying to write query without nested inner query. If this
> is
> >> > a
> >> > valid use-case so there should be provision to write it.
> >> >
> >> >
> >> >
> >> > Thanks,
> >> > Balendra
> >> >
> >> >
> >> >
> >> >
> >
> >
>
Re: Nested INNER query is not supported
Posted by Henry Saputra <he...@gmail.com>.
Sorry Balendra, I do not see the attachment, anyone else saw it?
Not sure if the mailing list drop the attachment or my gmail setting
- Henry
On Tue, Apr 15, 2014 at 10:36 PM, Balendra Singh
<ba...@gmail.com> wrote:
> Hi Henry,
>
> Attaching the image again.
>
>
>
> Thanks,
> Balenrdra
>
>
>
> On 15 April 2014 23:14, Henry Saputra <he...@gmail.com> wrote:
>>
>> Hi Balendra,
>>
>> Hmm, seems like the image is not included in the mail to mailing list.
>> Could you try to add it as attachment or link to external URL?
>>
>> - Henry
>>
>>
>> On Tue, Apr 15, 2014 at 3:14 AM, Balendra Singh
>> <ba...@gmail.com>wrote:
>>
>> > I have a use-case in which I have to write a query having nested INNER
>> > JOIN. Using Metamodel Api, we can write the query but while execution,
>> > it
>> > is throwing following exception-
>> >
>> > *org.eobjects.metamodel.query.parser.QueryParserException: Not capable
>> > of
>> > parsing FROM token.*
>>
>> >
>> > It is throwing exception as in QueryParser.parse() function, it is
>> > trying
>> > to fetch the from clause without considering that it can also have the
>> > nested inner query as mentioned in the following screenshot -
>> >
>> > [image: Inline images 1]
>> >
>> > *Although <query>.toSql() is returning a valid query*.
>>
>> >
>> > So now I am trying to write query without nested inner query. If this is
>> > a
>> > valid use-case so there should be provision to write it.
>> >
>> >
>> >
>> > Thanks,
>> > Balendra
>> >
>> >
>> >
>> >
>
>
Re: Nested INNER query is not supported
Posted by Balendra Singh <ba...@gmail.com>.
Hi Henry,
Attaching the image again.
Thanks,
Balenrdra
On 15 April 2014 23:14, Henry Saputra <he...@gmail.com> wrote:
> Hi Balendra,
>
> Hmm, seems like the image is not included in the mail to mailing list.
> Could you try to add it as attachment or link to external URL?
>
> - Henry
>
>
> On Tue, Apr 15, 2014 at 3:14 AM, Balendra Singh <balendrasingh@gmail.com
> >wrote:
>
> > I have a use-case in which I have to write a query having nested INNER
> > JOIN. Using Metamodel Api, we can write the query but while execution, it
> > is throwing following exception-
> >
> > *org.eobjects.metamodel.query.parser.QueryParserException: Not capable of
> > parsing FROM token.*
> >
> > It is throwing exception as in QueryParser.parse() function, it is trying
> > to fetch the from clause without considering that it can also have the
> > nested inner query as mentioned in the following screenshot -
> >
> > [image: Inline images 1]
> >
> > *Although <query>.toSql() is returning a valid query*.
> >
> > So now I am trying to write query without nested inner query. If this is
> a
> > valid use-case so there should be provision to write it.
> >
> >
> >
> > Thanks,
> > Balendra
> >
> >
> >
> >
>
Re: Nested INNER query is not supported
Posted by Henry Saputra <he...@gmail.com>.
Hi Balendra,
Hmm, seems like the image is not included in the mail to mailing list.
Could you try to add it as attachment or link to external URL?
- Henry
On Tue, Apr 15, 2014 at 3:14 AM, Balendra Singh <ba...@gmail.com>wrote:
> I have a use-case in which I have to write a query having nested INNER
> JOIN. Using Metamodel Api, we can write the query but while execution, it
> is throwing following exception-
>
> *org.eobjects.metamodel.query.parser.QueryParserException: Not capable of
> parsing FROM token.*
>
> It is throwing exception as in QueryParser.parse() function, it is trying
> to fetch the from clause without considering that it can also have the
> nested inner query as mentioned in the following screenshot -
>
> [image: Inline images 1]
>
> *Although <query>.toSql() is returning a valid query*.
>
> So now I am trying to write query without nested inner query. If this is a
> valid use-case so there should be provision to write it.
>
>
>
> Thanks,
> Balendra
>
>
>
>