I've got it working now, thanks. I'm wondering why are the XML tags case senstive, it cases so much hassle - looking through the mailing lists archive.
I didn't think XML (as standard) was case sensitive? --- stewart titan <[EMAIL PROTECTED]> wrote: > Tried that, doesn't work, below is the *-schema.xml > > I've tried changing defaultIdMethod to IdMethod. > (I'm using Torque 3 standalone) > > Thanks. > > <database > name="bookstore" > defaultIdMethod="idbroker"> > > <table name="book" description="Book Table"> > <column > name="book_id" > required="true" > primaryKey="true" > type="INTEGER" > javaName="Id" > description="Book Id"/> > <column > name="title" > required="true" > type="VARCHAR" > size="255" > description="Book Title"/> > <column > name="isbn" > required="true" > type="VARCHAR" > size="24" > javaName="ISBN" > description="ISBN Number"/> > <column > name="publisher_id" > required="true" > type="INTEGER" > description="Foreign Key Publisher"/> > <column > name="author_id" > required="true" > type="INTEGER" > description="Foreign Key Author"/> > <foreign-key foreignTable="publisher"> > <reference > local="publisher_id" > foreign="publisher_id"/> > </foreign-key> > <foreign-key foreignTable="author"> > <reference > local="author_id" > foreign="author_id"/> > </foreign-key> > </table> > <table name="publisher" description="Publisher > Table"> > <column > name="publisher_id" > required="true" > primaryKey="true" > type="INTEGER" > javaName="Id" > description="Publisher Id"/> > <column > name="name" > required="true" > type="VARCHAR" > size="128" > description="Publisher Name"/> > </table> > <table name="author" description="Author Table"> > <column > name="author_id" > required="true" > primaryKey="true" > type="INTEGER" > javaName="Id" > description="Author Id"/> > <column > name="first_name" > required="true" > type="VARCHAR" > size="128" > description="First Name"/> > <column > name="middle_name" > type="VARCHAR" > size="128" > description="Middle Name"/> > <column > name="last_name" > required="true" > type="VARCHAR" > size="128" > description="Last Name"/> > </table> > </database> > --- Jacob Vennervald Madsen <[EMAIL PROTECTED]> > wrote: > In the /<your_webapp>/WEB-INF/conf > directory > you > > have a > > turbine-schema.xml file and a > > <your_webapp>-schema.xml file. > > Make sure that idMethod is set to idbroker for all > > tables. > > > > Jacob Vennervald Madsen > > > > -----Original Message----- > > From: stewart titan > > [mailto:[EMAIL PROTECTED]] > > Sent: 25. januar 2002 13:06 > > To: Turbine Users List > > Subject: PostGres and sequences. > > > > > > Hi > > > > I've gone through the tutorial -> copied it > exactly. > > > > I'm using Postgres and having trouble with it > > generating sequences for the primarykeys, in that > it > > doesn't seem to. > > > > When its inserting the publisher record, it throws > a > > exception with the message: > > > > ExecAppend: Fail to add null value in not null > > attribute publisher_id > > > > I presume its done automatically? > > > > I've seen previously a load of messages on the > > mailing > > list archives - but i can't find them now... > > > > Thanks for any help > > > > Stewart > > > > __________________________________________________ > > Do You Yahoo!? > > Everything you'll ever need on one web page > > from News and Sport to Email and Music Charts > > http://uk.my.yahoo.com > > > > -- > > 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]> > > > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
