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 27 times)
Attachment: CDOEMFDemo.java
(Size: 1.94KB, Downloaded 34 times)
Attachment: INITCDOServer.java
(Size: 4.29KB, Downloaded 25 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: 6376
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().

Report message to a moderator

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

Thu, 16 February 2017 08:12

Eike Stepper

Messages: 6376
Registered: July 2009

Senior Member

Please prefix your CDO-specific questions with [CDO] to make sure you get prompt replies.

Report message to a moderator

Previous Topic:	Effect of the load options?
Next Topic:	Load an ecore file programmatically

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 20 14:53:04 GMT 2018

.:: Contact :: Home ::.