Hello,everyone.I have a question.I can use hibernate spatial to query table which have a geometry column in table,but if i want to execute some oracle spatial function(like sdo_buffer....).How can we do ?I try to use "createSQLQuery" function ,but it throw a exception,which is "No Dialect mapping for JDBC type: 2002".Please help me,Thanks.If give me some code of demo,that is great.

I'm having the same troubles... Do you solved this trouble?

When a try to do a JPA nativeQuery and get the geoemtry fielda I'm getting a "No Dialect mapping for JDBC type: 2002"..

Anybody know how to solve this?

Many thanks!

I'm using postgresql, hibernate-spatial and postgis and expected to be able to use a SqlQuery to retrieve a Geometry object.

However whenever I try to query a Point, Polygon or Geometry eg

List list = session.createSQLQuery(
"select geomfromewkt('SRID=1;POINT(1 1)')").list();

I get the exception:

Caused by: org.hibernate.MappingException: No Dialect mapping for JDBC type: 1111
at org.hibernate.dialect.TypeNames.get(TypeNames.java:78)
at org.hibernate.dialect.TypeNames.get(TypeNames.java:103)
at org.hibernate.dialect.Dialect.getHibernateTypeName(Dialect.java:328)
at org.hibernate.loader.custom.CustomLoader$Metadata.getHibernateType(CustomLoader.java:590)
at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.performDiscovery(CustomLoader.java:516)
at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:532)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1962)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2533)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:316)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1842)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:157)

I assume this is the same problem and my guess is that hibernate-spatial (annoyingly) didn't bother to implement mappings for the sqlquery side of things?