A quick look shows table names in mixed case and the fk's defined in all caps.
john mcnally "Pelluru, Prabhakara" wrote: > > Hi , > > When I try to create new tables in TDK 2.1 I get these following > errors when i run "ant init". > can anybody help me . > > <table name="SSI_Product" idMethod="idbroker"> > <column name="PRODUCT_ID" required="true" primaryKey="true" size="25" > type="VARCHAR"/> > <column name="PRODUCT_NAME" size="6" type="VARCHAR"/> > <column name="PRODUCT_DESCRIPTION" size="100" type="VARCHAR"/> > </table> > > <table name="SSI_Test" idMethod="idbroker"> > <column name="TEST_ID" required="true" primaryKey="true" size="25" > type="VARCHAR"/> > <column name="TEST_NAME" size="6" type="VARCHAR"/> > <column name="TEST_DESCRIPTION" size="100" type="VARCHAR"/> > </table> > > <table name="SSI_PRODUCT_TEST"> > <column name="PRODUCT_ID" required="true" primaryKey="true" > type="INTEGER"/> > <column name="TEST_ID" required="true" primaryKey="true" > type="INTEGER"/> > > <foreign-key foreignTable="SSI_PRODUCT"> > <reference local="PRODUCT_ID" foreign="PRODUCT_ID"/> > </foreign-key> > > <foreign-key foreignTable="SSI_TEST"> > <reference local="TEST_ID" foreign="TEST_ID"/> > </foreign-key> > </table> > regards > > project-om: > [echo] +------------------------------------------+ > [echo] | | > [echo] | Generating Peer-based Object Model for | > [echo] | YOUR Turbine project! Woo hoo! | > [echo] | | > [echo] +------------------------------------------+ > [torque-om] D:\tdk\webapps\aiee\WEB-INF\src\java\report.aiee.om.generation > [torque-om] ERROR!! Attempt to set foreign key to nonexistent table, > SSI_PRODUCT! > [torque-om] java.lang.NullPointerException > [torque-om] at > org.apache.turbine.torque.engine.database.transform.XmlToAppData.startElemen > t(XmlToAppData.java:237) > [torque-om] at > org.apache.xerces.parsers.SAXParser.startElement(SAXParser.java:1376) > [torque-om] at > org.apache.xerces.validators.common.XMLValidator.callStartElement(XMLValidat > or.java:1122) > [torque-om] at > org.apache.xerces.framework.XMLDocumentScanner.scanElement(XMLDocumentScanne > r.java:1858) > [torque-om] at > org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XM > LDocumentScanner.java:1234) > [torque-om] at > org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner. > java:381) > [torque-om] at > org.apache.xerces.framework.XMLParser.parse(XMLParser.java:952) > [torque-om] at > org.apache.turbine.torque.engine.database.transform.XmlToAppData.parseFile(X > mlToAppData.java:152) > [torque-om] at > org.apache.turbine.torque.TorqueObjectModelTask.initControlContext(TorqueObj > ectModelTask.java:148) > [torque-om] at > org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java) > [torque-om] at > org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:104) > [torque-om] at org.apache.tools.ant.Task.perform(Task.java:217) > [torque-om] at org.apache.tools.ant.Target.execute(Target.java:184) > [torque-om] at org.apache.tools.ant.Target.performTasks(Target.java:202) > [torque-om] at > org.apache.tools.ant.Project.executeTarget(Project.java:601) > [torque-om] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266) > [torque-om] at > org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120) > [torque-om] at org.apache.tools.ant.Task.perform(Task.java:217) > [torque-om] at org.apache.tools.ant.Target.execute(Target.java:184) > [torque-om] at org.apache.tools.ant.Target.performTasks(Target.java:202) > [torque-om] at > org.apache.tools.ant.Project.executeTarget(Project.java:601) > [torque-om] at > org.apache.tools.ant.Project.executeTargets(Project.java:560) > [torque-om] at org.apache.tools.ant.Main.runBuild(Main.java:454) > [torque-om] at org.apache.tools.ant.Main.start(Main.java:153) > [torque-om] at org.apache.tools.ant.Main.main(Main.java:176) > [torque-om] ERROR!! Attempt to set foreign key to nonexistent table, > SSI_TEST! > [torque-om] java.lang.NullPointerException > [torque-om] at > org.apache.turbine.torque.engine.database.transform.XmlToAppData.startElemen > t(XmlToAppData.java:237) > [torque-om] at > org.apache.xerces.parsers.SAXParser.startElement(SAXParser.java:1376) > [torque-om] at > org.apache.xerces.validators.common.XMLValidator.callStartElement(XMLValidat > or.java:1122) > [torque-om] at > org.apache.xerces.framework.XMLDocumentScanner.scanElement(XMLDocumentScanne > r.java:1858) > [torque-om] at > org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XM > LDocumentScanner.java:1234) > [torque-om] at > org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner. > java:381) > [torque-om] at > org.apache.xerces.framework.XMLParser.parse(XMLParser.java:952) > [torque-om] at > org.apache.turbine.torque.engine.database.transform.XmlToAppData.parseFile(X > mlToAppData.java:152) > [torque-om] at > org.apache.turbine.torque.TorqueObjectModelTask.initControlContext(TorqueObj > ectModelTask.java:148) > [torque-om] at > org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.java) > [torque-om] at > org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:104) > [torque-om] at org.apache.tools.ant.Task.perform(Task.java:217) > [torque-om] at org.apache.tools.ant.Target.execute(Target.java:184) > [torque-om] at org.apache.tools.ant.Target.performTasks(Target.java:202) > [torque-om] at > org.apache.tools.ant.Project.executeTarget(Project.java:601) > [torque-om] at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266) > [torque-om] at > org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120) > [torque-om] at org.apache.tools.ant.Task.perform(Task.java:217) > [torque-om] at org.apache.tools.ant.Target.execute(Target.java:184) > [torque-om] at org.apache.tools.ant.Target.performTasks(Target.java:202) > [torque-om] at > org.apache.tools.ant.Project.executeTarget(Project.java:601) > [torque-om] at > org.apache.tools.ant.Project.executeTargets(Project.java:560) > [torque-om] at org.apache.tools.ant.Main.runBuild(Main.java:454) > [torque-om] at org.apache.tools.ant.Main.start(Main.java:153) > [torque-om] at org.apache.tools.ant.Main.main(Main.java:176) > > BUILD FAILED > > D:\tdk\webapps\aiee\WEB-INF\build\build.xml:178: Exception thrown by > 'generator.parse'. For more information consult the velocity log. -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
