Hi Jakob,
thanks for your answer. Will that feature be implemented in OJB 1.1? We have some queries where that feature is important for us. If this is just a matter of the MySQLPlatform-Implementation I could help out....or is this a general problem?
With regards Tino
Jakob Braeuchi wrote:
hi tino,
ojb does not use the limit-clause yet. the paging is implemented by positioning the cursor in the resultset.
jakob
Tino Schöllhorn schrieb:
Hi,
I am using MySQL and OJB and now I want to create a Query over a large table. For performance reason I want to use the "pageing"-feature - but I have the feeling that currently OJB is somehow ommitting this (the result is fine - but the SQL seems not to include the LIMIT-clause).
Is there a way to get the native SQL from a query which OJB would send to the database (this would help for other, complex queries too).
With regards Tino
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]