A purely academic point, and simply for the sake of clarity : A table can only have one Primary Key; a Primary Key can consiste of multiple columns which I think is what is being discussed here.
Cheers, Charles. >-----Original Message----- >From: Felipe Ramos [mailto:[EMAIL PROTECTED] >Sent: 21 March 2003 10:20 >To: OJB Users List >Subject: Re: Multiple primary keys in ojb tables > > >Is very common, and sometimes is mandatory to use more than >one primary >key in a table. >This is the first DB I know in which it is not possible. > >Thomas Dudziak wrote: > >>Hi, >> >>I was playing with the tutorials and with the AutoBuildDb >stuff when I got >>a complaint from MySQL that a CREATE TABLE statement tries to define >>multiple primary columns. After some searching I found that >in the file >>src/test/org/apache/ojb/repository_internal.xml the tables >OJB_HL_SEQ and >>OJB_LOCKENTRY both define two primary keys. If I'm not >mistaken this is >>not allowed by most databases, right ? >> >>Tom >> >> >> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> > >-- >------------------------ >Felipe Ramos >Tissat SA >C/ Orense 34-9� >28020 Madrid >Tel: (+34) 91 4175913 >Fax: (+34) 91 4172914 >Mail: [EMAIL PROTECTED] >------------------------ > > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > This email and any attachments are strictly confidential and are intended solely for the addressee. If you are not the intended recipient you must not disclose, forward, copy or take any action in reliance on this message or its attachments. If you have received this email in error please notify the sender as soon as possible and delete it from your computer systems. Any views or opinions presented are solely those of the author and do not necessarily reflect those of HPD Software Limited or its affiliates. At present the integrity of email across the internet cannot be guaranteed and messages sent via this medium are potentially at risk. All liability is excluded to the extent permitted by law for any claims arising as a re- sult of the use of this medium to transmit information by or to HPD Software Limited or its affiliates. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
