Oh good grief... yer I'm trying to figure something out with this too,
but I think I'll take the manual path.
cheers.
>> So Oracle has this 30 character limit on identifiers, which is
>> often exceeded when doing SQL generation from Entity Modeler for
>> foreign key constraints.
>> Having not looked at the source, how hard would it be to truncate
>> these to a unique value <=30 chars when dealing with Oracle?
>> (Assuming you don't really care what the name looks like.)
> Funny, I was just talking to a coworker about this same thing ...
> since ... i will be using Oracle ... soon ... and I blame you for
> this. I was trying to decide if it should be done in the
> OraclePlugIn or in WOLips. I'd almost like the OraclePlugIn to do
> name mangling automagically, which would allow you to have a "pure"
> model that could move between dbs. Actually, maybe we could do it
> in Wonder during model loading ... You could set a
> [ModelName].maxColumnLength=30 and it could do name mangling.
> Ultimately, though it would probably be less "tricky" to make it
> happen in WOLips (and you wouldn't have to worry about coming up
> with a persistent mangling scheme).
___
Andrew Lindesay
www.lindesay.co.nz
This archive was generated by hypermail 2.0.0 : Thu Oct 02 2008 - 18:51:43 EDT