Dave,
I think LIMIT and OFFSET are SQL extensions implemented by some DBMSs. It certainly doesn't work for Oracle 8 or 9i. JBoss 3.0.6 just appends these to the SELECT statement. Maybe 3.2.x implements a CURSOR.
Ciao,
Jonathan O'Connor
| [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED] 04.06.2003 15:22
|
To: [EMAIL PROTECTED] cc: Subject: [JBoss-user] JBossQL & LIMIT, OFFSET |
Are LIMIT & OFFSET supported in JBossQL in 3.2.x? Or just in 4.x? I can't find where in the code it's supported (haven't tried to use it yet).
Dave
