An example on how to use Hibernate-Spatial with Spring Data JPA Repositories

ThingEntity.java

@Entity
@Table(name = "things")
public class ThingEntity {

    @Id
    private Long id;

    // Needed for use with Hibernate Spatial 4.x
    // @Type(type = "org.hibernate.spatial.GeometryType")
    private Geometry geometry;
}

ThingRepository.java

import org.springframework.data.repository.Repository;
import org.springframework.data.jpa.repository.Query;

public interface ThingRepository extends Repository<ThingEntity, Long> {
    // This is a JPQL Query. Take note how I referenced the name of the entity, it's a Spring EL variable
    // If you refactor your entity, its name will be taken care of...
    @Query(value
            = "Select t from #{#entityName} t"
            + " where intersects(t.geometry, :area) = true"
    )
    List<ThingEntity> findWithinArea(Geometry area);
}

I'm getting Caused by: org.postgresql.util.PSQLException: ERROR: function st_within(public.geometry, bytea) does not exist exception while executing:

@Query(value
            = "select t from Media t"
            + " where within(t.location, :circle) = true"
            + " order by t.captureDate desc"
    )
    List<Media> findWithinRadius(@Param("circle") Geometry circle);

A possible solution I found is to run SET search_path TO my_schema, public; on PostgreSQL but no help. Do you have any idea about this?

As stated in Repository Query Keywords on Spring Data JPA documentation, there are two of them that could be used as spatial queries: Within and Containing.

Unfortunately they're not working. What I've written and it's also working is:

public interface IMunicipioRepository extends CrudRepository<Municipio, Integer> {

	Optional<Municipio> findTopByTextoLikeOrderByTexto(String texto);
	@Query("FROM Municipio m WHERE CONTAINS(m.geom, :point) = true")
	Optional<Municipio> findMunicipioContainingPoint(Point point);
	
}

@thinkyard the issue is there is no postgis function that supports comparing a geometry and a byte array (bytea). Try casting the byte array to a geom. also double check that function exists on the database