Here is my sql query :
select SDO_UTIL.POINT_AT_BEARING(SDO_GEOMETRY(2001, 8307, SDO_POINT_TYPE(44, 44, NULL), NULL, NULL), SDO_UTIL.CONVERT_UNIT(10.0, 'Degree', 'Radian'), 520.0) from dual;
To execute the query, I have the following java code :
SQLQuery query = session.createSQLQuery(sql.toString());
Geometry g = (Geometry)query.uniqueResult();
But i get the following error : No Dialect mapping for JDBC type: 2002
I followed the example on the hibernate website : http://www.hibernate.org/402.html
It works everywhere in my application, I'm able to create, update, delete... oracle spatial objects using HQL, but when I call an oracle spatial operator with an sql query... it fails.
So when using oracle spatial in hibernate, are there any differences between HQL queries and SQL queries?
Thanks for your help.