openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abe White <awh...@bea.com>
Subject Re: [jira] Commented: (OPENJPA-235) SQL reordering to avoid non-nullable foreign key constraint violations
Date Thu, 21 Jun 2007 15:29:16 GMT
> Is that a hint to set openjpa.jdbc.SchemaFactory=native 
> (ForeignKeys=true)?

No.  I'm saying that if these secret tests rely on OpenJPA to detect  
foreign keys based on the above setting, then it's likely that the  
problem is in OpenJPA's ability to detect the existing foreign keys  
rather than in OpenJPA's constraint analyses and SQL ordering.  For  
example, I know in some versions of MySQL the standard  
DatabaseMetaData.getExportedKeys call didn't work unless the keys  
were created with ALTER TABLE statements rather than in the CREATE  
TABLE statement.

Notice:  This email message, together with any attachments, may contain information  of  BEA
Systems,  Inc.,  its subsidiaries  and  affiliated entities,  that may be confidential,  proprietary,
 copyrighted  and/or legally privileged, and is intended solely for the use of the individual
or entity named in this message. If you are not the intended recipient, and have received
this message in error, please immediately return this by email and then delete it.

Mime
View raw message