hi sukesh,
afaik the limits cannot be defined in the oql-query. but you can do the following:
OQLQuery query = odmg.newOQLQuery(); query.create( "select ....." ); query.bind( ... ); ((Query)query).setStartAtIndex(....);
hth jakob
Sukesh Garg wrote:
Is there support for "limit" in the OJB's ODMG implementation.
e.g. select * from tableName order by id limit 5
thx, sukesh
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Hi all,
Not with oql query but if you do same thing with:EnhancedOQLQuery query = m_odmg.newOQLQuery();
query.create("select id from " + Address.class.getName(), 1, 3 );org.apache.ojb.odmg.oql.EnhancedOQLQuery has a create method with offset and limit
Hope it's help
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
