From: Dyego Souza Dantas Leal <dyego.leal_at_gmail.com>
Date: Tue, 27 Jun 2006 15:49:13 -0300

Here is the sample problem:


The Database Script is :



create table people ( pe_id Integer(4) auto_increment, pe_nome
varchar(255),PRIMARY KEY(pe_id)) type = InnoDB;
create table addressPeople ( ap_id Integer(4) auto_increment unique,
ap_pe_id Integer(4), ap_address varchar(255),
PRIMARY KEY(ap_id), FOREIGN KEY (`ap_pe_id`) REFERENCES `people`
(`pe_id`) ON DELETE CASCADE ON UPDATE NO ACTION) type = InnoDB;



The Project with a sample of problems is attached.

The database is MySQL 5.0 ( with no special config )
The Connector/J (JDBC) is 3.1.x version

-- 
-------------------------------------------------------------------------
++  Dyego Souza Dantas Leal   ++           Dep. Desenvolvimento   -------------------------------------------------------------------------
               E S C R I B A   I N F O R M A T I C A
        ***        http://javacoffe.blogspot.com        ***
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--                                        ICQ   : 1647350
$ look into "my eyes"                     Phone : +55 041 2106-1212    
look: cannot open my eyes                 Fax   : +55 041 3296-6640     -------------------------------------------------------------------------
             Reply: dyego_at_escriba.com.br