Hi
Here is an example if the SQL being generated by JBoss 3.0.7. As you can see we don't have a finder with a definition that could match the SQL generated for this bean!!!!
@ejb:bean name="SlamRoleFunctArea" type="CMP" jndi-name="ejb/SlamRoleFunctArea"
* @ejb:finder signature="Collection findAll()" unchecked="true" transaction-type="Required"
* @ejb:finder signature="Collection findByRoleId(int roleId)" unchecked="true" transaction-type="Required"
* @ejb:finder signature="Collection findByFunctAreaId(int functAreaId)" unchecked="true" transaction-type="Required"
* @ejb:create-method
SELECT SLAM_ROLE_ID, SLAM_FUNCT_AREA_ID,ACCESS_GRANTED_FLAG FROM APP_SLAM_ROLE_FUNCT_AREA WHERE (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) OR (SLAM_ROLE_ID=? AND SLAM_FUNCT_AREA_ID=?) FOR UPDATE