maven - hibernate Spatial with oracle not work correct? -


i'm working on gis project.

in want produce web gis jsf + hibernate.

my spatial data in oracle-spatial 12c, spatial analysis must connect oracle db , insert update spatial table.

i see link hibernate-spatial

i first try maven project in net beans 8.02 not work correct!!

and have done these step:

  1. creates web application net beans 8.02 hibernate 4.3 , jsf

  2. do step of hibernate

    https://netbeans.org/kb/docs/web/hibernate-webapp.html

  3. download jar files of geo-tools link , add project

    http://sourceforge.net/projects/geotools/files/

  4. download jar file of hibernate-spatial 4.3 link , ojdbc7

    http://www.hibernatespatial.org/documentation/01-download/01-releases/

  5. add 2 spatial table project(line point)

  6. a setting steps in project , line , point class , .hbm.xml

    http://www.hibernatespatial.org/documentation/03-dialects/05-oracle/

    http://www.hibernatespatial.org/documentation/documentation/

  7. when build project in net beans , try query line error show

    java.lang.unsupportedoperationexception @ org.hibernate.spatial.geometrysqltypedescriptor.getextractor(geometrysqltypedescriptor.java:57) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:263) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:259) @ org.hibernate.type.abstractstandardbasictype.nullsafeget(abstractstandardbasictype.java:249) @ org.hibernate.type.abstractstandardbasictype.hydrate(abstractstandardbasictype.java:334) @ org.hibernate.persister.entity.abstractentitypersister.hydrate(abstractentitypersister.java:2969) @ org.hibernate.loader.loader.loadfromresultset(loader.java:1695) @ org.hibernate.loader.loader.instancenotyetloaded(loader.java:1627) @ org.hibernate.loader.loader.getrow(loader.java:1514) @ org.hibernate.loader.loader.getrowfromresultset(loader.java:725) @ org.hibernate.loader.loader.processresultset(loader.java:952) @ org.hibernate.loader.loader.doquery(loader.java:920) @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:354) @ org.hibernate.loader.loader.dolist(loader.java:2551) @ org.hibernate.loader.loader.dolist(loader.java:2537) @ org.hibernate.loader.loader.listignorequerycache(loader.java:2367) @ org.hibernate.loader.loader.list(loader.java:2362) @ org.hibernate.hql.internal.classic.querytranslatorimpl.list(querytranslatorimpl.java:939) @ org.hibernate.engine.query.spi.hqlqueryplan.performlist(hqlqueryplan.java:229) @ org.hibernate.internal.sessionimpl.list(sessionimpl.java:1260) @ org.hibernate.internal.queryimpl.list(queryimpl.java:103)

please me how solve problem or best solution hibernate-spatial?

looks using wrong dialect. oraclespatial10gdialect of hibernate spatial (hs) 4.3 take care of geometrysqltypedescriptor re-mapping sdogeometrytypedescriptor implements sqltypedescriptor.getextractor (see remapsqltypedescriptor function in hs 4.3). check hibernate/persistence.xml configuration next properties:

<property name="hibernate.dialect">org.hibernate.spatial.dialect.oracle.oraclespatial10gdialect</property> <property name="hibernate.spatial.connection_finder">org.hibernate.spatial.dialect.oracle.defaultconnectionfinder</property> 

see link explanation of connection_finder.

be aware must use hs 4.3 because using hibernate version 4.3. father problems keep in mind version of hs tested on oracle 10g , 11g says nothing oracle 12c.


Comments