here's (part of) my schema. did i do something wrong?
could very well be since it's my first. ;)
<table name="GENRE">
<column name="ID" type="INTEGER" required="true"
autoIncrement="true" primaryKey="true"/>
<column name="NAME" type="VARCHAR" size="50" required="true"/>
<unique>
<unique-column name="NAME"/>
</unique>
</table>
<table name="ARTIST">
<column name="ID" type="INTEGER" required="true"
autoIncrement="true" primaryKey="true"/>
<column name="NAME" type="VARCHAR" size="100" required="true"/>
<column name="PATTERN" type="VARCHAR" size="255"/>
<column name="SORTNAME" type="VARCHAR" size="255"/>
<column name="GENRE_ID" type="INTEGER"/>
<foreign-key foreignTable="GENRE">
<reference local="GENRE_ID" foreign="ID"/>
</foreign-key>
</table>
<table name="WEBSITE">
<column name="ID" type="INTEGER" required="true"
autoIncrement="true" primaryKey="true"/>
<column name="NAME" type="VARCHAR" size="100" required="true"/>
<column name="URL" type="VARCHAR" size="200" required="true"/>
</table>
<table name="ARTIST_HAS_WEBSITE">
<column name="ARTIST_ID" type="INTEGER" required="true"
primaryKey="true"/>
<foreign-key foreignTable="ARTIST">
<reference local="ARTIST_ID" foreign="ID"/>
</foreign-key>
<column name="WEBSITE_ID" type="INTEGER" required="true"
primaryKey="true"/>
<foreign-key foreignTable="WEBSITE">
<reference local="WEBSITE_ID" foreign="ID"/>
</foreign-key>
</table>
bye
fabian
On Thu, 2002-01-24 at 07:28, John McNally wrote:
> The first example should work. You might want to show your schema.xml,
> to give others some idea what might be wrong. artist1.getPrimaryKey()
> should give the id assigned after saving the object. It should not be
> null. If it is something is wrong with your xml.
>
> john mcnally
>
> >
> > this doesn't work:
> >
> > Artist artist1 = new Artist();
> > artist1.setName("Primus");
> > artist1.save();
> >
> > Website website1 = new Website();
> > website1.setName("Primus Online");
> > website1.setUrl("http://www.primussucks.com";);
> > website1.save();
> >
> > ArtistHasWebsite link = new ArtistHasWebsite();
> > link.setArtist(artist1);
> > link.setWebsite(website1);
> > link.save(); //Column 'ARTIST_ID' cannot be null
> >
> > this does work:
> >
> > Artist artist1 = new Artist();
> > artist1.setName("Primus");
> > artist1.save();
> >
> > Website website1 = new Website();
> > website1.setName("Primus Online");
> > website1.setUrl("http://www.primussucks.com";);
> > website1.save();
> >
> > Artist artist2 = ArtistFactory.findByName(artist1.getName());
> > Website website2 = WebsiteFactory.findByUrl(website1.getUrl());
> >
> > ArtistHasWebsite link = new ArtistHasWebsite();
> > link.setArtist(artist2);
> > link.setWebsite(website2);
> > link.save();
> >
> > tried defaultIdMethod native and idBroker by now.
> >
> > bye
> > fabian
> >
> > --
> > 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]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
