As far as I know "order" is a reserved keyword in SQL for relational databases. This could be causing a problem with underlying db for JBoss.
I try it using Oracle oc4j in the same table,it will be ok.
So is it a bug or issue in JBoss ? (I using jboss 4.x)
this is a reserved word, your table is deplyed as xorder.
You may find a list of the reserved words in standardjbosscmp-jdbc.xml,
try to remove order
thank Claire,I got it....But...our legacy system can't change table name...we will try to create alias table name ...thank you.