could not extract ResultSet; SQL [n/a];

A

anduplats

Guest
I want to retrieve nearest possible locations with this query from Postgresql but it gives me that kind of an error: "could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet",

@Query(value="SELECT * \n" +
"FROM jobs \n" +
"WHERE ST_Dwithin(geom, st_point(?1, ?2,?3);", nativeQuery = true)
List<JobEntity> findNearestJobs(@Param("longitude") String longitude, @Param("latitude") String latitude, @Param("distance") String distance);

Continue reading...
 
Top