Ok here's a rather bizarre question. I have a JPA annotated class that contains geometry types using JTS. I'm using Hibernate to save instances to a database. My application won't query any of this data, it's simply a producer. For development I thought I would use sqlite instead of postgresql/postgis so I don't have to install a full DB on my laptop. Then I remembered that my annotated class requires spatial support.

So - and here's the crazy question - is there a way to write custom classes for a specific type (Polygon, Point) in Hibernate for specific database support (i.e. sqlite) so that Hibernate will write a Polygon or Point as a String?

Thanks

I think you need to create a custom type: http://docs.jboss.org/hibernate/orm/3.6/reference/en-US/html/types.html#types-custom

Oops...the link I've posted before was from an old version. This should be the most up to date at the moment: http://docs.jboss.org/hibernate/orm/4.3/manual/en-US/html_single/#types-custom

Great thanks - I'll read the documentation at that link.