Hmm, I found something similar to what I want to do in Turbine's Extend User HOWTO - I'll go through that to see if I can get it to work.
Jeff ----- Original Message ----- From: "Stephen Haberman" <[EMAIL PROTECTED]> To: "'Turbine Torque Users List'" <[EMAIL PROTECTED]> Sent: Saturday, September 07, 2002 12:55 PM Subject: RE: Problems with foreign keys and Turbine tables > One of Torque's limitations, I'm fairly sure, is that you have to > TURBINE_USER in your weblog schema to refer to in via foreign keys and > what not. You can get around this by putting in a dummy TURBINE_USER > table and setting alias=true (which basically tells the om generation > code to ignore it). > > E.g.: > > <table name="TURBINE_USER" javaName="TurbineUser" alias="TurbineUser" > baseClass="org.apache.fulcrum.security.impl.db.entity.TurbineUser" > > basePeer="org.apache.fulcrum.security.impl.db.entity.TurbineUserPeer"> > <column name="USER_ID" primaryKey="true" required="true" > type="INTEGER"/> > </table> > > - Stephen > > > -----Original Message----- > > From: Jeff Linwood [mailto:[EMAIL PROTECTED]] > > Sent: Saturday, September 07, 2002 12:52 PM > > To: Turbine Torque Users List > > Subject: Problems with foreign keys and Turbine tables > > > > Hi, > > > > I'm using the version of Torque that comes with the TDK 2.1, and I'm > having > > a problem creating a foreign key reference from my classes to the > > TURBINE_USER table. It appears that the problem is my > weblog-schema.xml > > file references the TURBINE_USER defined in turbine-schema.xml, and > they are > > referenced in different places. How do I fix this? > > > > Here is my foreign key: > > <foreign-key foreignTable="TURBINE_USER"> > > <reference local="member_id" foreign="USER_ID"/> > > </foreign-key> > > > > This seems to work if I put the relevant parts of the turbine schema > in my > > schema file, but I don't want to do that. > > > > The turbine_user table does exist in MySQL, so that shouldn't be the > > problem. > > > > Thanks, > > Jeff > > > > [torque-om] > > C:\tdk\webapps\weblog\WEB-INF\src\java\report.weblog.om.generation > > [torque-om] ERROR!! Attempt to set foreign key to nonexistent table, > > TURBINE_USE > > R! > > [torque-om] java.lang.NullPointerException > > [torque-om] at > > org.apache.turbine.torque.engine.database.transform.XmlToAppD > > ata.startElement(XmlToAppData.java:237) > > [torque-om] at > > org.apache.xerces.parsers.SAXParser.startElement(SAXParser.ja > > va:1376) > > [torque-om] at > > org.apache.xerces.validators.common.XMLValidator.callStartEle > > ment(XMLValidator.java:1122) > > [torque-om] at > > org.apache.xerces.framework.XMLDocumentScanner.scanElement(XM > > LDocumentScanner.java:1858) > > [torque-om] at > > org.apache.xerces.framework.XMLDocumentScanner$ContentDispatc > > her.dispatch(XMLDocumentScanner.java:1234) > > [torque-om] at > > org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLD > > ocumentScanner.java:381) > > [torque-om] at > > org.apache.xerces.framework.XMLParser.parse(XMLParser.java:95 > > 2) > > [torque-om] at > > org.apache.turbine.torque.engine.database.transform.XmlToAppD > > ata.parseFile(XmlToAppData.java:152) > > [torque-om] at > > org.apache.turbine.torque.TorqueObjectModelTask.initControlCo > > ntext(TorqueObjectModelTask.java:148) > > [torque-om] at > > org.apache.velocity.texen.ant.TexenTask.execute(TexenTask.jav > > a) > > <<Ant stuff snipped>> > > > > > > -- > > To unsubscribe, e-mail: <mailto:turbine-torque-user- > > [EMAIL PROTECTED]> > > For additional commands, e-mail: <mailto:turbine-torque-user- > > [EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
