4 Replies Latest reply on Jun 29, 2005 9:13 PM by proaben

    Is "Order" a keyword in JBOSS AP Server ?

    proaben

      hi,dear all:

      I have a "Order" table in mysql db server.
      When I create a entity bean mapping the "order" table ,it will build and deploy ok.
      But when I using the entity bean to findbyprimarykey() or create() to search or insert a record,it will be fail,and show "xorder is not found".
      So I want to know :is "order" a keyword ? how can I fix it ? It is the same that in informix db server. Help me.....thank you.

        • 1. Re: Is
          clairecostello

          Hi,

          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.

          ?

          -Claire

          • 2. Re: Is
            proaben

            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)
            thank you.

            • 3. Re: Is
              fbiaggi

              Hi,
              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

              • 4. Re: Is
                proaben

                thank Claire,I got it....But...our legacy system can't change table name...we will try to create alias table name ...thank you.