Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Modeling » EMF » [CDO] Column name generation
[CDO] Column name generation [message #431785] Mon, 27 July 2009 06:48 Go to next message
Kai Schlamp is currently offline Kai SchlampFriend
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
Re: [CDO] Column name generation [message #431786 is a reply to message #431785] Mon, 27 July 2009 07:08 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6457
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


Re: [CDO] Column name generation [message #431787 is a reply to message #431786] Mon, 27 July 2009 07:17 Go to previous messageGo to next message
Kai Schlamp is currently offline Kai SchlampFriend
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
Re: [CDO] Column name generation [message #431788 is a reply to message #431787] Mon, 27 July 2009 07:21 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6457
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


Re: [CDO] Column name generation [message #431789 is a reply to message #431787] Mon, 27 July 2009 07:22 Go to previous messageGo to next message
Kai Schlamp is currently offline Kai SchlampFriend
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
Re: [CDO] Column name generation [message #431790 is a reply to message #431788] Mon, 27 July 2009 07:24 Go to previous messageGo to next message
Kai Schlamp is currently offline Kai SchlampFriend
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
Re: [CDO] Column name generation [message #431791 is a reply to message #431790] Mon, 27 July 2009 07:36 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6457
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


Re: [CDO] Column name generation [message #431792 is a reply to message #431789] Mon, 27 July 2009 07:40 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6457
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


Re: [CDO] Column name generation [message #431793 is a reply to message #431791] Mon, 27 July 2009 08:07 Go to previous messageGo to next message
Kai Schlamp is currently offline Kai SchlampFriend
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
Re: [CDO] Column name generation [message #431794 is a reply to message #431793] Mon, 27 July 2009 08:16 Go to previous messageGo to next message
Eike Stepper is currently offline Eike StepperFriend
Messages: 6457
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


Re: [CDO] Column name generation [message #431795 is a reply to message #431794] Mon, 27 July 2009 08:45 Go to previous message
Kai Schlamp is currently offline Kai SchlampFriend
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.
Previous Topic:Default value of EAttribute typed to an Enumeration
Next Topic:EcoreUtil.getAnnotation: multiple annotations with same source
Goto Forum:
  


Current Time: Mon Dec 09 03:29:10 GMT 2019

Powered by FUDForum. Page generated in 0.02159 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top