JBoss seems to be creating its own database tables, so it is never finding the real tables? Can this be possible? I have a table called UIRole, which I've populated with test data. Then when JBoss starts it seems to create and use a different table called UIRoleTable... Really? Very confusing. So of course it doesnt' find any of the data in the real table... why does it create its own table? I would expect that it would just throw an exception if it can't find the right one, instead of creating a different one? Can this "behavior" be turned off? If so how?
In jbosscmp-jdbc.xml there is a tag "create-table" which indicates whether tables should be created or not. However, this only creates the table if it does not exist.
The problem is that in your deployment descriptors, the table name is wrong (does not match the real table name).