0 Replies Latest reply on Apr 15, 2003 9:10 AM by g_premanand

    Record is not Selected using CMP

    g_premanand Newbie

      I am Using Jboss-3.0.6 and Oracle 8. In the Jaws.xml using a finder method i am trying to select a record. (Record is avilable in the DB). when i used any wrong name for the Column in the Query tag is giving proper error but for the correct condition record is not fetched from the DB. Can any one help me. my jaws.xml is


      java:/oaDatasource
      <type-mapping>Oracle8</type-mapping>
      true



      <table-name>t_mefd_folder</table-name>
      <ejb-name>FolderEntityBean</ejb-name>

      <cmp-field>
      <field-name>folderId</field-name>
      <column-name>FOLDER_ID</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>folderName</field-name>
      <column-name>FOLDER_NAME</column-name>
      </cmp-field>

      <cmp-field>
      <field-name>msgAge</field-name>
      <column-name>MESSAGE_AGE</column-name>
      </cmp-field>
      <cmp-field>
      <field-name>deleteTag</field-name>
      <column-name>DELETE_TAG</column-name>
      </cmp-field>



      findByDeleteTag
      ((folder_id is Not Null) and (delete_tag = 0))




      </enterprise-beans>