[OPENJPA-2358] openjpa-maven-plugin generates wrong sql for derby

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.2.1
• Component/s: tooling
• Environment: linux (fedora 16, x86_64), oracle jdk 1.7.0_17-b02, Maven 3.0.5, derby 10.9.1.0
• Assignee: Unassigned
• Reporter: Ted Leung
• Created: 25/Mar/13 21:55
• Updated: 12/Apr/13 01:56

Description

model object fields are not defaulting to allow null, even when I explicity set @Column(nullable=true), it still generates the columns as "not null".

As an example :
@Column(nullable = true, length = 128)
private String dataType;

results in generated sql of :
dataType VARCHAR(128) NOT NULL

This happens for both org.apache.derby.jdbc.ClientDriver, and org.apache.derby.jdbc.EmbeddedDriver. As a test, I changed the driver to the MySql driver and everything worked as expected so I'm fairly sure this is not a configuration / setup issue unless there's special configuration required for derby.