back. If you use Hibernate Spatial in a web container with the JDBC
> Hello
>
> I'm trying to use Hibernate Spatial but I'm facing an exception when
> doing a query: PGobject cannot be cast to PGgeometry. See below for
> the full stack trace. My use case is pretty common and basically
> correspond to what's in the Tutorial.
>
> I'd be happy to get some help,
>
> Thanks a lot,
>
> --
> Eric
>
> Full stack trace
>
> org.postgresql.util.PGobject cannot be
>
> cast to org.postgis.PGgeometry
>
> org.apache.struts.action.RequestProcessor.processException
> (RequestProcessor.java:535)
>
> org.apache.struts.action.RequestProcessor.processActionPerform
> (RequestProcessor.java:433)
>
> org.apache.struts.action.RequestProcessor.process
> (RequestProcessor.java:236)
>
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:
> 1196)
>
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter
> (MonitorFilter.java:368)
>
> </pre></p><p><b>root cause</b> <pre>java.lang.ClassCastException:
> org.postgresql.util.PGobject cannot
>
> be cast to org.postgis.PGgeometry
>
> org.hibernatespatial.postgis.PGGeometryUserType.convert2JTS
> (PGGeometryUserType.java:75)
>
> org.hibernatespatial.AbstractDBGeometryType.nullSafeGet
> (AbstractDBGeometryType.java:123)
>
> org.hibernatespatial.GeometryUserType.nullSafeGet
> (GeometryUserType.java:169)
>
> org.hibernate.type.CustomType.nullSafeGet(CustomType.java:105)
>
> org.hibernate.type.AbstractType.hydrate(AbstractType.java:81)
>
> org.hibernate.persister.entity.AbstractEntityPersister.hydrate
> (AbstractEntityPersister.java:2096)
>
> org.hibernate.loader.Loader.loadFromResultSet(Loader.java:1380)
>
> org.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:1308)
>
> org.hibernate.loader.Loader.getRow(Loader.java:1206)
>
> org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:580)
>
> org.hibernate.loader.Loader.doQuery(Loader.java:701)
>
> org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections
> (Loader.java:236)
>
> org.hibernate.loader.Loader.doList(Loader.java:2220)
>
> org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
>
> org.hibernate.loader.Loader.list(Loader.java:2099)
>
> org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
>
> org.hibernate.hql.ast.QueryTranslatorImpl.list
> (QueryTranslatorImpl.java:338)
>
> org.hibernate.engine.query.HQLQueryPlan.performList
> (HQLQueryPlan.java:172)
>
> org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
>
> org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
>
> com.c2c.cdc.actions.ChangeRegionAction.execute
> (ChangeRegionAction.java:50)
>
> org.apache.struts.action.RequestProcessor.processActionPerform
> (RequestProcessor.java:431)
>
> org.apache.struts.action.RequestProcessor.process
> (RequestProcessor.java:236)
>
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:
> 1196)
>
> org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
>
> javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
>
> org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter
> (MonitorFilter.java:368)
> _______________________________________________
> hibernatespatial-users mailing list
>
[hidden email]
>
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/
> hibernatespatial-users
