Use Point type with PostgreSQL and JPA/Hibernate

INSTALL THE POSTGIS EXTENSIONS IN YOUR DATABASE.

The error you are encountering is because you have not installed anything on your database that Hibernate can relate to. It's postgres that is complaining, viz:

org.postgresql.util.PSQLException: Unknown type geometry.

Your annotations and configuration say they have a dependency on PostGIS:

<property name="hibernate.dialect"  value="org.hibernate.spatial.dialect.postgis.PostgisDialect" />

So basically you are trying to use an unsupported configuration.

PostgreSQL does not come with all of the possible data types anyone ever thought of, the way Oracle does. So when Hibernate says "I want a 'geometry' PostgreSQL just says "what's a geometry?" PostgreSQL is very extensible so that's what the PostGIS people did - they built an extension. Anyone can install it or run completely without it. The only problem it causes is when someone expects it in the out-of-the-box database rather than it being an add-on.

I suppose you might try to reverse-engineer the PostgreSQL data types and compile them in your database. Geometry is a master superclass for PostGIS, in Java at least and it looks the same in the database. I just don't see why you would set up a configuration when you won't ever get anyone to support it.

@bluish does this help?

I can offer a more universal way through @Embedded Entity (It doesn't depend on the database type!), which I've used on projects.

Example below:

Piece of SQL query for creating some table with LAT and LONG:

CREATE TABLE some_table (
  lat    NUMBER(..., ...),
  long   NUMBER(..., ...),
...
);

Embeddable Point entity:

@Embeddable
public class Point {
    private BigDecimal x;
    private BigDecimal y;
 ...
}

Your custom entity:

@Entity
@Table(name = "some_table")
public class SomeEntity {
    @Embedded
    @AttributeOverrides({
            @AttributeOverride(name = "lat", column = @Column(name = "x")),
            @AttributeOverride(name = "long", column = @Column(name = "y"))
    })
    private Point point;
...
}

As I am not entirely sure of the question, let me try paraphrasing first:

You want to map an entity having a field of type com.vividsolutions.jts.geom.Point to a PostgreSQL database column of type "point" (cf. postgreSQL geometric types) using hibernate, restricting yourself to the "standard" (i.e. hibernate provided) dialect PostgreSQLDialect.

Some research leads me to the conclusion that the above mentioned hibernate supported standard dialect does not support the PostgreSQL point type at all. So you may want to provide your own UserType. Look at Custom types from the hibernate manual or Understanding and writing Hibernate custom user types for an example from a blog.

this link will help you LINK : https://www.compose.com/articles/geofile-everything-in-the-radius-with-postgis/

Beside that, distanceWithin() function take distance in degree which you have to cast to geograph but hibernate Spatial doesn't support so there is another way by which you can achieve this by providing distance in decimal according to your requirement.link is mention below for decimal points.

for decimal convertion LINK : https://en.wikipedia.org/wiki/Decimal_degrees