Geek Answers Handbook

Hibernate-spaces: sql query to retrieve geometry

I use postgresql, hibernate-spaces and postgis and is expected to be able to use SqlQuery to retrieve a Geometry object.

However, whenever I try to request a point, polygon or geometry, for example

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

I get an 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)

hibernate.cfg.xml:

 <property name="dialect">org.hibernatespatial.postgis.PostgisDialect</property>

Is this not part of the sleeping space offer, or am I doing something wrong?

Thanks, Paul.

Relevant libraries / versions:

  • winter-core-3.6.0.Final.jar
  • PostgreSQL-9.0-801.jdbc4.jar
  • hibernation-spatial-PostGIS-1.1.1.jar
  • hibernation-spatial-1.1.1.jar
  • PostGIS-JDBC-1.3.3.jar
  • JTS-1.12.jar
+7
source share
2 answers

I get it. I need to apply "GeometryUserType" to a column through a scalar.

 SQLQuery qry = session.createSQLQuery("select geomfromewkt('SRID=1;POINT(1 1)') as geom"); qry.addScalar("geom", GeometryUserType.TYPE); List<Geometry> list = qry.list();
+6
source

I am using Hibernate 5.1.0 Final,

 dao.getSession().createSQLQuery("select buffer from puntosdeinteres where puntoid = 13193") .addScalar("buffer", new GeolatteGeometryType(PGGeometryTypeDescriptor.INSTANCE)) .uniqueResult();

And it works, but now I find the long expression is uncomfortable.

+1
source

More articles:


All Articles