I have JBoss v4.0.3SP1 installed along with MySQL v5.0.22.
I am using Eclipse 3.1.2 with MyEclipse 4.1.1 for my development. I am using
XDoclet to generate the code for the EJBs.
In my application I have my CMP EJBs configured for v2.X.
In one of my EJBs I have the following finder:
| * @ejb.finder
| * query="SELECT OBJECT(t) FROM TaxMaster t WHERE t.taxNbr
>= ?1 ORDER BY t.taxNbr"
| * signature="java.util.Collection
findListByTaxNbr(java.lang.String partialKey)"
| * description="find the list of entries that start with a
specific character string"
|
When I run this the DAOImp module fails with
| javax.servlet.ServletException: Unexpected Error
| java.lang.OutOfMemoryError: Java heap space
| ; CausedByException is:
| Unexpected Error
| java.lang.OutOfMemoryError: Java heap space
|
|
Obviously JBoss is trying to read every entry in the table that satisfies the
query and load it into memory. This won't work at all.
According to the JBoss documentation I can include a LIMIT parm on the QL call.
So I changed the QL to:
| * @ejb.finder
| * query="SELECT OBJECT(t) FROM TaxMaster t WHERE t.taxNbr
>= ?1 ORDER BY t.taxNbr ASC LIMIT ?2"
| * signature="java.util.Collection
findListByTaxNbr(java.lang.String partialKey, int tLimit)"
| * description="find the list of entries that start with a
specific character string"
|
Now when I attempt to deploy the application I get the following failure:
| 10:56:42,111 INFO [BaseLocalProxyFactory] Bound EJB LocalHome 'TaxMaster'
to jndi 'TaxMasterLocal'
| 10:56:43,736 INFO [STDOUT] org.jboss.ejb.plugins.cmp.ejbql.ParseException:
Encountered "LIMIT" at line 1, column 79.
| Was expecting one of:
|
| "," ...
|
So, how do I implement the LIMIT option? I don't mind to upgrade to a more
current version if that will fix the problem. But I'd rather not go to that
touble just yet if it won't help.
I have researched this somewhat and can't find anything in the forums that
indicate that JBoss has a problem with LIMIT. So I am hoping I am just doing
something wrong.
Thanks for your interest and feedback.
Glenn Puckett
MetaMAP, Inc
Lexington, KY
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3958269#3958269
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3958269
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user