[OPENJPA-399] openjpa did not handle multiple schema names with same table name

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.1
• Fix Version/s: 1.0.1, 1.1.0
• Component/s: jdbc
• Environment: JDK1.5, OPENJPA verison 580425
• Assignee: Teresa Kan
• Reporter: Teresa Kan
• Created: 10/Oct/07 22:48
• Updated: 09/Mar/10 18:32
• Resolved: 13/Dec/07 15:10

Description

Two entities have the same table name but with different schema, only one table is created. In addition, when two entities use the generatedType.AUTO for ID, only one OPENJPA_SEQUENCE-TABLE is created.

The problem due to the SchemaGroup.findTable() which only looked for a table name from all the schemas. Once the table was found in one of the schema then it exited and assumed that the table existed. Same problem in the TableJDBCSeq.addSchema().

Issue Links

• is related to: OPENJPA-842 Handling of default schema