Hi, You need to use one of the spatial extensions for H2.
(I think this question was also asked and answered on StackOverflow.com) Regards, Thomas On Wednesday, December 16, 2015, Stefano Cazzola <[email protected]> wrote: > Hi all. > I'm a beginner of spatial queries and entities (so please forgive me if > the question is silly) and need to use it for a project I'm working on. So > far, I've set up the generic environment, then started building the JUnit > one, with the purpose of using an in-memory DB (thing which I've done a > fair amount of times, but this the first time I have to with > spatial-queries and extensions). > > So far, persisting and retrieving (by id) entities work fine, I got > problems when quering the DB with spatial functions. > The error I get is: > [ERROR] 2015-12-16 13:27:35,164: org.hibernate.engine.jdbc.spi. > SqlExceptionHelper.logExceptions:129: Function "ST_CONTAINS" not found; > SQL statement: > select geoentity0_.id as id1_0_, geoentity0_.location as location2_0_, > geoentity0_.name as name3_0_ from GEO_ENTITY geoentity0_ where ST_Contains > (geoentity0_.location, ?)=1 [90022-190] > > Here are some code snippets of what I've done so far. > > *POM.xml* > <dependency> > <groupId>org.hibernate</groupId> > <artifactId>hibernate-spatial</artifactId> > <version>5.0.5.Final</version> > <exclusions> > <exclusion> > <groupId>org.hibernate</groupId> > <artifactId>*</artifactId> > </exclusion> > </exclusions> > </dependency> > <dependency> > <groupId>com.h2database</groupId> > <artifactId>h2</artifactId> > <version>1.4.190</version> > <scope>test</scope> > </dependency> > <dependency> > <groupId>org.orbisgis</groupId> > <artifactId>h2gis</artifactId> > <version>1.2.3</version> > <type>pom</type> > <scope>test</scope> > </dependency> > > > *persistence.xml* > <persistence > xmlns="http://java.sun.com/xml/ns/persistence"; xmlns:xsi=" > http://www.w3.org/2001/XMLSchema-instance"; > version="2.0" > xsi:schemaLocation=" > http://java.sun.com/xml/ns/persistence > http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd";> > <persistence-unit name="testPU" transaction-type="RESOURCE_LOCAL"> > <provider>org.hibernate.jpa.HibernatePersistenceProvider > </provider> > <class>org.jcz.persistence.ogc.jpa.model.GeoEntity</class> > <exclude-unlisted-classes>true</exclude-unlisted-classes> > <properties> > <property name="hibernate.connection.url" value= > "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1" /> > <property name="hibernate.connection.driver_class" value= > "org.h2.Driver" /> > <property name="hibernate.dialect" value= > "org.hibernate.spatial.dialect.h2geodb.GeoDBDialect" /> > <property name="hibernate.hbm2ddl.auto" value="create-drop" /> > <property name="hibernate.show_sql" value="true"/> > <property name="hibernate.format_sql" value="true"/> > </properties> > </persistence-unit> > </persistence> > > Can anyone explains me what I'm doing wrong? > > Thanks, > Stefano > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at https://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
