You've done exactly what I've been trying.. Although the javaType attribute is something I'll have to be less sloppy about.
The java you wrote is precisely what i was trying but I think I was getting a bit blinded by the elegance of the OO methods and I need to use look into the options using Peers. But if you've had this approach working then, I'd like to know.
The java is exactly what i've been trying to the letter and as i mentioned my schema is only missing the javaType attribute. Everything else to the letter.
No exceptions, not a whisper.
Cheers Mark
On Tuesday, August 12, 2003, at 08:11 PM, Eric Emminger wrote:
Mark
Let's figure this out. If I understand you correctly, then you're having a problem with something that DOES work in Torque. So, let's figure out how to make it work for YOU.
Tell me which version of Torque you're using and which database vendor and version.
Your schema xml file should have at least the following.
<database name="yourDb">
<table name="APPLICANT" javaName="Applicant" idMethod="native">
<column name="id" javaName="Id" type="INTEGER" required="true" primaryKey="true" javaType="object"/>
<column name="APPLICATION_ID" javaName="ApplicationId" type="INTEGER" javaType="object"/>
<foreign-key foreignTable="APPLICATION">
<reference local="APPLICATION_ID" foreign="APPLICATION_ID"/>
</foreign-key>
</table>
<table name="APPLICATION" javaName="Application" idMethod="native">
<column name="APPLICATION_ID" javaName="Id" type="INTEGER" required="true" primaryKey="true" javaType="object"/>
</table>
</database>
Then you should be able to do the following in Java.
Applicant a = new Applicant(); Application app = new Application(); a.save(); app.save(); a.setApplication(app); a.save();
Note that you save (insert) both the Applicant and Application first. Then, you relate the Application to the Applicant and save (update) the changed Applicant.
If you need more help, please send the relevant part of your schema xml file. For each relevant <table> and <column> element, I want to see the entire element, NOT "<column ..."
Eric
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
