Eclipse Community Forums: EMF » [CDO] Illegal attribute names when using Mysql database backend

Help

Home

Home » Modeling » EMF » [CDO] Illegal attribute names when using Mysql database backend

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

[CDO] Illegal attribute names when using Mysql database backend [message #1764671]

Thu, 01 June 2017 10:27

Robert Schulk

Messages: 144
Registered: July 2015

Senior Member

Please consider the following example :
class A
- x [integer]
- generated [string]

This works all fine with an H2 database backend. When using Mysql though, it is not possible to commit an instance of type A.

The reason is the attribute named "generated". This is a reserved key word in Mysql and cannot be used as a column name.

Can you think of any way how to use attributes named "generated"?
Thanks for any help.

[Updated on: Thu, 01 June 2017 10:31]

Report message to a moderator

Re: [CDO] Illegal attribute names when using Mysql database backend [message #1764744 is a reply to message #1764671]

Fri, 02 June 2017 05:23

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

According to https://dev.mysql.com/doc/refman/5.7/en/keywords.html#ftn.idm140070402557504 the word "generated" became a reserved word. You can work around this restriction with a DBStore model annotation, e.g.:

    <eStructuralFeatures xsi:type="ecore:EAttribute" name="generated" eType="ecore:EDataType http://www.eclipse.org/emf/2002/Ecore#//EString">
      <eAnnotations source="http://www.eclipse.org/CDO/DBStore">
        <details key="columnName" value="generated_x"/>
      </eAnnotations>
    </eStructuralFeatures>

Cheers
/Eike

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

Report message to a moderator