Looks pretty clear to me, there's something wrong in the generated create table statement. Probably the sum of lengths of keys in some table you are asking to be auto-generated is more than 500.
explicitly specify sql types for the pk fields so their sum is small enough
use something reasonable like a single long for a pk.
In any case, turn on more logging until you see the generated sql statement, then it will become clear what is wrong.
I am using ejbutils-1.2beta to generate the primary key of the bean, it must be a string, any idea about how to map the sql type to avoid this problem? Furthermore, how to turn on more logging? Is it the parameter "debug" in the jbosscmp-jdbc.xml will turn on more logging?
Thank you for your reply to my question.