glassfish
  1. glassfish
  2. GLASSFISH-2363

rosterGenDBSchema and orderapp tests failed at deployment for MySQL

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 9.1pe
    • Fix Version/s: 9.1pe_dev
    • Component/s: cmp
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: All

    • Issuezilla Id:
      2,363

      Description

      Build 33a.

      The rosterGenDBSchema and orderapp tests failed during deployment stage with
      following errors:
      CLI171 Command deploy failed : Deploying application in domain failed; Fatal
      Error from EJB Compiler – JDO74025: JDOCodeGenerator: Caught an Exception
      validating CMP bean 'TeamEJB' in application 'RosterAppGenDBSchema'
      module 'team-ejb': JDO72335: If the table TEAM for the bean corresponding to
      the generated class team.TeamBean_489274079_JDOState is mapped as the primary
      table, it must have a primary key.
      Choose a different primary table or verify that the contents of the schema file
      are correct.

        Activity

        Hide
        mzh777 added a comment -

        Created an attachment (id=724)
        The MySQL DDLs used in the 2 tests.

        Show
        mzh777 added a comment - Created an attachment (id=724) The MySQL DDLs used in the 2 tests.
        Hide
        mzh777 added a comment -

        MySQL 5.0.27 used in the tests.

        Show
        mzh777 added a comment - MySQL 5.0.27 used in the tests.
        Hide
        mf125085 added a comment -

        Both tests use auto-capture-schema to capture the database
        schema. Schemas generated on mysql don't contain primary key information if the
        DDL has foreign key constraints. Removing foreign key constraints from table
        definitions.

        Checking in schemas/cmp/orderapp_mysql.sql;
        /m/jws/cmp-test/schemas/cmp/orderapp_mysql.sql,v <-- orderapp_mysql.sql
        new revision: 1.2; previous revision: 1.1
        done
        Checking in schemas/cmp/RosterApp_mysql.sql;
        /m/jws/cmp-test/schemas/cmp/RosterApp_mysql.sql,v <-- RosterApp_mysql.sql
        new revision: 1.2; previous revision: 1.1
        done

        Show
        mf125085 added a comment - Both tests use auto-capture-schema to capture the database schema. Schemas generated on mysql don't contain primary key information if the DDL has foreign key constraints. Removing foreign key constraints from table definitions. Checking in schemas/cmp/orderapp_mysql.sql; /m/jws/cmp-test/schemas/cmp/orderapp_mysql.sql,v <-- orderapp_mysql.sql new revision: 1.2; previous revision: 1.1 done Checking in schemas/cmp/RosterApp_mysql.sql; /m/jws/cmp-test/schemas/cmp/RosterApp_mysql.sql,v <-- RosterApp_mysql.sql new revision: 1.2; previous revision: 1.1 done
        Hide
        mf125085 added a comment -

        target build number

        Show
        mf125085 added a comment - target build number

          People

          • Assignee:
            mf125085
            Reporter:
            mzh777
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: