order is an sql reserved word in most sql implementations. Looks like you have a column named order.
I have no column named order in any of my three CMP beans, however i have <cmr-field-name>order</cmr-field-name>
as relation "one to many" between two CMP beans.
And for hypersonic it works. All three tables are created,
but with mysql or postgresql it does't.
Thank you very much David, i change cmr fild from order(
looks like it reserved word for mysql and postgres)
and now my CMP bean are working.