OpenJPA seems to have lack of its OUTER JOIN functionality it is impossible to right the query like this:
select fv.id, fv.name, flv.value from fieldvalues fv LEFT OUTER JOIN fieldlanguagesvalues flv ON (fv.id = flv.fieldvalues_id AND flv.language_id = 45) LIMIT 40; It is possible to write SELECT flv FROM Fieldvalues fv LEFT OUTER JOIN fv.fieldlanguagesvalues AS flv but as soon as I try to add flv.language_id constraint I get "Empty set" even Native query is not working I'm disappointed :( I'll add alternative code for that. On Sat, Sep 29, 2012 at 4:13 PM, [email protected] < [email protected]> wrote: > Thanks! > > -Dwicket.mode=DEVELOPMENT is working if you do make a complete > re-install/re-build. > I just run jar.only and was expecting some change to happen, however this > won't work. > I think that is okay, no need to dig deeper into the wicket.mode. > > > Sebastian > > 2012/9/29 Maxim Solodovnik <[email protected]> > >> OK. I'll correct that >> On Sep 29, 2012 3:19 PM, "[email protected]" <[email protected]> >> wrote: >> >>> I have attached my comments to: >>> https://issues.apache.org/jira/browse/OPENMEETINGS-429 >>> >>> Sebastian >>> >>> 2012/9/29 [email protected] <[email protected]> >>> >>>> I see also some changes in the way the language editor behaves. >>>> Formerly the language editor did load a list of Fieldvalues with the >>>> Fieldlanguagesvalues joined. >>>> Fieldvalues contains the *name *of the label >>>> Fieldlanguagesvalues contains the *value* of the label >>>> >>>> If the Fieldlanguagesvalues(value) is NULL the query still returns a >>>> entry with the name. >>>> >>>> That has the advantage that if you load a language where ZERO >>>> translations have been done (or incomplete) then the label names are >>>> already in the table and you can update/complete the translation by >>>> clicking on any label and save it. >>>> >>>> But as you now are loading only Fieldlanguagesvalues the table is >>>> simply empty. >>>> If you create a new language, the whole table is empty and you can't >>>> update anything. What happens if you press "new" now, is it going to add a >>>> new label at labelid 1510 or at labelid 1 ? >>>> >>>> I think this should be reverted again to load the list of label names >>>> and not the list of label values. >>>> >>>> Sebastian >>>> >>>> >>>> 2012/9/29 Maxim Solodovnik <[email protected]> >>>> >>>>> It should be enabled by this option. I'll doublecheck >>>>> On Sep 29, 2012 2:40 PM, "[email protected]" < >>>>> [email protected]> wrote: >>>>> >>>>>> Hi Maxim, >>>>>> >>>>>> I was wondering if I did miss something or if it is not inted to be >>>>>> that way: >>>>>> I thought by using -Dwicket.mode=DEVELOPMENT I would get the Ajax >>>>>> debug console of Wicket again. >>>>>> But it doesn't. Is that an issue with a compiler option not being set >>>>>> or do we need to manually enable it in the Application.init method for >>>>>> now? >>>>>> >>>>>> Thanks! >>>>>> Sebastian >>>>>> >>>>>> -- >>>>>> Sebastian Wagner >>>>>> https://twitter.com/#!/dead_lock >>>>>> http://www.webbase-design.de >>>>>> http://www.wagner-sebastian.com >>>>>> [email protected] >>>>>> >>>>> >>>> >>>> >>>> -- >>>> Sebastian Wagner >>>> https://twitter.com/#!/dead_lock >>>> http://www.webbase-design.de >>>> http://www.wagner-sebastian.com >>>> [email protected] >>>> >>> >>> >>> >>> -- >>> Sebastian Wagner >>> https://twitter.com/#!/dead_lock >>> http://www.webbase-design.de >>> http://www.wagner-sebastian.com >>> [email protected] >>> >> > > > -- > Sebastian Wagner > https://twitter.com/#!/dead_lock > http://www.webbase-design.de > http://www.wagner-sebastian.com > [email protected] > -- WBR Maxim aka solomax
