Hi,
Im using the following JBoss-QL query in JBoss 3.2.3 for a ejbSelect method:
SELECT OBJECT(p) FROM Category AS c, IN (c.products) AS p
WHERE c = ?1
AND p.state IS NOT NULL
AND p.state = 'passiv'
ORDER BY p.name
OFFSET ?2
LIMIT ?3
But as yoy can see in the following the generated sql does not contain the OFFSET &
LIMIT options.
21:02:35,221 DEBUG [Category#ejbSelectActiveProducts] SQL:
SELECT t0_p.productId, t0_p.type, t0_p.manufacturer, t0_p.productLink,
t0_p.name, t0_p.description, t0_p.listPrice, t0_p.marge, t0_p.porto, t0_p.state,
t0_p.registered, t0_p.modified, t0_p.weight, t0_p.keyWords, t0_p.category_fk
FROM t_category t1_c INNER JOIN t_product t0_p ON
t1_c.categoryId=t0_p.category_fk
WHERE (t1_c.categoryId=?)
AND t0_p.state IS NOT NULL
AND t0_p.state = 'passiv'
ORDER BY t0_p.name ASC
I have also downloaded jboss-3.2.5, but the generated sql is here too missing the
OFFSET & LIMIT options.
Then I experimented with the EJBQLToSQL92Compiler setting in
(jboss-3.2.5/server/default/conf/standardjbosscmp-jdbc.xml) but that does not help
either.
What else could I try?
Has anybody managed to get this working?
Regards
Andreas
------------------------------------------------
Code snippets from the class:
* @jboss.query
* description="This generates jboss-ql and overwrites the original query from
the ejbSelectMethod"
* signature="java.util.Collection ejbSelectActiveProducts(
my.domain.catalog.interfaces.CategoryLocal category, int start, int count )"
* query="SELECT OBJECT(p) FROM Category AS c, IN (c.products) AS p WHERE c = ?1
* AND p.state IS NOT NULL
* AND p.state = 'passiv'
* ORDER BY p.name OFFSET ?2 LIMIT ?3"
* strategy="on-load"
* page-size="128"
*
* @jboss.persistence
* create-table="${jboss.create.table}"
* remove-table="${jboss.remove.table}"
*/
public abstract class CategoryEJB implements EntityBean
{
...
/**
* @ejb.select
* query="SELECT OBJECT(p) FROM Category AS c, IN (c.products) AS p WHERE c =
?1
* AND p.state IS NOT NULL
* AND p.state = 'passiv'"
*/
public abstract Collection ejbSelectActiveProducts( CategoryLocal category, int
start, int count ) throws FinderException;
------------------------------------------------
<jbosscmp-jdbc>
...
<ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.EJBQLToSQL92Compiler</ql-compiler>
....
</jbosscmp-jdbc>
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3840824#3840824
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3840824
-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
