As I understand the reports from people who have tried the jdbc-odbc bridge, you will continue to find an endless stream of such problems until you switch to a non jdbc-odbc driver.
Thanks for the suggestion. I will try to use another driver.
But its not the problem with jdbc-odbc bridge.
The problem was with ejb-jar.xml file.
JBoss follows the pattern as below.
The cmp field which u have declared as primary key field in <primary-field> tag of ejb-jar.xml file should be the last field in the list of <cmp-fields> tags.
But i am not sure it is only for jdbc - odbc bridge or SQL server 7.0....
Now my application is able to call all the finders and get methods.....