0 Replies Latest reply on May 30, 2003 5:54 AM by Tristan

    Incorrect generated SQL

    Tristan Newbie

      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