You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openjpa.apache.org by Marc Logemann <li...@logemann.org> on 2009/03/03 01:37:35 UTC
FilterListener again
Hi,
unfortunately i got no response on my last thread:
http://n2.nabble.com/docs-concerning-FilterListener-and-other-extension-points-td2386615.html#a2387075
Is there nobody who can help me out with FilterListener aka custom
Functions in JPQL ? There is definitely no docs on them and no
discussions at all....
I have a query which looks like this:
Query query = em.createQuery("select d from DP_PLZ_DA d where
" +
"(d.plz = ?1 and lower(d.oname24) = ?2) or (d.plz = ?1 and
d.oname24.ext:soundex(?3))")
the soundex() function is my custom FilterListener but no matter how i
try to call this custom function, the JPQL Parser just jumps into my
head and complaining about the JPQL syntax.
Is there anyone on this planet who knows how to trigger custom
functions like these?
A little bit scaring is that there is almost no community support on
OpenJPA. Is IBM the only using it? :-)
Marc
Re: FilterListener again
Posted by Marc Logemann <li...@logemann.org>.
I just got my own message again in the list which i sent some days
ago.... if other also got this, please ignore, this one is already
disussed ....
Marc
Am 03.03.2009 um 18:29 schrieb Marc Logemann:
> Hi,
>
> ok, since feebdack on this one doesnt seem to work out and i only
> found fragments of a functionality i was sure that is in the current
> release of openJPA, i found out that FilterListener was just dropped
> out in terms of features (it was there when this product was called
> Kodo).
>
> There "was" a documentation regarding all this which you can see here:
> http://people.apache.org/~mprudhom/openjpa/site/openjpa-project/manual/ref_guide_enterprise_queryext.html#ref_guide_enterprise_queryext_jdoql
>
> But as it seems, nobody cared so far to implement this in the
> current JPQL parser. And thats where the fun starts because i always
> thought that a Kodo->OpenJPA migration is a no brainer. Its really
> sad because the backend site of this feature (Filter Extensions)
> should be there and only because the JPQL parser (compared to the
> JDO Parser back in Kodo) does only understand the default JPA spec
> grammar, its left out.
>
> IMO this was a brilliant feature of Kodo. So this a hughe step
> backwards.... I will checkout if MethodQL helps me somehow.
> Interessting that noone (especial no Kodo user) ever mentioned this
> in the list. Cant be that i am the only one using some more advanced
> Query features of Kodo.
>
> ---
> regards
> Marc Logemann
> http://www.logemann.org
> http://www.logentis.de
>
>
>
>
> Am 03.03.2009 um 01:37 schrieb Marc Logemann:
>
>> Hi,
>>
>> unfortunately i got no response on my last thread:
>>
>> http://n2.nabble.com/docs-concerning-FilterListener-and-other-extension-points-td2386615.html#a2387075
>>
>> Is there nobody who can help me out with FilterListener aka custom
>> Functions in JPQL ? There is definitely no docs on them and no
>> discussions at all....
>>
>> I have a query which looks like this:
>>
>> Query query = em.createQuery("select d from DP_PLZ_DA d where
>> " +
>> "(d.plz = ?1 and lower(d.oname24) = ?2) or (d.plz = ?1 and
>> d.oname24.ext:soundex(?3))")
>>
>> the soundex() function is my custom FilterListener but no matter
>> how i try to call this custom function, the JPQL Parser just jumps
>> into my head and complaining about the JPQL syntax.
>>
>> Is there anyone on this planet who knows how to trigger custom
>> functions like these?
>>
>> A little bit scaring is that there is almost no community support
>> on OpenJPA. Is IBM the only using it? :-)
>>
>> Marc
>
Re: FilterListener again
Posted by Marc Logemann <ml...@logemann.org>.
Hi,
ok, since feebdack on this one doesnt seem to work out and i only
found fragments of a functionality i was sure that is in the current
release of openJPA, i found out that FilterListener was just dropped
out in terms of features (it was there when this product was called
Kodo).
There "was" a documentation regarding all this which you can see here:
http://people.apache.org/~mprudhom/openjpa/site/openjpa-project/manual/ref_guide_enterprise_queryext.html#ref_guide_enterprise_queryext_jdoql
But as it seems, nobody cared so far to implement this in the current
JPQL parser. And thats where the fun starts because i always thought
that a Kodo->OpenJPA migration is a no brainer. Its really sad because
the backend site of this feature (Filter Extensions) should be there
and only because the JPQL parser (compared to the JDO Parser back in
Kodo) does only understand the default JPA spec grammar, its left out.
IMO this was a brilliant feature of Kodo. So this a hughe step
backwards.... I will checkout if MethodQL helps me somehow.
Interessting that noone (especial no Kodo user) ever mentioned this in
the list. Cant be that i am the only one using some more advanced
Query features of Kodo.
---
regards
Marc Logemann
http://www.logemann.org
http://www.logentis.de
Am 03.03.2009 um 01:37 schrieb Marc Logemann:
> Hi,
>
> unfortunately i got no response on my last thread:
>
> http://n2.nabble.com/docs-concerning-FilterListener-and-other-extension-points-td2386615.html#a2387075
>
> Is there nobody who can help me out with FilterListener aka custom
> Functions in JPQL ? There is definitely no docs on them and no
> discussions at all....
>
> I have a query which looks like this:
>
> Query query = em.createQuery("select d from DP_PLZ_DA d where
> " +
> "(d.plz = ?1 and lower(d.oname24) = ?2) or (d.plz = ?1 and
> d.oname24.ext:soundex(?3))")
>
> the soundex() function is my custom FilterListener but no matter how
> i try to call this custom function, the JPQL Parser just jumps into
> my head and complaining about the JPQL syntax.
>
> Is there anyone on this planet who knows how to trigger custom
> functions like these?
>
> A little bit scaring is that there is almost no community support on
> OpenJPA. Is IBM the only using it? :-)
>
> Marc
Re: FilterListener again
Posted by Pinaki Poddar <pp...@apache.org>.
> However it might make for an interesting feature.
Yes. These are the sort of features that helps distinction of one vendor
from the other. Kodo has it, but these features were not available when
OpenJPA was seeded from Kodo codebase.
FilterListeners for ORDER BY clauses are still active, and certain
Compatibility switches are available to control strictness of JPQL parsing.
--
View this message in context: http://n2.nabble.com/FilterListener-again-tp2412658p2423413.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
Re: FilterListener again
Posted by Michael Dick <mi...@gmail.com>.
I'd have to agree with Pinaki. However it might make for an interesting
feature. I'd guess that much of the infrastructure to support this function
is available in OpenJPA. So it'd make for a good JIRA feature. I can't
promise it'll be in the next release, but it's definitely worth considering.
-mike
On Tue, Mar 3, 2009 at 11:42 AM, Pinaki Poddar <pp...@apache.org> wrote:
>
> Hi,
> afaik, Kodo-styled :ext or SQL embeds are not supported in OpenJPA/JDOQL
> WHERE clause.
>
>
> Marc Logemann wrote:
> >
> > Hi,
> >
> > unfortunately i got no response on my last thread:
> >
> >
> http://n2.nabble.com/docs-concerning-FilterListener-and-other-extension-points-td2386615.html#a2387075
> >
> > Is there nobody who can help me out with FilterListener aka custom
> > Functions in JPQL ? There is definitely no docs on them and no
> > discussions at all....
> >
> > I have a query which looks like this:
> >
> > Query query = em.createQuery("select d from DP_PLZ_DA d where
> > " +
> > "(d.plz = ?1 and lower(d.oname24) = ?2) or (d.plz = ?1 and
> > d.oname24.ext:soundex(?3))")
> >
> > the soundex() function is my custom FilterListener but no matter how i
> > try to call this custom function, the JPQL Parser just jumps into my
> > head and complaining about the JPQL syntax.
> >
> > Is there anyone on this planet who knows how to trigger custom
> > functions like these?
> >
> > A little bit scaring is that there is almost no community support on
> > OpenJPA. Is IBM the only using it? :-)
> >
> > Marc
> >
> >
>
> --
> View this message in context:
> http://n2.nabble.com/FilterListener-again-tp2412658p2416756.html
> Sent from the OpenJPA Users mailing list archive at Nabble.com.
>
>
Re: FilterListener again
Posted by Pinaki Poddar <pp...@apache.org>.
Hi,
afaik, Kodo-styled :ext or SQL embeds are not supported in OpenJPA/JDOQL
WHERE clause.
Marc Logemann wrote:
>
> Hi,
>
> unfortunately i got no response on my last thread:
>
> http://n2.nabble.com/docs-concerning-FilterListener-and-other-extension-points-td2386615.html#a2387075
>
> Is there nobody who can help me out with FilterListener aka custom
> Functions in JPQL ? There is definitely no docs on them and no
> discussions at all....
>
> I have a query which looks like this:
>
> Query query = em.createQuery("select d from DP_PLZ_DA d where
> " +
> "(d.plz = ?1 and lower(d.oname24) = ?2) or (d.plz = ?1 and
> d.oname24.ext:soundex(?3))")
>
> the soundex() function is my custom FilterListener but no matter how i
> try to call this custom function, the JPQL Parser just jumps into my
> head and complaining about the JPQL syntax.
>
> Is there anyone on this planet who knows how to trigger custom
> functions like these?
>
> A little bit scaring is that there is almost no community support on
> OpenJPA. Is IBM the only using it? :-)
>
> Marc
>
>
--
View this message in context: http://n2.nabble.com/FilterListener-again-tp2412658p2416756.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.