im a new user from hibernate..

i need update in cascate..

example:

CREATE TABLE emprestimos
(
emprestimo_id int4 NOT NULL,
emprestimo_total float8 NOT NULL,
agenciafk_id int4 NOT NULL,
CONSTRAINT emprestimos_pkey PRIMARY KEY (emprestimo_id),
CONSTRAINT fkbb08884d7d90bc1 FOREIGN KEY (agenciafk_id)
REFERENCES agencias (agencia_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE
)

how i change ON UPDATE NO ACTION to CASCADE??

how i change the name of CONSTRAINT fkbb08884d7d90bc1 FOREIGN KEY (agenciafk_id).

tks for all

Hi,

I guess it depends how you configure hibernate (xml vs. annotations) and which db you are using.

Assuming you are using annotations you should look into specifying the right cascade type on your collection, eg @OneToMany(cascade = CascadeType.ALL). The name of the constraint can be changed via @ForeignKey(name = "YOUR_FK_NAME").

If you need more help you should probably post your entity and how you configure it.

--Hardy