cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Antonio Gallardo" <agalla...@agsoftware.dnsalias.com>
Subject Re: mod-db postgresql and autoincrement
Date Fri, 21 Feb 2003 20:30:47 GMT
Hi Amelie:

Sorry for the delay. I was not clear what was you problem.... :-(

1-The pointed by Christian is correct, in cocoon.xconf check you have:


<autoincrement-modules>
  <component-instance
    logger="core.modules.auto"
    name="auto"      
class="org.apache.cocoon.components.modules.database.PgsqlAutoIncrementModule"/>
</autoincrement-modules>

2-IN order to make use of this module, you must to create on the database
SEQUENCES like this....

-- Autonumerico de usuarios
CREATE SEQUENCE usuarios_usr_id_seq
  start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;

Please check that the name of the SEQUENCE must be:

tableName_fielName_seq

To follow the example. The table usuarios is create by the following SQL
code:

*************************************
CREATE TABLE Usuarios
  (
    usr_id       int4            unique not null default
nextval('usuarios_usr_id_seq'),
    loc_id       int4            not null,
    usr_nombre   varchar(20)     unique not null,
    usr_nombre_completo varchar(50)    ,
    usr_password varchar(20)    ,
    usr_habilitado int4            not null default 1,

    primary key(usr_id),

    foreign key(loc_id) references Localidades(loc_id) on update CASCADE,

    CHECK(usr_habilitado BETWEEN 0 AND 1)
  );

CREATE INDEX UsuariosNDX1 ON Usuarios(loc_id);

***********************************

I hope it will help you. :-D

Best Regards,

Antonio Gallardo



Amélie Cordier dijo:
> Hello everybody
>
> I'm trying to run mod-db example (the one with users and groups) using
> PostgreSQL.
>
> Currently, everything work perfectly except the autoincrement attribute.
>
> The error I have is this one :
>
>  ---
> |org.apache.cocoon.components.modules.output.OutputModule:  ="ERROR:
> parser: parse error at or near "call" "
>  ---
>
> I read in the mailing list archive a lot of interesting things but I had
> not found any clue to solve my problem.
>
> Is there anybody who can help me?
>
> Regards,
>
> Amélie Cordier
>
>
> ------------------
> My configuration :
>
> OS: Debian 3.0
> Tomcat 4.1.10
> Cocoon 2.1-dev (latest CVS HEAD version)
> JDK 1.4
>
>
>
>
>
>
>
>
>
> --------------------------------------------------------------------- To
> unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
> For additional commands, e-mail: cocoon-users-help@xml.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org


Mime
View raw message