You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Luke Holden <al...@prodigy.net> on 2002/01/20 01:37:43 UTC
problem with torque and foreign-key
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: FIXED: problem with torque and foreign-key
Posted by Luke Holden <al...@prodigy.net>.
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>