The query itself :-) I applied a rownum limit on the query using nested views that that helped expedite the transfer of only the necessary records from the database layer to the java layer as objects of BasicDynaBeans.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 8:34 AM To: Struts Users Mailing List Subject: RE: RowSetDynaClass I'm curious. When I proposed the use of RowSetDynaClass yesterday, you replied that it wasn't fast enough. What changed? Dennis "CRANFORD, CHRIS" <[EMAIL PROTECTED]> 06/15/2004 01:46 AM Please respond to "Struts Users Mailing List" <[EMAIL PROTECTED]> To 'Struts Users Mailing List' <[EMAIL PROTECTED]> cc Subject RE: RowSetDynaClass Found the answer ;-) ... Avoid the <c:...> tags all together and stick with the standard struts tags. The following worked: <logic:iterate id="row" name="results" property="rows" scope="request" indexId="rowid"> <bean:write name="row" property="item_id" /> - <bean:write name="row" property="item_product_number"/> </logic:iterate> Now have a fast, efficient paging mechanism that permits me to pass in a database connection object, the sql query to execute, starting page # and size and it handles the rest by populating itself from the database, closing the resultset when finished and leaves the presentation part up to my JSP as above! Gotta love struts! Chris -----Original Message----- From: CRANFORD, CHRIS [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 15, 2004 12:35 AM To: '[EMAIL PROTECTED]' Subject: RowSetDynaClass I am storing a RowSetDynaClass property in my java class and I have implemented a method on my class as follows: public Collection getRows() { return((Collection)rsdc.getRows()); } In my action, I store my custom class object reference as follows: request.setAttribute("results", myResultsObj); Then in my jsp, I do the following: <bean:define scope="request" id="data" name="results" property="rows" /> <c:forEach var="row" items="${data}" varStatus="rowid"> <c:out value="${rowid.count}"/>. <c:out value="${row.item_id}" /> - <c:out value="${row.item_product_number}" /> </c:forEach> I get the following error: [ServletException in:/pages/test-body.jsp] An error occurred while evaluating custom action attribute "value" with value "${row.item_id}": Unable to find a value for "item_id" in object of class "org.apache.commons.beanutils.BasicDynaBean" using operator "." (null) Can someone tell me what I am doing wrong here and how I can do this properly to get it to work? _______________________________________________________ Chris Cranford Programmer/Developer SETECH Inc. & Companies 6302 Fairview Rd, Suite 201 Charlotte, NC 28210 Phone: (704) 362-9423, Fax: (704) 362-9409, Mobile: (704) 650-1042 Email: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
