hi pete solved the problem after trying my code:
you should always start the schema definition with <?xml version="1.0" encoding="ISO-8859-1" standalone="no"?> <!DOCTYPE database SYSTEM "http://jakarta.apache.org/turbine/dtd/database.dtd";> so the schema gets checked for errors. in my case the error was that foreign key definitions have to be after the column definitions in the table element. bye fabian On Thu, 2002-01-24 at 22:47, Fabian Moerchen wrote: > i had a default method of native for the database tag all the time. > still i tried many different combinations of defaultIdMethod and > idMethod now but all produced the same, correct (?) SQL for the > relation: > > CREATE TABLE ARTIST_HAS_WEBSITE > ( > ARTIST_ID INTEGER NOT NULL, > WEBSITE_ID INTEGER NOT NULL, > PRIMARY KEY(ARTIST_ID,WEBSITE_ID), > FOREIGN KEY (ARTIST_ID) REFERENCES ARTIST (ID), > FOREIGN KEY (WEBSITE_ID) REFERENCES WEBSITE (ID) > ); > > and e.g. for the websites > > CREATE TABLE WEBSITE > ( > ID INTEGER NOT NULL AUTO_INCREMENT, > NAME VARCHAR (100) NOT NULL, > URL VARCHAR (200) NOT NULL, > PRIMARY KEY(ID) > ); > > still artist1.getPrimaryKey() give me always null after saving and the > other problems described also persist. > > bye > fabian > > On Thu, 2002-01-24 at 17:49, John McNally wrote: > > I notice you are not specifying an idmethod attribute on your tables, > > are you specifying a default. I suspect not as then you would probably > > have the attribute on your ARTIST_HAS_WEBSITE table. > > > > Use idmethod="native" or idmethod="autoincrement", if native does not > > work, on tables that have generated pk's. And then use idmethod="none" > > on tables such as ARTIST_HAS_WEBSITE. > > > > john mcnally > > > > Fabian Moerchen wrote: > > > > > > 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]> > > > > -- > > 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]>
