Hibernate One To Many Not Null

[Cristian Daniel Ortiz Cuellar]

hi guys i am learning hibernate. can somebody give me a hand.

i am trying to implement one to many. relationship unidirectional.
i have the following structure on my database.
laboratorios could have 1..N lineas

CREATE TABLE laboratorios
(
  codigolaboratorio character varying(15) NOT NULL,
  nombrelaboratorio character varying(40) NOT NULL,
  _login character varying(5) NOT NULL,
  clave character varying(5) NOT NULL,
  fechaclave date NOT NULL DEFAULT ('now'::text)::date,
  CONSTRAINT "Primary Key Is CodigoII" PRIMARY KEY (codigolaboratorio)
)
CREATE TABLE linea
(
  id character varying(15) NOT NULL,
  descriptionlinea character varying(80) NOT NULL,
  codigolaboratorioii character varying(15),
  CONSTRAINT "Primary Key On Linea" PRIMARY KEY (id),
  CONSTRAINT IE FOREIGN KEY (codigolaboratorioii)
      REFERENCES laboratorios (codigolaboratorio) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE NO ACTION
)

Java Code Laboratorios

@Entity
@Table(name="laboratorios")
public class Laboratorios implements java.io.Serializable
{
    @Id
    @Column(name="codigolaboratorio",nullable=false,updatable=false,length=15)
    private String Id;
    @Column(name="nombrelaboratorio",nullable=false,updatable=false,length=40)
    private String Nombre;
    @Column(name="_login",nullable=false,updatable=false,length=5)
    private String Login;
    @Column(name="clave",nullable=false,updatable=false,length=5)
    private String Password;
    @Column(name="fechaclave",nullable=false,updatable=false,length=20)
    private java.sql.Date FechaClave;
    @OneToMany(cascade=CascadeType.ALL)
    @JoinColumn(name="codigolaboratorioii")
    private Set<Lineas> Lineas;
    public Set<Lineas> getLineas(){return Lineas;}
    public void setLineas(Set<Lineas> Lineas){this.Lineas = Lineas;}    
    public Date getFechaClave(){return FechaClave;}
    public void setFechaClave(Date FechaClave){this.FechaClave = FechaClave;}

Java Code Lineas

@Entity
@Table(name = "linea")
public class Lineas implements java.io.Serializable
{
    @Id
    @Column(name="id",nullable=false,updatable=true,length=15)
    private String Id;
    @Column(name="descriptionlinea",nullable=false,updatable=true,length=80)
    private String Description;
    public Lineas(){}
    public Lineas(String Id, String Description){this.Id = Id; this.Description = Description;}

It works OK. only when in detail table(Linea) linea.codigolaboratorioii line null. (allows NULLS).

if i put linea.codigolaboratorioii as not null. gives me the next error. el valor null para la columna «codigolaboratorioii» viola la restricción not null
the value for the column codigolaboratorioii violate constraint not null.

is wrong put a foreing key as not null???

in others words codigolaboratorioii character varying(15) IS OK.
in others words codigolaboratorioii character varying(15) not null, the value for the column codigolaboratorioii violate constraint not null. .

thanks a lot

[Wouter Oet]

Moved to the ORM forum.

[Cristian Daniel Ortiz Cuellar]

Wouter Oet wrote:Moved to the ORM forum.

i post a self explaining video at megaupload http://www.megaupload.com/?d=W0UZK5UL just 1.37 Mb. please watch it.

thanks a lot

[Wouter Oet]

Please don't use videos. Just describe your problem.