This appears to have been a problem with the version of torque I was using. I ended up rebuilding the TDK last night and now this all works fine. (Yes I love to bleed :P)
By the way, 2.2 is looking nice :) On Saturday 19 January 2002 04:37 pm, you wrote: > I am having a problem with torque and foreign-keys... It seems that when I > specify a foreign-key in my scheme.xml file... torque does not proerly > generate my peer classes... > > here is my scheme file...: > > <database name="Compass"> > <table name="Venue" idMethod="idbroker"> > <column name="venue_id" required="true" primaryKey="true" > type="INTEGER"/> <column name="name" required="true" size="255" > type="VARCHAR"/> <column name="contact" size="255" type="VARCHAR"/> > <column name="address1" size="255" type="VARCHAR"/> > <column name="address2" size="255" type="VARCHAR"/> > <column name="city" size="255" type="VARCHAR"/> > <column name="state" size="255" type="VARCHAR"/> > <column name="zip" size="255" type="VARCHAR"/> > <column name="phone" size="255" type="VARCHAR"/> > <column name="fax" size="255" type="VARCHAR"/> > <column name="email1" size="255" type="VARCHAR"/> > <column name="email2" size="255" type="VARCHAR"/> > <column name="web" size="255" type="VARCHAR"/> > </table> > > <table name="VenueDataDef" idMethod="idbroker"> > <column name="venueDataDef_id" required="true" primaryKey="true" > type="INTEGER"/> > <column name="name" required="true" size="255" type="VARCHAR"/> > <column name="type" required="true" size="11" type="INTEGER"/> > <column name="priority" required="true" type="TINYINT"/> > <column name="defValue" size="255" type="VARCHAR"/> > <column name="comment" size="255" type="VARCHAR"/> > <unique> > <unique-column name="name"/> > </unique> > </table> > > <table name="VenueData"> > <column name="venue_id" required="true" primaryKey="true" > type="INTEGER"/> <column name="venueDataDef_id" required="true" > type="INTEGER"/> <column name="data" required="true" type="BLOB"/> > <column name="comment" size="255" type="VARCHAR"/> > <!-- for some reason the following does not work: --> > > <foreign-key foreignTable="Venue"> > <reference local="venue_id" foreign="venue_id"/> > </foreign-key> > </table> > </database> > > > > and this is what I get trying to compile the generated peer classes: > > [javac] Compiling 9 source files to > /home/luke/resin/webapps/Compass/WEB-INF/classes > [javac] > /home/luke/resin/webapps/Compass/WEB-INF/src/java/com/digitalrhythm/Compass >/om/BaseVenuedataPeer.java:485: cannot resolve symbol > [javac] symbol : method addVenuedata > (com.digitalrhythm.Compass.om.Venuedata) > [javac] location: class com.digitalrhythm.Compass.om.Venue > [javac] temp_obj2.addVenuedata(obj1); > [javac] ^ > [javac] > /home/luke/resin/webapps/Compass/WEB-INF/src/java/com/digitalrhythm/Compass >/om/BaseVenuedataPeer.java:491: cannot resolve symbol > [javac] symbol : method initVenuedatas () > [javac] location: class com.digitalrhythm.Compass.om.Venue > [javac] obj2.initVenuedatas(); > [javac] ^ > [javac] > /home/luke/resin/webapps/Compass/WEB-INF/src/java/com/digitalrhythm/Compass >/om/BaseVenuedataPeer.java:492: cannot resolve symbol > [javac] symbol : method addVenuedata > (com.digitalrhythm.Compass.om.Venuedata) > [javac] location: class com.digitalrhythm.Compass.om.Venue > [javac] obj2.addVenuedata(obj1); > [javac] ^ > [javac] 3 errors > > etc etc > > What appears to happen is torque is just not generating the addVenueData > and initVenueDatas methods. > > If I remove the foreign key from my scheme file, the peer classes compile > just fine. > > However, I would rather like to make use of this feature.. anyone have any > idea what could be going on here? > > Thanks a bunch! > > Luke -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
