Error: Member holding type details required

[bzimmerman]

I'm using Roo 1.1.3.RELEASE [rev 4404ffb] on Ubuntu with Java 1.6.0_21_x64 connecting to an Oracle DB.

Trying to run database reverse engineer --schema ... --testAutomatically yields the following output:

roo> database reverse engineer --schema <schema> --testAutomatically
Created SRC_MAIN_RESOURCES/dbre.xml
Undo manage SRC_MAIN_RESOURCES/META-INF/persistence.xml
Undo manage ROOT/pom.xml
Undo create SRC_MAIN_RESOURCES/dbre.xml
Member holding type details required
roo> Created SRC_MAIN_JAVA/ar/GomezFact_Roo_Entity.aj
Created SRC_MAIN_JAVA/ar/GomezFactPK_Roo_Identifier.aj
Deleted SRC_MAIN_JAVA/ar/GomezFact_Roo_Entity.aj
Deleted SRC_MAIN_JAVA/ar/GomezFactPK_Roo_Identifier.aj

Not sure what the problem here is. Running the introspect yields what looks to be pretty standard, though I'm a total newbie when it comes to Roo. Help please?

roo> database introspect --schema <schema>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!--WARNING: DO NOT EDIT THIS FILE. THIS FILE IS MANAGED BY SPRING ROO.--><!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_3.dtd">

<database name="NEW_ODS">
<option key="testAutomatically" value="false"/>
<option key="includeNonPortableAttributes" value="true"/>
<table name="GOMEZ_FACT">
<column name="GOMEZ_ISP_ID" primaryKey="false" required="true" scale="0" size="22" type="3,NUMBER"/>
<column name="GOMEZ_VARIABLE_ID" primaryKey="false" required="true" scale="0" size="22" type="3,NUMBER"/>
<column name="FACT_TS" primaryKey="false" required="true" scale="6" size="11" type="93,TIMESTAMP(6)"/>
<column name="VALUE" primaryKey="false" required="true" scale="0" size="22" type="3,NUMBER"/>
<foreign-key foreignTable="GOMEZ_ISP_DIM" name="FK_GOMEZ_FACT_VAR" onDelete="restrict" onUpdate="cascade">
<option key="exported" value="false"/>
<reference foreign="GOMEZ_ISP_ID" local="GOMEZ_ISP_ID"/>
</foreign-key>
<foreign-key foreignTable="GOMEZ_VARIABLE_DIM" name="FK_GOMEZ_FACT_ISP" onDelete="restrict" onUpdate="cascade">
<option key="exported" value="false"/>
<reference foreign="GOMEZ_VARIABLE_ID" local="GOMEZ_VARIABLE_ID"/>
</foreign-key>
</table>
<table name="GOMEZ_ISP_DIM">
<column name="GOMEZ_ISP_ID" primaryKey="true" required="true" scale="0" size="22" type="3,NUMBER"/>
<column name="NAME" primaryKey="false" required="true" scale="0" size="255" type="12,VARCHAR2"/>
<column name="LOCATION" primaryKey="false" required="false" scale="0" size="255" type="12,VARCHAR2"/>
<foreign-key foreignTable="GOMEZ_FACT" name="FK_GOMEZ_FACT_VAR" onDelete="restrict" onUpdate="cascade">
<option key="exported" value="true"/>
<reference foreign="GOMEZ_ISP_ID" local="GOMEZ_ISP_ID"/>
</foreign-key>
<unique name="PK_GOMEZ_ISP">
<unique-column name="GOMEZ_ISP_ID"/>
</unique>
</table>
<table name="GOMEZ_VARIABLE_DIM">
<column name="GOMEZ_VARIABLE_ID" primaryKey="true" required="true" scale="0" size="22" type="3,NUMBER"/>
<column name="NAME" primaryKey="false" required="true" scale="0" size="255" type="12,VARCHAR2"/>
<foreign-key foreignTable="GOMEZ_FACT" name="FK_GOMEZ_FACT_ISP" onDelete="restrict" onUpdate="cascade">
<option key="exported" value="true"/>
<reference foreign="GOMEZ_VARIABLE_ID" local="GOMEZ_VARIABLE_ID"/>
</foreign-key>
<unique name="PK_GOMEZ_VARIABLE">
<unique-column name="GOMEZ_VARIABLE_ID"/>
</unique>
</table>
</database>

[bzimmerman]

Restarting STS and re-running the same command but without "--testAutomatically" yields the below error:

roo> database reverse engineer --schema NEW_ODS
Created SRC_MAIN_RESOURCES/dbre.xml
Created SRC_MAIN_JAVA/ar/GomezFactPK.java
Created SRC_MAIN_JAVA/ar/GomezFact.java
Created SRC_MAIN_JAVA/ar/GomezIspDim.java
Created SRC_MAIN_JAVA/ar/GomezVariableDim.java
Undo create SRC_MAIN_JAVA/ar/GomezVariableDim.java
Undo create SRC_MAIN_JAVA/ar/GomezIspDim.java
Undo create SRC_MAIN_JAVA/ar/GomezFact.java
Undo create SRC_MAIN_JAVA/ar/GomezFactPK.java
Undo manage SRC_MAIN_RESOURCES/META-INF/persistence.xml
Undo manage ROOT/pom.xml
Undo create SRC_MAIN_RESOURCES/dbre.xml
Type for table 'GOMEZ_VARIABLE_DIM' could not be found but was referenced by table 'GOMEZ_FACT'
roo> Created SRC_MAIN_JAVA/ar/GomezFact_Roo_Entity.aj
Created SRC_MAIN_JAVA/ar/GomezFactPK_Roo_Identifier.aj
Deleted SRC_MAIN_JAVA/ar/GomezFact_Roo_Entity.aj
Deleted SRC_MAIN_JAVA/ar/GomezFactPK_Roo_Identifier.aj

[Alan Stewart]

Attach the xml file by running database introspect --schema <schema> --file <file name>

[bzimmerman]

XML attached, same as in OP.

[Alan Stewart]

I can't reproduce the error however I don't have your schema DDL in a standalone Roo shell, I just allowed Roo to create the entities directly from the dbre.xml file using 1.1.3.RELEASE and 1.1.4.BUILD-SNAPSHOT.

I had to create the tests using test intregration --entity com.foo.empty.GomezFact etc. Still no errors.

If you want to attach your Oracle schema DDL can use the same steps in STS to attempt to re-create the issue.

Please log a Jira ticket for this an attach the schema there.
Thanks

[bzimmerman]

Posted
https://jira.springsource.org/browse/ROO-2382