Change Notes item #681216, was opened at 2003-02-05 12:44 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=381174&aid=681216&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Priority: 5 Submitted By: Jeremy Boynes (jboynes) Assigned to: Nobody/Anonymous (nobody) Summary: JBossQL Limit/Offset support Initial Comment: Support has been added for restricting the amount of data fetched from a JDBC database. JBossQL now supports optional OFFSET and LIMIT parameters supplied at the end of a query. An example would be SELECT OBJECT(o) FROM Order o WHERE o.status = ?1 ORDER BY o.orderDate OFFSET ?2 LIMIT ?3 This works by discarding rows until <offset> rows have been fetched and then returning immedately once another <limit> rows have been fetched. This simple mechanism is intended to preserve portability across database vendors. Other approaches including scrollable cursors or database-specific syntax may be considered later. Currently the parameters passed to LIMIT and OFFSET must be int values (or Integer for DynamicQL) as in the finder Collection findAllOrders(String status, int offset, int limit) throws FinderException; ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=381174&aid=681216&group_id=22866 ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
