Order is a reserved word. Choose something different.
Thank you very much for your reply.
As you said because of the order keyword it causes the problems.
in my application order is an entity bean.
but for the finder methods like
@ejb.finder signature = "java.util.Collection findByConsigneeDate(java.lang.String consigneeRef,java.util.Date orderDate)"
* query = "SELECT OBJECT(o) FROM Order o WHERE o.consigneeReference = ?1 AND o.orderDate = ?2"
the mentioned error is not coming. It deploys successfully.
the major problem is i can not change name of that bean.
could you pls make some suggesstions.
You have change the abstract schema name to something else. The queries are compiled at deploy time (except for dynamic ones). So how does that deploy successfully?
i am using xdoclet to generate ejb.jar and jboss.jar.
i have define finder methods without using like as follows.
@ejb.finder signature = "java.util.Collection findByOrderStatus(java.lang.String orderStatus)"
* query = "SELECT OBJECT(o) FROM Order o WHERE o.workflowStatus = ?1"
it is working ok. when deploying it doesn't throw any exceptions.
since i want to implement the wildcard search i have used like keyword and implement the query as i mentioned.
then i got that error for order bean.
but as u said when define find methods with like for country bean it works ok.
so i have n't change the abstract shema.
pls help me
i forget to add one thing. i get this error only when i use jboss.query with Like.
if i use ejb finder without jboss.query not getting this error.
is there anyway i could use order as bean jndi name and use above queries.
you reply is very much appriciated.
Is ORDERING so may cause problem?
<jboss-ql><![CDATA[SELECT OBJECT(aa) FROM AccountAnal aa WHERE aa.account.id = ?1 order by aa.ordering]]></jboss-ql>
and error - generated query has starnge "table-name" after from
SELECT t0_aa.id, t0_aa.ordering
FROM TABLE-NAME = "ACCOUNTANAL" t0_aa,
WHERE (t1_aa_account.id = ? AND
ORDER BY t0_aa.ordering ASC
Version JBoss 3.2.5