Eclipse Community Forums: EMF » [CDO] Column name generation

Help

Home

Home » Modeling » EMF » [CDO] Column name generation

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

[CDO] Column name generation [message #431785]

Mon, 27 July 2009 06:48

Kai Schlamp

Messages: 344
Registered: July 2009

Senior Member

Hello.

When the tables are created by CDO some columns of those tables get names that end with _F612 for
example. Why is that done? To prevent name collision?
The problem is that I always have to rewrite my SQL queries when recreating the tables as those
_FXXX names always change.

Regards,
Kai

Report message to a moderator

Re: [CDO] Column name generation [message #431786 is a reply to message #431785]

Mon, 27 July 2009 07:08

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Kai,

IIRC. this is done to prevent name collision after truncation of the
column names. Can't you use the new columnName annotation to work around
this?

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Kai Schlamp schrieb:
> Hello.
>
> When the tables are created by CDO some columns of those tables get
> names that end with _F612 for example. Why is that done? To prevent
> name collision?
> The problem is that I always have to rewrite my SQL queries when
> recreating the tables as those _FXXX names always change.
>
> Regards,
> Kai

Cheers
/Eike

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

Report message to a moderator

Re: [CDO] Column name generation [message #431787 is a reply to message #431786]

Mon, 27 July 2009 07:17

Kai Schlamp

Messages: 344
Registered: July 2009

Senior Member

Sure that this annotation is already supported? Did Stefan or you implement that? I didn't.

Eike Stepper wrote:
> Kai,
>
> IIRC. this is done to prevent name collision after truncation of the
> column names. Can't you use the new columnName annotation to work around
> this?
>
> Cheers
> /Eike
>
> ----
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>
> Kai Schlamp schrieb:
>> Hello.
>>
>> When the tables are created by CDO some columns of those tables get
>> names that end with _F612 for example. Why is that done? To prevent
>> name collision?
>> The problem is that I always have to rewrite my SQL queries when
>> recreating the tables as those _FXXX names always change.
>>
>> Regards,
>> Kai

Report message to a moderator

Re: [CDO] Column name generation [message #431788 is a reply to message #431787]

Mon, 27 July 2009 07:21

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Kai Schlamp schrieb:
> Sure that this annotation is already supported? Did Stefan or you
> implement that? I didn't.
Oh, I thought it is:

282976: [DB] Influence Mappings through EAnnotations
https://bugs.eclipse.org/bugs/show_bug.cgi?id=282976

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper

>
> Eike Stepper wrote:
>> Kai,
>>
>> IIRC. this is done to prevent name collision after truncation of the
>> column names. Can't you use the new columnName annotation to work around
>> this?
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>
>> Kai Schlamp schrieb:
>>> Hello.
>>>
>>> When the tables are created by CDO some columns of those tables get
>>> names that end with _F612 for example. Why is that done? To prevent
>>> name collision?
>>> The problem is that I always have to rewrite my SQL queries when
>>> recreating the tables as those _FXXX names always change.
>>>
>>> Regards,
>>> Kai

Cheers
/Eike

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

Report message to a moderator

Re: [CDO] Column name generation [message #431789 is a reply to message #431787]

Mon, 27 July 2009 07:22

Kai Schlamp

Messages: 344
Registered: July 2009

Senior Member

Where should we document those annotations?
http://wiki.eclipse.org/CDO
or
http://www.eclipse.org/cdo/documentation/manual_20.php

I guess the Wiki. But what about this new Documentation site?
Wouldn't it be better to just link to the Wiki. At the moment everything is there.

Kai Schlamp wrote:
> Sure that this annotation is already supported? Did Stefan or you
> implement that? I didn't.
>
> Eike Stepper wrote:
>> Kai,
>>
>> IIRC. this is done to prevent name collision after truncation of the
>> column names. Can't you use the new columnName annotation to work around
>> this?
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>
>> Kai Schlamp schrieb:
>>> Hello.
>>>
>>> When the tables are created by CDO some columns of those tables get
>>> names that end with _F612 for example. Why is that done? To prevent
>>> name collision?
>>> The problem is that I always have to rewrite my SQL queries when
>>> recreating the tables as those _FXXX names always change.
>>>
>>> Regards,
>>> Kai

Report message to a moderator

Re: [CDO] Column name generation [message #431790 is a reply to message #431788]

Mon, 27 July 2009 07:24

Kai Schlamp

Messages: 344
Registered: July 2009

Senior Member

No columnName annotation so far. At least I didn't implement it. But let's see ... maybe I have some
time left this week. Shouldn't be too time consuming.

Eike Stepper wrote:
> Kai Schlamp schrieb:
>> Sure that this annotation is already supported? Did Stefan or you
>> implement that? I didn't.
> Oh, I thought it is:
>
> 282976: [DB] Influence Mappings through EAnnotations
> https://bugs.eclipse.org/bugs/show_bug.cgi?id=282976
>
> Cheers
> /Eike
>
> ----
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>> Eike Stepper wrote:
>>> Kai,
>>>
>>> IIRC. this is done to prevent name collision after truncation of the
>>> column names. Can't you use the new columnName annotation to work around
>>> this?
>>>
>>> Cheers
>>> /Eike
>>>
>>> ----
>>> http://thegordian.blogspot.com
>>> http://twitter.com/eikestepper
>>>
>>>
>>>
>>> Kai Schlamp schrieb:
>>>> Hello.
>>>>
>>>> When the tables are created by CDO some columns of those tables get
>>>> names that end with _F612 for example. Why is that done? To prevent
>>>> name collision?
>>>> The problem is that I always have to rewrite my SQL queries when
>>>> recreating the tables as those _FXXX names always change.
>>>>
>>>> Regards,
>>>> Kai

Report message to a moderator

Re: [CDO] Column name generation [message #431791 is a reply to message #431790]

Mon, 27 July 2009 07:36

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Kai Schlamp schrieb:
> No columnName annotation so far. At least I didn't implement it. But
> let's see ... maybe I have some time left this week. Shouldn't be too
> time consuming.
That'd be great ;-)

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper

>
> Eike Stepper wrote:
>> Kai Schlamp schrieb:
>>> Sure that this annotation is already supported? Did Stefan or you
>>> implement that? I didn't.
>> Oh, I thought it is:
>>
>> 282976: [DB] Influence Mappings through EAnnotations
>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=282976
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>> Eike Stepper wrote:
>>>> Kai,
>>>>
>>>> IIRC. this is done to prevent name collision after truncation of the
>>>> column names. Can't you use the new columnName annotation to work
>>>> around
>>>> this?
>>>>
>>>> Cheers
>>>> /Eike
>>>>
>>>> ----
>>>> http://thegordian.blogspot.com
>>>> http://twitter.com/eikestepper
>>>>
>>>>
>>>>
>>>> Kai Schlamp schrieb:
>>>>> Hello.
>>>>>
>>>>> When the tables are created by CDO some columns of those tables get
>>>>> names that end with _F612 for example. Why is that done? To prevent
>>>>> name collision?
>>>>> The problem is that I always have to rewrite my SQL queries when
>>>>> recreating the tables as those _FXXX names always change.
>>>>>
>>>>> Regards,
>>>>> Kai

Cheers
/Eike

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

Report message to a moderator

Re: [CDO] Column name generation [message #431792 is a reply to message #431789]

Mon, 27 July 2009 07:40

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Kai Schlamp schrieb:
> Where should we document those annotations?
> http://wiki.eclipse.org/CDO
> or
> http://www.eclipse.org/cdo/documentation/manual_20.php
Preferringly here, but I don't expect you to learn DITA if you want to
contribute to the documentation. If you really want to you can send
patches. The doc sources are here:

http://dev.eclipse.org/viewcvs/index.cgi/org.eclipse.emf/org .eclipse.emf.cdo/doc/org.eclipse.emf.cdo.doc/src/?root=Model ing_Project

Since the manual is in a very early state, I suggest that you add to the
wiki and we copy later to the manual...

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper

>
> I guess the Wiki. But what about this new Documentation site?
> Wouldn't it be better to just link to the Wiki. At the moment
> everything is there.
>
> Kai Schlamp wrote:
>> Sure that this annotation is already supported? Did Stefan or you
>> implement that? I didn't.
>>
>> Eike Stepper wrote:
>>> Kai,
>>>
>>> IIRC. this is done to prevent name collision after truncation of the
>>> column names. Can't you use the new columnName annotation to work
>>> around
>>> this?
>>>
>>> Cheers
>>> /Eike
>>>
>>> ----
>>> http://thegordian.blogspot.com
>>> http://twitter.com/eikestepper
>>>
>>>
>>>
>>> Kai Schlamp schrieb:
>>>> Hello.
>>>>
>>>> When the tables are created by CDO some columns of those tables get
>>>> names that end with _F612 for example. Why is that done? To prevent
>>>> name collision?
>>>> The problem is that I always have to rewrite my SQL queries when
>>>> recreating the tables as those _FXXX names always change.
>>>>
>>>> Regards,
>>>> Kai

Cheers
/Eike

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

Report message to a moderator

Re: [CDO] Column name generation [message #431793 is a reply to message #431791]

Mon, 27 July 2009 08:07

Kai Schlamp

Messages: 344
Registered: July 2009

Senior Member

Eike Stepper wrote:
> Kai Schlamp schrieb:
>> No columnName annotation so far. At least I didn't implement it. But
>> let's see ... maybe I have some time left this week. Shouldn't be too
>> time consuming.
> That'd be great ;-)

Should we reopen 282976? Or should we create a new one?

>
> Cheers
> /Eike
>
> ----
> http://thegordian.blogspot.com
> http://twitter.com/eikestepper
>
>
>> Eike Stepper wrote:
>>> Kai Schlamp schrieb:
>>>> Sure that this annotation is already supported? Did Stefan or you
>>>> implement that? I didn't.
>>> Oh, I thought it is:
>>>
>>> 282976: [DB] Influence Mappings through EAnnotations
>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=282976
>>>
>>> Cheers
>>> /Eike
>>>
>>> ----
>>> http://thegordian.blogspot.com
>>> http://twitter.com/eikestepper
>>>
>>>
>>>> Eike Stepper wrote:
>>>>> Kai,
>>>>>
>>>>> IIRC. this is done to prevent name collision after truncation of the
>>>>> column names. Can't you use the new columnName annotation to work
>>>>> around
>>>>> this?
>>>>>
>>>>> Cheers
>>>>> /Eike
>>>>>
>>>>> ----
>>>>> http://thegordian.blogspot.com
>>>>> http://twitter.com/eikestepper
>>>>>
>>>>>
>>>>>
>>>>> Kai Schlamp schrieb:
>>>>>> Hello.
>>>>>>
>>>>>> When the tables are created by CDO some columns of those tables get
>>>>>> names that end with _F612 for example. Why is that done? To prevent
>>>>>> name collision?
>>>>>> The problem is that I always have to rewrite my SQL queries when
>>>>>> recreating the tables as those _FXXX names always change.
>>>>>>
>>>>>> Regards,
>>>>>> Kai

Report message to a moderator

Re: [CDO] Column name generation [message #431794 is a reply to message #431793]

Mon, 27 July 2009 08:16

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Kai Schlamp schrieb:
> Eike Stepper wrote:
>> Kai Schlamp schrieb:
>>> No columnName annotation so far. At least I didn't implement it. But
>>> let's see ... maybe I have some time left this week. Shouldn't be too
>>> time consuming.
>> That'd be great ;-)
>
> Should we reopen 282976? Or should we create a new one?
A new one please. We want to be more acurate with bugzilla this cycle :P

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper

>
>
>>
>> Cheers
>> /Eike
>>
>> ----
>> http://thegordian.blogspot.com
>> http://twitter.com/eikestepper
>>
>>
>>> Eike Stepper wrote:
>>>> Kai Schlamp schrieb:
>>>>> Sure that this annotation is already supported? Did Stefan or you
>>>>> implement that? I didn't.
>>>> Oh, I thought it is:
>>>>
>>>> 282976: [DB] Influence Mappings through EAnnotations
>>>> https://bugs.eclipse.org/bugs/show_bug.cgi?id=282976
>>>>
>>>> Cheers
>>>> /Eike
>>>>
>>>> ----
>>>> http://thegordian.blogspot.com
>>>> http://twitter.com/eikestepper
>>>>
>>>>
>>>>> Eike Stepper wrote:
>>>>>> Kai,
>>>>>>
>>>>>> IIRC. this is done to prevent name collision after truncation of the
>>>>>> column names. Can't you use the new columnName annotation to work
>>>>>> around
>>>>>> this?
>>>>>>
>>>>>> Cheers
>>>>>> /Eike
>>>>>>
>>>>>> ----
>>>>>> http://thegordian.blogspot.com
>>>>>> http://twitter.com/eikestepper
>>>>>>
>>>>>>
>>>>>>
>>>>>> Kai Schlamp schrieb:
>>>>>>> Hello.
>>>>>>>
>>>>>>> When the tables are created by CDO some columns of those tables get
>>>>>>> names that end with _F612 for example. Why is that done? To prevent
>>>>>>> name collision?
>>>>>>> The problem is that I always have to rewrite my SQL queries when
>>>>>>> recreating the tables as those _FXXX names always change.
>>>>>>>
>>>>>>> Regards,
>>>>>>> Kai

Cheers
/Eike

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

Report message to a moderator

Re: [CDO] Column name generation [message #431795 is a reply to message #431794]

Mon, 27 July 2009 08:45

Kai Schlamp

Messages: 344
Registered: July 2009

Senior Member

Eike Stepper wrote:
> Kai Schlamp schrieb:
>> Eike Stepper wrote:
>>> Kai Schlamp schrieb:
>>>> No columnName annotation so far. At least I didn't implement it. But
>>>> let's see ... maybe I have some time left this week. Shouldn't be too
>>>> time consuming.
>>> That'd be great ;-)
>> Should we reopen 282976? Or should we create a new one?
> A new one please. We want to be more acurate with bugzilla this cycle :P

https://bugs.eclipse.org/bugs/show_bug.cgi?id=284701

with patch and test in 1 minute.

Report message to a moderator

Previous Topic:	Default value of EAttribute typed to an Enumeration
Next Topic:	EcoreUtil.getAnnotation: multiple annotations with same source

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:47:57 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter