Eclipse Community Forums: EclipseLink » Postgis Eclipselink JPA

Home » Eclipse Projects » EclipseLink » Postgis Eclipselink JPA(Postgres Postgis Eclipselink JPA support)

Postgis Eclipselink JPA [message #636934]

Wed, 03 November 2010 08:36

Eclipse User

Hi,

We currently have a JPA setup using eclipselink persisting out entities in a postgres database. We use JPA to create the schema as well as persisting everything.

What we would like to do is introduce some spatial data into the database and use the database to perform queries on this.

I have installed and followed some simple examples of Postgis and determined that it could support the queries we want however I have fallen down at trying to integrate it with our JPA setup.

Seraching the web there appears to be almost no indication that this could work apart from a few message board posts a considerable amount of time ago.

I have followed the suggestions I've found, using a postgis driver, using postgis and vividsolutions data types and supplying a @Converter however these seem to have little impact on the resulting schema. The field type is either bytea or if a converter is supplied varchar.

Can anybody clarify whether this is supported so I can look at something else or identify where I might be going wrong.

Many thanks,

Dan.

[Updated on: Wed, 03 November 2010 09:58] by Moderator

Re: Postgis Eclipselink JPA [message #637195 is a reply to message #636934]

Thu, 04 November 2010 10:45

Eclipse User

If you want to use spatial datatype you will need to set the type in your @Column "columnDefinition" attribute.

Re: Postgis Eclipselink JPA [message #637214 is a reply to message #637195]

Thu, 04 November 2010 11:45

Eclipse User

Hi James,

thanks for the reply. Following your suggestion I have added an annotation on the field of

@Column( columnDefinition="geometry" )

this appears to produce the correct SQL to create the table.

The problem I seem to have now is that the database JPA is creating is not spatially enabled in that the functions that exist in the test database I created while installing postgis do not exist in the JPA database. As a result type 'geometry' is not recognised during the creation process and an exception is thrown.

If you have any ideas on what else I could be missing please let me know.

Many thanks,
Dan.

Previous Topic:	EclipseLink 2.0 ManyToOne not working correctly
Next Topic:	Get exception when calling getIdClassAttributes in child class

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 25 22:21:31 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter