Hi, I'm developping an application with CMP ejb2.1 on a JBoss4.0.
I'm working with a table clients (+- 5000 records, and 20 columns). Now I want to add a list ( <option ..... >) on a jsp page of all my clients. Therefore I only need two columns the id and the name. I created a ebjFindAll in my RemoteHome interface, with success. The list is filled with my clients. But my jboss has created 5000 instances of my bean. For every record, an instance. So all the 20 columns are populated to the instance. In fact in only use two columns, so this is hard work for my server. Is't there an other way around? Can't i create something like this in jboss??? public ResultSet findAll() throws FinderException,RemoteException; | and as QL | SELECT c.id c.name | FROM clients as c | I heared that this is possible on a weblogic server, but I don't know if jboss support this. Thanks in advance, Pieter Pareit View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3858698#3858698 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3858698 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
