CREATE TABLE CHILD (F1 from
ROOT_TABLE VARCHAR (80), FOREIGN KEY (F1) REFERENCES ROOT_TABLE
(USR_ID) ON DELETE CASCADE);
THis will
work.
Thanks n
Regards,
=
Rambabu
Piridi.
Software
Engineer,
Wipro
Technologies,
Madhapur,
Hyderabad.
e-Mail : [EMAIL
No. iBATIS is not an Object Relational Mapper. It is not aware of relationships and therefore does not automatically delete related records.Clinton
On 8/7/06, Socheat KHAUV <[EMAIL PROTECTED]> wrote:
Do we have another way beside using trigger and ON DELETE CASCADE?this is DBMS functions,beside
Type handlers handle the translation between Java types and database types. You can customize them, but you don't need to. The advantage is that you can deal with complex or unique types not supported by default.
You seem new to iBATIS, so to begin with, you will likely not have to worry about
Do we have another way beside using trigger and ON DELETE CASCADE?this is DBMS functions,beside using DBMS Does iBatis can delete the child record auto when we delete the master record ?Nils Winkler <[EMAIL PROTECTED]> wrote: In Oracle I define this at the table level using "ON DELETE CASCADE" ont
In Oracle I define this at the table level using "ON DELETE CASCADE" on
the foreign key relationship.
On Sun, 6 Aug 2006 23:13:31 -0700 (PDT), "Socheat KHAUV"
<[EMAIL PROTECTED]> said:
> Dear iBatis user,
>
> Does iBatis support auto delete data dependency when we delete master
> record ?
> if it
Could you give some clue ?what is the advantage of TypeHandler and how to use it ?
Groups are talking. We´re listening. Check out the handy changes to Yahoo! Groups.
Dear iBatis user,Does iBatis support auto delete data dependency when we delete master record ?if it is support could tell me way to do ?thank in advance,PkayJava
Yahoo! Music Unlimited - Access over 1 million songs.
Try it free.
I agree with other, I see very little use for this annotation. For my concern, on my project, only 10% of mapping could be made like this.
I prefer SQL in XML.
For test the SQL is accessed via Uri because we can change it without recompiling and for other layer it is embedded as resource.-- Cheers,
