Hi all,
We're using LIMIT/OFFSET with DynamicQL in our JBoss-application for a complex query.
That works fine.
Now I want to know how many rows are in the full result.
I know that JBoss does not send the LIMIT/OFFSET-clause to the database but handles
this itself. So, JBoss should know how many rows are in this resultset.
Is there ANY way to get this rowcount after executing the query?
I know I could use COUNT with the query to get the desired value, but that would mean
more load on the database, which is already the bottleneck.
Versions used: JBoss 3.2.5
PostgresQL 7.3.4
The ejbQL-Query used: "SELECT OBJECT(d) FROM Document d ORDER BY d.archivierungAm DESC
LIMIT ?1 OFFSET ?2"
any help would be highly appreciated,
Kind Regards,
Silvio
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3844642#3844642
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3844642
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
