Exception: java.sql.SQLException: ORA-01400: cannot insert NULLinto ("TURBINE"."VISITOR"."VISITORID")

[Sergio Rivas]

Hello We need to autoincrement VISITORID when we inserts something in the VISITOR table and we use SEQUENCE drop sequence VISITORID_seq; create sequence VISITORID_seq start with 1; ------------------------------------- create table VISITOR (     VISITORID         number DEFAULT VISITORID_seq.nextval UNIQUE, ????????????  ERROR!!     LOGINID           varchar2 (32) NOT NULL UNIQUE,     PASSWORD_VALUE    varchar2 (32),     CONFIRM_VALUE     varchar2 (32),     FIRST_NAME        varchar2 (99) NOT NULL,     LAST_NAME         varchar2 (99) NOT NULL,     ADDRESS1          varchar2 (255), Someone knows how to do this? What about to create a trigger to  insert VISITORID_seq.nextval into VISITORID?   saludos,   Sergio Rivas   Comercio Electr�nico B2B 2.000       saludos,   Sergio Rivas   Comercio Electr�nico B2B 2.000