I can't get a simple CMP example to work. I have purchased the CMP Docs and even the doc example doesn't work.

My simple CMP example is creating a Users table in my Microsoft SQL Server 2000 database, but then fails on trying to compile the EJB-QL. I have overriden the EJB-QL in the ejb-jar with jboss-ql. I have been working on this for days and can't get around it. I am about ready to go back to BMP's, however, I would hate to not use CMP's because it doesn't work.

I get the following stack trace in the JBoss logs when trying to deploy my jar, yet the Users table does exist and has only those two fields in it.