Hi,

My company is looking at using Hibernate and Oracle Spatial but I can't find much information on mixing the two together.

So let's start with the questions

1) Has anyone done something like this before? How well did it work?

2) How well does Hibernate support the SDO_GEOMETRY dataypes? From what I can see, I have use UserTypes to implement support SDO_GEOMETRY. Is this the preferred way to do it?

3) Is there any documentation for using Hibernate with Spatial data?

Thanks,

Mark

Here's how:

http://www.hibernate.org/Documentation/ ... oJGeometry

Thanks for the code!

Would like to note that the line:

OracleConnection oc = (OracleConnection) preparedStatement.getConnection();

seems to fail in many cases (gathered info from various other topics here) if using container managed data-source (pooled/proxied - so the getConnection() returns something different than an OracleConnection).

The simplest solutions (which works at least for OC4J app server) is to use:

...preparedStatement.getConnection().getMetaData().getConnection();

Cheers.