[OPENJPA-594] Incorrect schema separator used for Informix tables

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.1, 1.0.2
• Fix Version/s: 1.0.4, 1.1.0, 1.2.0
• Component/s: jdbc
• Assignee: Michael Dick
• Reporter: Dinkar Rao
• Created: 08/May/08 17:38
• Updated: 09/Mar/10 18:32
• Resolved: 08/May/08 23:39

Description

With Informix IDS 9.4 (or 10.0), when a schema is specified in the table annotation or in the openjpa.jdbc.schema property, a SQL for CREATE TABLE with invalid syntax is generated:

CREATE TABLE MYSCHEMA:MYTABLE (...);

The correct separator between the schema and the table is "dot".