java - postgresql jpa earth_distance 查询

Question

感谢发帖。我想寻求您的建议，因为我尝试使用JPA/Hibernate 调用Postgresql 中的函数，但我一直收到错误消息。能否请你帮忙？谢谢。

代码如下:

String sql = “from Motot u where FUNCTION(‘earth_box’, FUNCTION(‘ll_to_earth’, :lat, :lon), :range) > FUNCTION(‘ll_to_earth’, u.g_Latitude, u.g_Longitude)”;

List resMeter2 = entityManager.createQuery(sqlMeter2, Motor.class)
.setParameter(“lat”, lat)
.setParameter(“lon”, lon)
.setParameter(“range”, radius)
.getResultList();

错误信息如下:

org.hibernate.exception.SQLGrammarException: could not extract ResultSet

Caused by: org.postgresql.util.PSQLException: ERROR: function function(unknown, double precision, double precision) does not exist
Hint: No function matches the given name and argument types. You might need to add explicit type casts.
Position: 930

非常感谢

Answer 1

您需要安装扩展，尝试在您的 sql 工具客户端中执行:

CREATE EXTENSION earthdistance SCHEMA [你的方案名称];