Record is not Selected using CMP

[g_premanand]

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>