Sorry but I didn't understand everything to what it have been said in here. All I know, this is the way I did it in fact, is : Query your database, get the results in a List or [] of rows (example : Datas = List<databaseRow>) which must be one of your backing bean attribute (with a getter) , then bind it to your t:dataTable and specify the "var" property (for example "data"), last, in your t:column you can output the values by doing data.attr.
Hopes this helps. Clément -----Message d'origine----- De : Johannes Hiemer [mailto:[EMAIL PROTECTED] Envoyé : jeudi 11 août 2005 17:05 À : MyFaces Discussion Objet : Re: Datatable and Hibernate query Hey guys, don't leave me alone, does nobody have an idea? Please!! :) Regards Johannes "MyFaces Discussion" <[email protected]> schrieb am 11.08.05 12:59:32: > > > Hi Martin, > hell yeah, finally we got the problem :) > Do I have to convert them to normal arrays, or what would you > recommend to do? Sorry for this question, I never worked with xobject > arrays, and I didn't find any docs either. > > Regards Johannes > > > "MyFaces Discussion" <[email protected]> schrieb am 11.08.05 > 12:45:53: > > Now everything is clear ;) > > > > those are object arrays, no beans - you can't use the point > > notation here. > > > > regards, > > > > Martin > > > > On 8/11/05, Johannes Hiemer <[EMAIL PROTECTED]> wrote: > > Hi Werner, > > you can finde the picture here: > > https://fotoalbum.web.de/gast/jhiemer/programming > > As you can see, the values got all the values you I need. > > > > Regards Johannes > > > > "MyFaces Discussion" <[email protected]> schrieb am 11.08.05 > > 11:23:39: > > > > > > Just a wild guess since I cannot see the attached picture (gmane > > > did not > > > store it) > > > > > > do you have lazy references, and do you open and close the session > > > before the rendering of the table. > > > > > > This is basically the cause of most access problems. > > > The main problem is, that if you access data which is lazyly bound > > > outside of a closed session you will get errors, most errors of feeding > > > data from a data source into the table happen that way, and the users > > > usually are left wondering why that happened, because the data objects > > > are there. > > > So either keep your session open until the last milisecond, or prefetch > > > the data you want to display in the session. > > > > > > > > > The best way to do the keep the session open as long as you need > > > is by > > > using a session per request filter > > > which opens the sessions before anything else is done > > > and closes it once everything else has finished. > > > Then you can mix and match lazy and non lazy references > > > left and right and do not have to care about the access code anymore. > > > > > > > > > See following references regarding this: > > > > > > http://http//hibernate.org/43.html > > > > > > and also > > > > > > http://wiki.apache.org/myfaces/HibernateAndMyFaces > > > > > > > > > this article mentions a one session per session filter, > > > but I cannot recommend that one unless you only have a handful of users: > > > > > > http://blog.exadel.com/?p=8 > > > > > > > > > > > > Johannes Hiemer wrote: > > > > Hi, > > > > I am getting into trouble with a bit adavanced hibernate query > > > > that I want to show up in a datatable. That is my hibernate query: > > > > public List getRequests() { > > > > return getHibernateTemplate() > > > > .find("from Request request, Customer > > > > customer, Employee employee, System system," > > > > + " Systemerror systemerror, Customee customee > > > > WHERE request.Rcustomer = customer.Cid" > > > > + " AND request.Rscheduler = employee.Eid AND > > > > request.Rfieldengineer = employee.Eid " > > > > + " AND request.Rtag = system.Sid AND > > > > request.Rerror = systemerror.Seid AND" > > > > + " request.Rcustomee = customee.Cid"); > > > > } > > > > > > > > And it returns the following structure > > > > @see attached picture. > > > > > > > > So I am loading the query just the normal way I always to into a > > > > list > > > > @SuppressWarnings("unchecked") > > > > private void populateRequestBean() { > > > > request = getRequestManager().getRequests(); > > > > } > > > > > > > > Now I try to get the values of the list in my datatable as an > > > > output. I tried many ways, but I did not get it till yet. > > > > > > > > <x:dataTable id="data" > > > > var="request" > > > > value="#{listrequestsSpringBean.request}"> > > > > <h:column> > > > > <f:facet name="header"> > > > > <h:outputText > > > > value="#{bundle.listrequestsRID}" /> > > > > </f:facet> > > > > <h:outputText > > > > value="#{request.object.request.rid}" /> > > > > </h:column> > > > > > > > > Is the way I am doing right or wrong? > > > > Did anyone solve a similiar problem? > > > > > > > > I hope anyone can help me. > > > > > > > > Thanks a lot > > > > > > > > Regards Johannes > > > > ______________________________________________________________ > > > > Verschicken Sie romantische, coole und witzige Bilder per SMS! > > > > Jetzt bei WEB.DE FreeMail: http://f.web.de/?mc=021193 > > > > > > > > > > > > > > > > > ____________________________________________________________________ > > _____ > > Mit der Gruppen-SMS von WEB.DE FreeMail können Sie eine SMS an alle > > Freunde gleichzeitig schicken: http://freemail.web.de/features/?mc=021179 > > > > > > > > > > > > > ______________________________________________________________ > Verschicken Sie romantische, coole und witzige Bilder per SMS! Jetzt > bei WEB.DE FreeMail: http://f.web.de/?mc=021193 > _________________________________________________________________________ Mit der Gruppen-SMS von WEB.DE FreeMail können Sie eine SMS an alle Freunde gleichzeitig schicken: http://freemail.web.de/features/?mc=021179
