primary and secondry table insertion

[kaviarasu]

Hi
i want to insert value for primary and secondry table through bean itself or using trigger,
can any one help


table 1
eno-primary key

table-2
eno-foreign key
address-
esino-primary key for this table


i want to write bean that table1.eno is autogenerate value that want to insert into secondry table and the same value want to assigned to table2.esino which is the primary coloumn for table 2. and wnat to inser the value for table2.address too from jsf.
is it possible through trigger or
i want to attain it through bean itself
thank you
regards
kaviarasu

[alrubinger]

If you're using Entity Beans, you can attach a Hibernate Event Listener or JPA Event Annotations (ie http://java.sun.com/javaee/5/docs/api/javax/persistence/PrePersist.html, checking that when a row is added for your "table1" bean, the logic you'd like done is performed...

This keeps your logic at the application level, rather than relying upon DB triggers (as a matter of my personal preference).

S,
ALR