Hi, Adding:
<property name="openjpa.jdbc.MappingDefaults" value="ForeignKeyDeleteAction=restrict, JoinForeignKeyDeleteAction=restrict" /> Does indeed solve problem 1. Thank you. Any ideas/suggestions on how to get the generated SQL with the constraint expressed in the CREATE table statement and not as a separate ALTER statement? -- View this message in context: http://openjpa.208410.n2.nabble.com/Generating-SQL-including-Foreign-Key-constraints-OpenJpa-1-2-2-tp6055639p6057861.html Sent from the OpenJPA Users mailing list archive at Nabble.com.