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]>
