Hi Tomek!
Thanks for the feedback. It's been very helpful. The way I was planning to solve the issue was to modify the methods that generate the table names. Before that, I want to make sure that the table names are not used to generate back the name of the class and property. Do you know if this is so? Maybe I should modify Oracles database gateway, so this change doesn't affect the rest of the databases... Any suggestions? TIA, Pedro. On Mar 6, 10:16 pm, Tomek Kott <[email protected]> wrote: > Hi Pedro, > > The table names are created from two locations. First is the type > definition, such as that found in /farcry/*/packages/types or > /farcry/*/packages/rules. The one that is giving you problems is > "/farcry/*/packages/rules/ruleShowWebfeed.cfc" where * is either /core/, > plugins/pluginName, or /project/. > > The base table "ruleShowWebfeed" is created from the name of the type > created. (First line or so of the *.cfc file). The secondary table, holding > the array, is created from the property name of the array. So in this case, > the name is aWebDisplayFeeds. Farcry's database layer then puts those > together into ruleShowWebfeed_aWebDisplayFeeds to create the table name. But > that layer isn't so important. > > The important thing is to keep the total "name of type" + "name of array > property" below 30 characters. If you search for aWebDisplayFeeds and > replace all such occurances (in that file and webskin files related to it) > with something shorter, that should do it. > > Hope that helps direct your search. > > Tomek > > On Fri, Mar 6, 2009 at 2:08 PM, pedrobl <[email protected]> wrote: > > > Thanks Tomek, > > > On Mar 6, 2:37 pm, Tomek Kott <[email protected]> wrote: > > > Hmm, I thought Oracle 10 got rid of those constraints. Did the error also > > > spit out the query used for the command that failed? > > > Oracle's version: > > Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit > > > :P > > > > I have an install working on Oracle 8, so I know its possible, one just > > has > > > to be careful with the names. Part of the problem is that any type (such > > as > > > dmHTML) that has an array of associated types has an extra table. So if > > > dmHTML has associated types aObjects, then there is a table created that > > is > > > dmHTML_aObjects. So you have to be careful to not let that combined > > length > > > be over 30 chars. > > > > That doesn't answer your question directly, but I know its possible to > > > install on oracle, but I can't remember now if I had to change some > > > definitions to get rid of long names. > > > > Tomek > > > I'm now trying to figure out how the table names are generated, to see > > if I can reduce their length. > > > The conflicting table name is "ruleShowWebfeed_aWebDisplayFeeds". > > > Any help is very much appreciated, thanks, > > > Pedro. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
