如何将org.postgresql.geometric.PGpoint映射到Hibernate类型

在这种情况下，您可以将类型注册为geometry

然后，定义一个类，它实现 UserType public class PointType implements UserType { private static final Type [] PROPERTY_TYPES = new Type [] { StringType.INSTANCE}; public String [] getPropertyNames（）{ return new String [] {point}; } public Type [] getPropertyTypes（）{ return PROPERTY_TYPES; } public class returnedClass（）{ return Point.class; $ b $ public boolean equals（Object o，Object o1）throws HibernateException { if（（o instanceof Point&& o1 instanceof Point）== false）返回false; Point p1 =（Point）o; Point p2 =（Point）o1; boolean equal =（（p1.getX（）== p2.getX（））&&（p1.getY（）== p2.getY（）））; 回报相等; $ b public Object nullSafeGet（ResultSet rs，String [] strings，SessionImplementor si，Object o）throws HibernateException，SQLException { //从列中获取数据并使用BinaryParser将其转换为Point的方法 BinaryParser bp = new BinaryParser（）; 尝试{ String binaryString = rs.getString（strings [0]）; 返回bp.parse（binaryString）; } catch（Exception ex）{return null;} $ b $ public void nullSafeSet（PreparedStatement ps，Object o，int i，SessionImplementor si）抛出HibernateException，SQLException { Point p =（Point）o; if（p！= null）{ BinaryWriter bw = new BinaryWriter（）; ps.setObject（i，bw.writeBinary（p））; } public Object deepCopy（Object o）throws HibernateException { Point p =（Point）o; Point newPoint = null; if（p！= null）{ newPoint = new Point（p.x，p.y）; newPoint.setSrid（p.getSrid（））; } 返回newPoint; } public boolean isMutable（）{ return true; public int [] sqlTypes（）{ return new int [] {Types.BINARY}; }

最后但并非最不重要的是，您需要告诉Hibernate使用您的自定义方言。如果你使用Spring来定义会话工厂，你可以通过 hibernateProperties

I'm migrating my application from spring jdbc to JPA + Hibernate and the DB used is postgres. One of my table in the DB has point data type which translates to org.postgresql.geometric.PGpoint if i use spring jdbc. I don't how to map this to Hibernate type. Can some one please let me know how do I map the point data type to a hibernate type.

First and foremost, I think GEOMETRY data types are supported by Hibernate Spatial, but if they are not, you can always define a custom Hibernate Type and a custom Hibernate Dialect.

I had a similar problem when managing a POINT column which contained geography points.

I created a PostgisDialect class which extended PostgreSQL9Dialect, where you register the new data type in this way

in your case, you would register the type as "geometry"

then, you define a GeometryType class which implements UserType

Oddly enough, the process of writing a custom Hibernate Type is not one of the most documented features, so I will paste here what I wrote to define my PointType. For the other methods in the interface, I let them throw UnsupportedOperationException

}

some quick notes: nullSafeSet and nullSafeGet writes and reads the values to/from the database, respectively, using the BinaryWriter/BinaryParser objects.

Once you have defined all this, this is how you annotate your model class so that it uses your custom type

Last, but not least, you need to tell Hibernate to use your custom dialect. If you use Spring to define your session factory, you can define it via hibernateProperties