[OPENJPA-2411] Support Postgres casts for non-standard types such as inet, cidr, macaddr, etc.

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.2.2
• Component/s: jdbc
• Labels: postgres
• Environment: postgres 9.0
• Patch Info: Patch Available
• Assignee: Unassigned
• Reporter: Eric Fenderbosch
• Created: 17/Jul/13 19:45
• Updated: 17/Jul/13 19:45

Description

For non-standard types (inet, cidr, macaddr) you can cast to a known Postgres type with a double colon and the type.

Example:

insert into click (ip) values ('127.0.0.1'::inet)

When creating a prepared statement the placeholder marker should be '?::' instead of '?'.

This can be fixed by overriding DBDictionary.getMarkerForInsertUpdate (patch attached) and annotating the field with the non-standard type. Like this:

@Column(columnDefinition = "inet")