ERXSQLHelper has a FrontBaseSQLHelper subclass which implements limitExpressionForSQL(). Assuming that works, you could try
EOFetchSpecification spec = … //your fetch spec here EOModel model = EOModelGroup.defaultGroup().entityNamed(spec.entityName()).model(); ERXSQLHelper sqlHelper = ERXSQLHelper.newSQLHelper(ec, model.name()); String sql = sqlHelper.limitExpressionForSQL(null, spec, “", start, end); EOFetchSpecification fs = new EOFetchSpecification(spec.entityName(), null, null); fs.setHints(new NSDictionary(sql, EODatabaseContext.CustomQueryExpressionHintKey)); On Mar 5, 2015, at 6:16 AM, OC <[email protected]> wrote: > Hello there, > > unless I am missing something, it looks like with FrontBase, EOF/Wonder alas > limits fetches application-side, e.g., my code > > === > def fs=... > fs.fetchLimit=1 > ec.objectsWithFetchSpecification(fs) > === > > with SQL logging switched on yields a result of > > === > 14:00:57.072 DEBUG === Begin Internal Transaction > 14:00:57.073 DEBUG evaluateExpression: > <com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT > t0."C_EDITED_AUCTION_ID", t0."C_CREATION_DATE", t0."C_CREATOR_ID", > t0."C_IP_ADDRESS", t0."C_KIND", t0."C_MARKET_ID", t0."C_TITLE", t0."C_UID", > t0."C_EDITED_USER_ID" FROM "T_AUDIT" t0 ORDER BY t0."C_CREATION_DATE" ASC" > withBindings: > > 14:00:57.592 DEBUG fetch canceled > 14:00:57.592 DEBUG 1 row(s) processed > 14:00:57.600 DEBUG === Commit Internal Transaction > === > > FrontBase, nevertheless, does support fetch limits with the TOP syntax, e.g., > this SQL would work database-level: > > === > SELECT TOP(1) t0."C_EDITED_AUCTION_ID", t0."C_CREATION_DATE", > t0."C_CREATOR_ID", t0."C_IP_ADDRESS", t0."C_KIND", t0."C_MARKET_ID", > t0."C_TITLE", t0."C_UID", t0."C_EDITED_USER_ID" FROM "T_AUDIT" t0 ORDER BY > t0."C_CREATION_DATE" ASC > === > > Is there anything I could do to fix that my applicatio(s) really use this and > don't try to fetch the complete table? > > Thanks, > OC > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
