JPA implementation that fully support with PostgreSQL data types?

Question

Is there any JPA implementation that supports PostgreSQL hstore, geolocation and array data types ?

Most of them are extensible; I doubt any have support out of the box. I had enough trouble with even simpler types like json and xml in EclipseLink and Hibernate. — Craig Ringer
– Craig Ringer, Commented Jul 8, 2013 at 12:34
eclipselink 2.4 currently support @Array but neither with hstore or geolocation — Agung Prasetyo
– Agung Prasetyo, Commented Jul 8, 2013 at 12:42

joragupra · Accepted Answer · 2013-12-20 16:40:32Z

2

DataNucleus has a spatial plugin that includes Postgresql spatial types (but it goes way beyond it). It doesn't explicitly do Postgresql array types but it is readily extensible, so you could write your own plugin for any missing type.

edited Dec 20, 2013 at 16:40

joragupra

6921 gold badge12 silver badges23 bronze badges

answered Jul 8, 2013 at 12:40

DataNucleus

15.6k3 gold badges34 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

willome · Accepted Answer · 2013-07-08 12:35:55Z

1

You have got Hibernate spatial which is a generic extension to Hibernate for handling geographic data

answered Jul 8, 2013 at 12:35

willome

3,16221 silver badges32 bronze badges

3 Comments

Agung Prasetyo Over a year ago

the project is outdated, i've no luck with this

Abhendra Singh Over a year ago

@kav1nsky I think you have missed tutorials and other things about it. It is very nice enhancement for Hibernate for PostgreSQL/PostGIS. I am currently working with this. And it is working very perfectly.

willome Over a year ago

I do not know what is outdated too. This project is still active : "We are currently working on migrating Hibernate Spatial to a module of the Hibernate ORM project. The move will be complete by the time of the Hibernate 5 release. The Hibernate Spatial Release 4 will be therefore be the last release that is made independently of Hibernate." That is not an easy task to migrate for full jdbc/sql to JPA and I do not think you will find a better lib for your needs.

Agung Prasetyo · Accepted Answer · 2013-12-24 04:21:32Z

0

update :

This time i have made a few converters for geo point and array (limitied to array string and long) datatype, please check https://github.com/brain64bit/myeclipselink_converter

answered Dec 24, 2013 at 4:21

Agung Prasetyo

4,4836 gold badges31 silver badges37 bronze badges

Collectives™ on Stack Overflow

JPA implementation that fully support with PostgreSQL data types?

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related