[GIS] Hibernate Spatial Maven Issue

hibernate-spatialpostgis

I'm following the tutorial at http://www.hibernatespatial.org/tutorial-hs4.html. I've created a maven project, and imported it into Eclipse. However, when I run mvn dependency:list, I get the error Missing artifact org.postgis:postgis-jdbc:jar:1.5.3. The same error is reported from within Eclipse. Any idea on what I may be doing wrong?

Best Answer

I sorted this issue by: 1. Added maven-compiler-plugin dependency

<dependency>
    <groupId>org.apache.maven.plugins</groupId>
    <artifactId>maven-compiler-plugin</artifactId>
    <version>2.5.1</version>
</dependency>

Added postgis-jdbc dependency that is available in the maven repository. As it turns out, version 1.5.3 is not available in the maven repository, and I was not in the mood to compile the jar. So, I just added:

<dependency>
    <groupId>org.postgis</groupId>
    <artifactId>postgis-jdbc</artifactId>
    <version>1.3.3</version>
</dependency>

And that sorted it out.

Related Solutions

[GIS] Hibernate Spatial MappingException for Geometry Column

The issue is the renaming of the package containing GeometryUserType class in Hibernate Spatial 4.x from

org.hibernatespatial.GeometryUserType in 1.x to org.hibernate.spatial.GeometryType in 4.x. I also changed the PostGIS JDBC driver from 1.3.3 to 1.5.2.

So, the geometry property should be defined and mapped thus:

@Type(type = "org.hibernate.spatial.GeometryType")
@Column(name = "the_geom", nullable = true)
private Geometry geom;

This sorts it out for me.

[GIS] Hibernate Spatial 4 and PostGIS 2.0

I was using Tomcat, and it's connection pooling facilities. I just exposed a datasource to my application through JNDI.

Here's what did work for me:

When I included the maven dependency for hibernate-spatial, it has a transitive dependency for hibernate itself, postgresql's jdbc and postgis's jdbc. So what I did was to remove these dependencies (outdated). My pom looks like this:

<dependency>
    <groupId>org.hibernate</groupId>
    <artifactId>hibernate-spatial</artifactId>
    <version>4.0</version>
    <exclusions>
        <exclusion>
            <artifactId>hibernate-core</artifactId>
            <groupId>org.hibernate</groupId>
        </exclusion>
        <exclusion>
            <artifactId>postgis-jdbc</artifactId>
            <groupId>org.postgis</groupId>
        </exclusion>
        <exclusion>
            <artifactId>postgresql</artifactId>
            <groupId>postgresql</groupId>
        </exclusion>
    </exclusions>
</dependency>

Postgis jdbc is the extension to postgresql jdbc that you need.

Then I cloned postgis repository and compiled their jdbc extension. Just run mvn package in the java/jdbc directory. Read its readme.
Then I placed the most recent postgresql-jdbc and the recently compiled postgis jdbc in the tomcat's lib directory
On the tomcat's server configuration, I changed the database url to jdbc:postgresql_postGIS://localhost:5432/mydatabase. Notice the postgresql_postGIS part. I also changed the driver class to org.postgis.DriverWrapper. This is a wrapper that registers postgis types with the native jdbc.

Here's my final resource configuration in tomcat:

<Resource auth="Container"
          maxActive="120" maxIdle="10" name="jdbc/myapp"
          username="myuser" password="mypassword"
          poolPreparedStatements="true" type="javax.sql.DataSource" 
          driverClassName="org.postgis.DriverWrapper"
          validatingQuery="select 1"
          url="jdbc:postgresql_postGIS://localhost:5432/myapp"/>

This procedure is generally described in the postgis jdbc's README. So make sure you read it.

Best Answer

Related Solutions

[GIS] Hibernate Spatial MappingException for Geometry Column

[GIS] Hibernate Spatial 4 and PostGIS 2.0

Related Question