All: First let me say I know only the most basic of Java stuff.
I am working with a Java colleague on the development of a data model (MySQL of course :-) and we seem to run into the problem an Entity Beans cannot support joins. Can anyone tell me if this is true (If so, what use are they for any sort of complex data model?). If no, can you send me some information on how to implement a join with the Beans and some possible resources to consult? My naïveté leads me to believe I should be able to create a container of beans that is the result of any query I can write against the DB. Or something like this anyway! Please help! Thanks for your time. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. www.triand.com O: (512) 248-2287 M: (713) 252-4688 -----Original Message----- From: Sudip Shekhawat [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 2:33 PM To: [EMAIL PROTECTED] Subject: Foreign Key on text field Hi, I am using MySQL 4.0.17. When I try to create a foreign key on a field of the type text, I get this error: 040609 15:02:31 Error in foreign key constraint of table db_name/tb_name: There is no index in the table db_name/tb_name where the columns appear as the first columns. Constraint: FOREIGN KEY (CEA_key) REFERENCES relation (CEA_key) ON DELETE CASCADE )TYPE=InnoDB; Can I create a foreign key on the text field?? In the parent table the parent column has a index of length 64. Thanks Sudip _________________________________________________________________ Looking to buy a house? Get informed with the Home Buying Guide from MSN House & Home. http://coldwellbanker.msn.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]