You should specify
<abstract-schema-name>your abstract schema name</abstract-schema-name>
I have abstract-schema-name defined. I do not include the database schema name in that. I have ejbs defined identically that map to sql server and work to perfection, which makes me think that there is something wrong with specifying the schema.tablename inside <table-name>. However, the findAll() and findXXX with no parameters work fine. Running out of ideas. Is there a way to turn on verbose ejb logging in jboss?
Check log4j.xml in the server conf directory