UML to DB Diagram Transformation: Error with primary key in MySQL
Hi,
I am new in JDeveloper and I am following an Oracle tutorial to transform an UML class Diagram into a DB diagram http://docs.oracle.com/cd/E18941_01/tutorials/jdtut_11r2_81/jdtut_11r2_81_2.html.
My idea is to create a real DB form this DB diagram.
I am now trying to transform a simple UML class into a DB class. I want to use a MYSql transformation and I want to define my self primary key, so I done the following steps:
- Create a UML class diagram
- Create a class "Person" with an attribute "ID:String"
- Define a Database profile
- Define a stereotype in my primary key attribute where:
+ I have checked box "Is Primary Key?"
+ I set in property "Data Type MySql Database Server) to "Varchar(20) NOT NULL"
Now when I try to do the transfromation:
- I set option "UML to Offline Database Objects"
- I create a new Offline DB which emulates a "MySQL Dataserver 5.x"
- When I click "Finish" I become a popup error which says: "*Invalid name PERSON_PK. Must use `PRIMARY`for MYSQL Primary Key*"
I don't really now how to solve this problem...I have tried all I have read and google but nothing works...I think I am forgotting something basic but I do not know what!
I am working with JDeveloper 11.1.2.1.0 and with MySql Server 5.5.
Thanks in advance!