Eclipse Community Forums: EMF » Unable to set an attribute as primary key

Help

Home

Home » Modeling » EMF » Unable to set an attribute as primary key

Show: Today's Messages :: Show Polls :: Message Navigator

Unable to set an attribute as primary key [message #1754181]

Wed, 15 February 2017 05:57

lucky lucky

Messages: 1
Registered: February 2017

Junior Member

We are developing an application using EMF/CDO.
We are facing one issue.
We are trying to make "student_id" attribute in the Student class as primary key. For this we set the unique property
and the ID property of the attribute of Student class in the model , but we are still able to insert duplicate records.
We check at the database level. The corrosponding Student table has primary key which is cdo_id and cdo_version
but not the student_id of the table.
Please let us know how to solve the problem.
We have attached .Ecore file and the java code for running CDO server and java code for saving data .
We are using PostgreSQL 9.3.5
The CDO version is 4.5.0.

Attachment: school.ecore
(Size: 1.76KB, Downloaded 124 times)
Attachment: CDOEMFDemo.java
(Size: 1.94KB, Downloaded 81 times)
Attachment: INITCDOServer.java
(Size: 4.29KB, Downloaded 51 times)

Report message to a moderator

Re: Unable to set an attribute as primary key [message #1754284 is a reply to message #1754181]

Thu, 16 February 2017 08:11

Eike Stepper

Messages: 6583
Registered: July 2009

Senior Member

You can't change the PK with CDO.

With CDO 4.6 integration builds you can add additional indexes by specifying "http://www.eclipse.org/CDO/DBIndex" annotations in your model, but they're non-unique.

You could hook a WriteAccessHandler into your repository and validate incoming commits, see IRepository.addHandler() and IRepository.WriteAccessHandler.handleTransactionBeforeCommitting().

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator