RE: Can't add entry in RDF (Postgres and Turbine/torque)

["Wellie W. Chao" <wc...@yahoo.com>]

I finally figured out the autoincrement issue with the RDF table, but it was
a pretty aggravating couple of hours. Here is my newapp-schema.xml file:

<database>
  <table name="RDF" idMethod="idbroker">
    <column name="RDF_ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
    <column name="TITLE" size="255" type="VARCHAR"/>
    <column name="BODY" size="255" type="VARCHAR"/>
    <column name="URL" size="255" type="VARCHAR"/>
    <column name="AUTHOR" size="255" type="VARCHAR"/>
    <column name="DEPT" size="255" type="VARCHAR"/>
  </table>
</database>

Note the idMethod="idbroker". I believe case matters. I made a bunch of
changes and had to undo a bunch, so I'm not sure if that was the only change
(apart from modifications to the db.props file to fix the "adding user"
issue). I think that was the only change though.

-----Original Message-----
List:     turbine-user
Subject:  Can't add entry in RDF (Postgres and Turbine/torque)
From:     bib <bi...@database59.ch>
Date:     2002-02-18 16:22:35

Der all,
As a newbe using Turbine 2.1, I've made the changes into
tdk/share/conf/torque/templates/sql/base/postgresql/db.props
accordingly messages of Colm and Daniel.
Furthermore, i have updated the postgresql.jar to the v7.2
binary located at http://jdbc.postgresql.org.

Now, the "adding user" issue is resolved, but turbine
returns an error when trying to add records in 'RDF' table

In my little understanding of the engine, RDF_ID
should be considered as "serial" i.e: AUTOINCREMENT insteed
of INTEGER, furthermore idMethod of the table should be set
to 'native' in order to use sequence capabilitie of postgres.

So, I've made those changes in 'newapp-schema.xml', trying to set
RDF_ID's type to "AUTOINCREMENT". Unfortunatly, I couldn't get
the 'newapp' being initialized correctly (Build Faillure).
I've then play arround with the table property idMethod="native"
without more success.

Would someone be nice enough in helping me to achieve setup ?

Many thanks in advance for your tips.
Kindest regards
Bertrand Habib


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>