What all .xml files you have in the meta-inf folder for the ejb...? If you have jbosscmp-jdbc.xml file in it, then look into it, and under tag you will find a tag <remove-table>true</remove-table>, make its value as false. If you have a jaws.xml file, in that also change this setting...
May be you don;t have either of these two files...then do the following....
1. Move to your <JBOSS_HOME>/server/<server-type>/conf folder. (here <server-type> means all, default or minimal.
2. Under this folder you will find standardjbosscmp-jdbc.xml and standardjaws.xml files.
3. standardjaws.xml will have entry as following:
make the <remove-table> tag value as false
4. standardjbosscmp-jdbc.xml will have entry as following:
In this one also change the value of <remove-table> to false...
That is it exactly. Actually I am gereating my EJB using xdoclet and the @jboss:remove-table remove="true" tag was indeed my problem. I changed this to "false", redeployed and hey presto it works.
Thanks again for a prompt and accurate response...