2 Replies Latest reply on Jun 17, 2003 2:29 AM by jboss1604

    CMP/Jbuilder/JBoss

    jboss1604 Newbie

      i have two tables
      1.emp
      2.dept

      emp has following fields
      1.empno(pk)
      2.empname
      3.deptno(fk of from dept table)
      dept has following fields
      1.deptno(pk)
      2.deptname
      3.deptdesc

      Now i am working in the enviornment as follows
      1.AppServer : JBoss3.0.x-Tomcat4.0.x
      2.Database : Oracle 8.0.x
      3.Developement Tool : JBuilder7.0

      i wrote ejbs which used CMR field as deptno.
      while inserting record into child table it throws error
      as "dupilcate column name" but it inserted record at master.here i enabled "deleteoncascade" as true
      in jbuilder for that field.so that i need sample code using CMR field as deptno


      with regards
      vijay