Hi Patrick,
Can you give me some ideas and/or suggestions how to delete main object and
all related records with foreign keys? In my opinion the option Cascade ALL
is for that reason. Is it true?
Regards,
Miro.
On 12/28/07, Miroslav Nachev <[EMAIL PROTECTED]> wrote:
>
> CREATE TABLE test_table_1
> (
> test_id numeric(36) NOT NULL,
> is_deleted boolean NOT NULL DEFAULT false,
> CONSTRAINT test_table_1_pkey PRIMARY KEY (test_id)
> )
>
> CREATE TABLE test_table_2
> (
> tt2_id numeric(36) NOT NULL,
> tt1_id numeric(36) NOT NULL,
> CONSTRAINT pk_tt2 PRIMARY KEY (tt2_id),
> CONSTRAINT fk_tt2_tt1_id FOREIGN KEY (tt1_id)
> REFERENCES test_table_1 (test_id)
> )
>
> CREATE TABLE test_table_3
> (
> tt3_id numeric(36) NOT NULL,
> text_data character varying(255),
> CONSTRAINT pk_tt3 PRIMARY KEY (tt3_id),
> CONSTRAINT fk_tt3_tt1_id FOREIGN KEY (tt3_id)
> REFERENCES test_table_1 (test_id)
> )
>
>
> M.
>
>
> On 12/28/07, Miroslav Nachev <[EMAIL PROTECTED]> wrote:
> >
> > Yes. I would like when delete one record from TestTable1 all records in
> > TestTable2 and TestTable3 which refer to this record in TetTable1 to be
> > cascade deleted. In TestTable2 and TestTable3 this records refer to
> > TestTable1 as Foreign Key.
> >
> >
> > Miro.
> >
> > On 12/28/07, Patrick Linskey < [EMAIL PROTECTED]> wrote:
> > >
> > > Hi,
> > >
> > > Have you told OpenJPA about your foreign key constraints?
> > >
> > > -Patrick
> > >
> > > On Dec 28, 2007 7:15 PM, Miroslav Nachev < [EMAIL PROTECTED]> wrote:
> > > > Hi,
> > > >
> > > > I have 3 tables:
> > > > - TestTable1 (test_table_1) which is master for the rest tables
> > > > @Id
> > > > @Column(name = "test_id", nullable = false)
> > > > private BigDecimal testId;
> > > > @Column(name = "is_deleted", nullable = false)
> > > > private boolean deleted;
> > > > @OneToMany(cascade = CascadeType.ALL, fetch=FetchType.EAGER,
> > > mappedBy =
> > > > "tt1Id")
> > > > private Collection<TestTable2> testTable2Collection;
> > > > @OneToOne(cascade = CascadeType.ALL, fetch=FetchType.EAGER,
> > > mappedBy =
> > > > "testTable1")
> > > > private TestTable3 testTable3;
> > > >
> > > > - TestTable2 (test_table_2)
> > > > @Id
> > > > @Column(name = "tt2_id", nullable = false)
> > > > private BigDecimal tt2Id;
> > > > @JoinColumn(name = "tt1_id", referencedColumnName = "test_id")
> > > > @ManyToOne
> > > > private TestTable1 tt1Id;
> > > > - TestTable3 (test_table_3)
> > > > @Id
> > > > @Column(name = "tt3_id", nullable = false)
> > > > private BigDecimal tt3Id;
> > > > @Column(name = "text_data")
> > > > private String textData;
> > > > @JoinColumn(name = "tt3_id", referencedColumnName = "test_id",
> > > > insertable = false, updatable = false)
> > > > @OneToOne
> > > > private TestTable1 testTable1;
> > > >
> > > > When I try to delete some record from TestTable1 I have the
> > > following
> > > > exception:
> > > > Caused by: < openjpa-1.1.0-SNAPSHOT-r420667:606946M nonfatal general
> > > error>
> > > > org.apache.openjpa.persistence.PersistenceException: ERROR: update
> > > or delete
> > > > on table "test_table_1" violates foreign key constraint
> > > "fk_tt2_tt1_id" on
> > > > table "test_table_2"
> > > > Detail: Key (test_id)=(1198864038296) is still referenced from
> > > table
> > > > "test_table_2". {prepstmnt 25877218 DELETE FROM test_table_1 WHERE
> > > test_id =
> > > > ? [params=(BigDecimal) 1198864038296]} [code=0, state=23503]
> > > > ...
> > > >
> > > >
> > > > Where did I go wrong? Why I can not delete record from master table
> > > and all
> > > > records from referenced tables to be cascade deleted?
> > > >
> > > >
> > > > Miro.
> > > >
> > >
> > >
> > >
> > > --
> > > Patrick Linskey
> > > 202 669 5907
> > >
> >
> >
>
