Hibernate Community • View topic - How to map MySql GEOMETRY to Hibernate?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to map MySql GEOMETRY to Hibernate?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

jme

Post subject: How to map MySql GEOMETRY to Hibernate?

Posted: Sat Aug 20, 2005 10:15 am

Newbie

Joined: Mon Jun 06, 2005 8:21 am
Posts: 13

How can I map a GEOMETRY column type to Hibernate?

Currently I'm doing INSERT/DELETE/ operations on this sql type using java.sql.Connection and PreparedStatement classes.

Hibernate version:
2.1.7.c

Name and version of the database you are using:
MySql 4.1.12 Win

Top

Post subject:

Posted: Sat Aug 20, 2005 1:15 pm

Expert

Joined: Mon Jul 04, 2005 5:19 pm
Posts: 720

I am not sure about built in support for GEOMETRY, but have you tried inplementing this?

http://www.hibernate.org/hib_docs/api/n ... rType.html

Top

jme

Post subject:

Posted: Sun Aug 21, 2005 3:08 am

Newbie

Joined: Mon Jun 06, 2005 8:21 am
Posts: 13

Thanks for your suggestion but I'm still not convinced if I really can use UserType.

Normal insertion of GEOMETRY data:

Code:

INSERT INTO Coordinates VALUES (Geomfromtext('point(1 1)') );

Retrieval:

Code:

SELECT Y(GeomFromText(AsText(coordinate))) AS lat, X(GeomFromText(AsText(coordinate))) AS lon, ROUND(GLength(LineStringFromWKB(LineString(AsBinary(coordinate), POINT(89.6, 25.98))))) AS distance FROM Coordinate

I have to in some way combine this custom sql query and the UserType.
Is this achievable?

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum