Trouble with a simple query method

[msowka]

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:
...
<abstract-schema-name>Order</abstract-schema-name>
... <cmp-field>s ...
< query> (without the space here it doesn't show up on the forum :) haha)
<query-method>
<method-name>ejbHomeOrderCount</method-name>
<method-params></method-params>
</query-method>
<ejb-ql>SELECT COUNT(o) FROM Order o</ejb-ql>
< /query>

BUT!...
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,
Mike

[msowka]

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_ (11.2.7.3):
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

[msowka]

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!

[msowka]

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.