You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by stewart titan <st...@yahoo.co.uk> on 2002/01/25 14:15:06 UTC
Case Sensitivity RE: PostGres and sequences
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 <st...@yahoo.co.uk> 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 <jv...@gopinocchio.com>
> 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:stewart_titan@yahoo.co.uk]
> > 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:
> >
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> >
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
>
> __________________________________________________
> 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
__________________________________________________
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
Re: Case Sensitivity RE: PostGres and sequences
Posted by Daniel Rall <dl...@finemaltcoding.com>.
stewart titan <st...@yahoo.co.uk> writes:
> 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?
Spec complient XML markup is always case sensitive, and the XML data
used in Turbine is also case sensitive.
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
AW: Case Sensitivity RE: PostGres and sequences
Posted by Gunter Miessbrandt <mi...@ixtern.de>.
xml as standard is still case sensitive!!!
Gunter M.
-----Ursprüngliche Nachricht-----
Von: stewart titan [mailto:stewart_titan@yahoo.co.uk]
Gesendet: Freitag, 25. Januar 2002 14:15
An: Turbine Users List
Betreff: Case Sensitivity RE: PostGres and sequences
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 <st...@yahoo.co.uk> 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 <jv...@gopinocchio.com>
> 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:stewart_titan@yahoo.co.uk]
> > 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:
> >
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
> >
> > --
> > To unsubscribe, e-mail:
> >
> <ma...@jakarta.apache.org>
> > For additional commands, e-mail:
> > <ma...@jakarta.apache.org>
> >
>
> __________________________________________________
> 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
__________________________________________________
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:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>