finder definition in jaws.xml

[alpha.d]

I am using JBoss-2.4.3.
My CMP bean works well except the finder which has a table-join query.
I'm not sure whether I wrote the jaws.xml correctly.

Could anybody help me?

Thanks in advance!


-----------------------------------------------------------------------------------------------
public interface ProjectHome extends EJBHome {
...
public Collection findUserProjects (int userID)
throws RemoteException, FinderException;
...
}


jaws.xml


findUserProjects
, project_member WHERE project_member.project = projectID AND project_member.app_user={0}

<read-ahead>true</read-ahead>


tables in DB:

create table project (
project_id NUMBER(6) not null,
name VARCHAR2(30) not null,
note VARCHAR2(500),
)

create table project_member (
project NUMBER(6) not null,
app_user NUMBER(6) not null,
)

[alpha.d]

I changed the field name to table name. It worked.

, project_member WHERE project_member.project = project.project_id AND project_member.app_user={0}