But I think, I know why: The legacy db has no/does not support FKs. Try the given example with mysql (I'm using 5.0.15): USE test; | DROP TABLE IF EXISTS `categories`; | CREATE TABLE `categories` ( | `categories_id` int(11) NOT NULL auto_increment, | `parent_id` int(11) NOT NULL default '0', | PRIMARY KEY (`categories_id`), | KEY `idx_categories_parent_id` (`parent_id`) | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | | /*!40000 ALTER TABLE `categories` DISABLE KEYS */; | LOCK TABLES `categories` WRITE; | INSERT INTO `categories` VALUES (1,0),(4,0),(5,0),(8,0),(2,1),(3,2),(6,5),(7,6); | UNLOCK TABLES; | /*!40000 ALTER TABLE `categories` ENABLE KEYS */; | commit;
If you still want the testapp, just let me know. I've now a separate eclipse project for sharing complete "test" apps (i.e. relevant parts only, but usually working ;-)). View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3923217#3923217 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3923217 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
