Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UML to DB Diagram Transformation: Error with primary key in MySQL

916708Feb 10 2012
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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2012
Added on Feb 10 2012
0 comments
179 views