db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sez Sez <sezmillen...@yahoo.es>
Subject Torque and IdGenerator error
Date Tue, 09 Mar 2004 12:07:47 GMT
Hi!
I am working with jetspeed. It work with torque.
Moreover i work with Postgresql 7.4. 
This is  my db-schema.xml. 

<database name="Intranet" defaultIdMethod="native">
   <table name="TURBINE_USER" idMethod="native" >
    <column name="USER_ID" required="true"
primaryKey="true" autoIncrement="true"
type="INTEGER"/>
    <column name="LOGIN_NAME" required="true"
size="32" type="VARCHAR"/>
   
...

    <unique>
        <unique-column name="LOGIN_NAME"/>
    </unique>        
    <id-method-parameter name="seqName"
value="TURBINE_USER_USER_ID_SEQ"/>
  </table>

Torque 3.0.2 generates this sql:

DROP TABLE TURBINE_USER;
DROP SEQUENCE TURBINE_USER_USER_ID_SEQ;

CREATE SEQUENCE TURBINE_USER_USER_ID_SEQ;

CREATE TABLE TURBINE_USER
(
                            USER_ID serial,
                            LOGIN_NAME varchar (32)
NOT NULL,

...

    PRIMARY KEY (USER_ID),
    CONSTRAINT TURBINE_USER_U_1 UNIQUE (LOGIN_NAME)
);

And i have this error:
IdGenerator for table 'TURBINE_USER' is null

I read about this error and the cause is that my
postgresql don't generate de user_id.
But, i work with psql command line and i can introduce
the information and autogenerate the userid. Moreover,
with PostgreSQL access i can see de
turbine_user_user_id_seq that increase.

Moreover, i read some pieces of code to find where
userid is generated and i didn't found...

What is the problem????


___________________________________________________
Yahoo! Messenger - Nueva versión GRATIS
Super Webcam, voz, caritas animadas, y más...
http://messenger.yahoo.es

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message