Turn on DEBUG for org.jboss.ejb.plugins.cmp
then look in log/server.log to see the generated queries.
My guess is key is a reserved word in mysql
or it could be the lower/upper case confusion.
It is best to keep everything uppercase for portability.
Are you usiing XDoclet? If so, check your ejb.ejb.persistent-field and @ejb.persistence column tags make sure they preceed the correct abastract accessor methods. If not, please post your descriptors.
actually the problem was that sql generated by jboss worked well with hypersonic and not with mysql
i tried this sql with mysql cli and it turned out that a table column cannot be named 'key'
so the problem was that i should have get some experience with the database i am using and not 100% rely on jboss sql :)