3 Replies Latest reply: Apr 6, 2005 6:24 PM by Mike Sowka RSS

Trouble with a simple query method

Mike Sowka Newbie

Hello Folks,

I'm trying to implement a simple query method in a small EJB component of the "Petstore" app.

#1 I've got an 'public abstract int ejbHomeOrderCount()' in my OrderEJB.java

#2 I've got an 'int orderCount()' in my OrderLocalHome.java

#3 I've stuck the following into my ejb-jar.xml:
... <cmp-field>s ...
< query> (without the space here it doesn't show up on the forum :) haha)
<ejb-ql>SELECT COUNT(o) FROM Order o</ejb-ql>
< /query>

JBoss (that rat! ;) ) keeps complaining in an onslaught of errors about:
org.jboss.deployment.DeploymentException: Query method not found: ejbHomeOrderCount()

ARGH!!! It's there!

Any help/suggestions are much appreciated. Thanks,

  • 1. Re: Trouble with a simple query method
    Mike Sowka Newbie

    Well, I've fiddled around with my EJB, separating the orderCount into an ejbHomeOrderCount and ejbSelectOrderCount. I assume that this is the correct (and only) way to do it in the first place.

    ... but now I've got a different error:

    org.jboss.deployment.DeploymentException: Error compiling EJB-QL statement 'SELECT COUNT(o) FROM Order o'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "Order" at line 1, column 22.

    I've seen this pop up before but it "spontaneously" dissapeared. I've looked into it, and I know my ejb-ql syntax is right as I also found it right in the EJB 2.1 _Spec_ (
    SELECT COUNT(o) FROM Order o

    If You look at my previous post You'll not that I have an abstract-schema Order defined.

    The joys of 'doing' EJBs... aaahhhh

  • 2. Re: Trouble with a simple query method
    Mike Sowka Newbie

    In continueing my monologue on this forum ;) :

    Seeing as the parser is case unsensitive, it turns out "Order" is a reserved identifier. To the best of my knowldege all things SQL related are case unsensitive... I've got a nagging want to send those EJB Spec authors a little note, that _EXACT_ query is in the spec!

  • 3. Re: Trouble with a simple query method
    Mike Sowka Newbie

    Linda DeMichiel has promptly replied to me on what I thought was an error in the spec... it turns out that it's JBoss that seems to have a bug.

    Using Order for an <abstract-schema> is ok, but not for a identifier.

    Reporting a bug.