CMP EJB QL returns no results

[tabuchan]

Hi,

I am trying to query a database using a custom EJB QL finder method. There are no compilation or deployment errors with this method, but it returns no records. I know for certain that there are records in the table that should match the parameters I am giving the method.

The ejb-jar.xml is:
<abstract-schema-name>EmployeeMySQL</abstract-schema-name>

......


<query-method>
<method-name>findByDepartmentAndTitle</method-name>
<method-params>
<method-param>java.lang.String</method-param>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>

<ejb-ql>SELECT OBJECT(e) FROM EmployeeMySQL AS e WHERE e.Department = ?1 AND e.Title = ?2</ejb-ql>



I have this method returning a Collection in my home interface.

Collection collection = home.findByDepartmentAndTitle("Finance","Mr");

Can anyone please tell me where I am going wrong? I just don't understand why I am getting an empty Collection instance once this method has been called.

TABuchan

[dsundstrom]

This type of query works. Check your server.log.

[tabuchan]

I checked the log and it stated that it could not find a related CMP field for that finder method. It turned out that I had to declare the query in the jaws.xml file in a clause.

For example,

...

findByDepartmentAndTitle
Department LIKE "%"{0}"%" AND Title LIKE "%"{1}"%"
Department

...

TABuchan

[dsundstrom]

You are using the wrong metadata file. JBossCMP is a completely new engine, and uses a file called jbosscmp-jdbc.xml. You can buy the JBossCMP docs or read the dtd to determine how to create the correct xml.

[nick]

Where can one find the jbosscmp-jdbc dtd ?