[CAY-2665] Support for widespread SQL types that falls into Jdbc type OTHER

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.2.M2
• Component/s: Core Library, Database integration, dbimport, Modeler
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 16/Jul/20 11:41
• Updated: 08/Sep/20 13:15
• Resolved: 08/Sep/20 13:15

Description

There are several commonly used DB data types that don't have special treatment in the JDBC spec. Namely it's Geometry and JSON types that are supported by the most RDBMSs.

This task is about supporting those types in the Cayenne core (as well as in the dbimport). Initially we will support Wkt, GeoJson and JSON types.

See also discussion and some early prototype in this thread.

Issue Links

• links to: Pull request #430