duplicated table columns

1 view
Skip to first unread message

Jin Lei

unread,
Apr 27, 2009, 4:36:09 PM4/27/09
to Reactor
This is weird: for a specific table, when I was using reactor, it
generated duplicated declarations for the same column(field) in the
metadata.cfc. Below is the generated code for table Institution with a
column named 'INST_NO', and you'll find there are 11 'INST_NO'
declarations altogether:


<cfcomponent hint="I am the base Metadata object for the institut
object. I am generated. DO NOT EDIT ME (but feel free to delete
me)."
extends="reactor.base.abstractMetadata" >

<cfset variables.signature = "DB3E44B8AC95E63778062A37D3F0C8AC" >

<cfset variables.metadata.name = "INSTITUT" />
<cfset variables.metadata.alias = "institut" />
<cfset variables.metadata.type = "table" />
<cfset variables.metadata.database = "" />

<!--- Has One --->
<cfset variables.metadata.hasOne = ArrayNew(1) />


<!--- Has Many --->
<cfset variables.metadata.hasMany = ArrayNew(1) />


<!--- Fields --->
<cfset variables.metadata.fields = ArrayNew(1) />

<cfset variables.metadata.fields[1] = StructNew() />
<cfset variables.metadata.fields[1]["name"] = "INST_NO" />
<cfset variables.metadata.fields[1]["alias"] = "INST_NO" />
<cfset variables.metadata.fields[1]["primaryKey"] = "true" />
<cfset variables.metadata.fields[1]["identity"] = "false" />
<cfset variables.metadata.fields[1]["nullable"] = "false" />
<cfset variables.metadata.fields[1]["dbDataType"] = "NUMBER" />
<cfset variables.metadata.fields[1]["cfDataType"] = "numeric" />
<cfset variables.metadata.fields[1]["cfSqlType"] = "cf_sql_numeric" /
>
<cfset variables.metadata.fields[1]["length"] = "11" />
<cfset variables.metadata.fields[1]["scale"] = "0" />
<cfset variables.metadata.fields[1]["default"] = "0" />
<cfset variables.metadata.fields[1]["object"] = "INSTITUT" />
<cfset variables.metadata.fields[1]["sequence"] = "" />
<cfset variables.metadata.fields[1]["readOnly"] = "false" />
<!--- Start to repeat here --->
<cfset variables.metadata.fields[2] = StructNew() />
<cfset variables.metadata.fields[2]["name"] = "INST_NO" />
<cfset variables.metadata.fields[2]["alias"] = "INST_NO" />
<cfset variables.metadata.fields[2]["primaryKey"] = "true" />
<cfset variables.metadata.fields[2]["identity"] = "false" />
<cfset variables.metadata.fields[2]["nullable"] = "false" />
<cfset variables.metadata.fields[2]["dbDataType"] = "NUMBER" />
<cfset variables.metadata.fields[2]["cfDataType"] = "numeric" />
<cfset variables.metadata.fields[2]["cfSqlType"] = "cf_sql_numeric" /
>
<cfset variables.metadata.fields[2]["length"] = "11" />
<cfset variables.metadata.fields[2]["scale"] = "0" />
<cfset variables.metadata.fields[2]["default"] = "0" />
<cfset variables.metadata.fields[2]["object"] = "INSTITUT" />
<cfset variables.metadata.fields[2]["sequence"] = "" />
<cfset variables.metadata.fields[2]["readOnly"] = "false" />

....

I'm using Oracle 9i. The strange thing is, for most other tables, it
works fine. Any ideas?
Reply all
Reply to author
Forward
0 new messages