RE: PostGres and sequences.

[Jacob Vennervald Madsen]

You have to run "ant init" in the buid directory again.

Jacob

-----Original Message-----
From: stewart titan [mailto:[EMAIL PROTECTED]]
Sent: 25. januar 2002 14:03
To: Turbine Users List
Subject: RE: PostGres and sequences.


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


--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>