Issue Details (XML | Word | Printable)

Key: GLASSFISH-2363
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: mf125085
Reporter: mzh777
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
glassfish

rosterGenDBSchema and orderapp tests failed at deployment for MySQL

Created: 08/Feb/07 11:24 AM   Updated: 30/Nov/10 05:52 PM   Resolved: 08/Feb/07 02:14 PM
Component/s: cmp
Affects Version/s: 9.1pe
Fix Version/s: 9.1pe_dev

Time Tracking:
Not Specified

File Attachments: 1. Zip Archive ddls.zip (1 kB) 08/Feb/07 11:35 AM - mzh777

Environment:

Operating System: All
Platform: All


Issuezilla Id: 2,363
Tags:
Participants: mf125085 and mzh777


 Description  « Hide

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.



mzh777 added a comment - 08/Feb/07 11:35 AM

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


mzh777 added a comment - 08/Feb/07 11:38 AM

MySQL 5.0.27 used in the tests.


mf125085 added a comment - 08/Feb/07 02:12 PM

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


mf125085 added a comment - 08/Feb/07 02:14 PM

target build number