You can get the jar with those functions here. http://geosysin.iict.ch/irstv-trac/wiki/H2spatial/Download
I have also attached the jar file. Shannon On Mon, Feb 7, 2011 at 10:03 AM, Ana Rocio Castro <[email protected]>wrote: > Hi, I'm working with Spatial H2 and I need to run the SQL sentancia space > operations, but it says can not find the class > > please if I can help to create classes in H2 Spatial. > > Thanks > > These are the SQL statements that I have to execute, which is no class > > Class "geoH2.spatialFunctions.GeoSpatialFunctions" no > encontrada<http://169.254.34.26:9902/query.do?jsessionid=9a02906c7660b249097595b7a2a7e1ec#> > > SET MAX_LENGTH_INPLACE_LOB 15000; > > CREATE ALIAS GeoVersion FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.GeoVersion"; > CREATE ALIAS LastGeoVersion FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.LastGeoVersion"; > CREATE ALIAS setWKBGeometry FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.setWKBGeometry"; > CREATE ALIAS setWKTGeometry FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.setWKTGeometry"; > CREATE ALIAS getGeometry FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.getGeometry"; > CREATE ALIAS GeomFromText FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.GeomFromText"; > CREATE ALIAS ToString FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.ToString"; > CREATE ALIAS AseWKT FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.AseWKT"; > CREATE ALIAS Length FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Length"; > CREATE ALIAS Area FOR "geoH2.spatialFunctions.GeoSpatialFunctions.Area"; > CREATE ALIAS NumPoints FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.NumPoints"; > CREATE ALIAS Dimension FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Dimension"; > CREATE ALIAS GeometryType FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.GeometryType"; > CREATE ALIAS AsText FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.AsText"; > CREATE ALIAS AsBinary FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.AsBinary"; > CREATE ALIAS SRID FOR "geoH2.spatialFunctions.GeoSpatialFunctions.SRID"; > CREATE ALIAS IsEmpty FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.IsEmpty"; > CREATE ALIAS IsSimple FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.IsSimple"; > CREATE ALIAS Boundary FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Boundary"; > CREATE ALIAS Envelope FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Envelope"; > CREATE ALIAS NumGeometries FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.NumGeometries"; > CREATE ALIAS GeometryN FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.GeometryN"; > CREATE ALIAS Equals FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Equals"; > CREATE ALIAS Disjoint FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Disjoint"; > CREATE ALIAS Touches FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Touches"; > CREATE ALIAS Within FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Within"; > CREATE ALIAS Overlaps FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Overlaps"; > CREATE ALIAS Crosses FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Crosses"; > CREATE ALIAS Intersects FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Intersects"; > CREATE ALIAS Contains FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Contains"; > CREATE ALIAS Relate FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Relate"; > CREATE ALIAS Distance FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Distance"; > CREATE ALIAS Intersection FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Intersection"; > CREATE ALIAS Difference FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Difference"; > CREATE ALIAS GeomUnion FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Union"; > CREATE ALIAS SymDifference FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.SymDifference"; > CREATE ALIAS Buffer FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.Buffer"; > CREATE ALIAS ConvexHull FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.ConvexHull"; > CREATE ALIAS IsWithinDistance FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.IsWithinDistance"; > CREATE ALIAS IsValid FOR > "geoH2.spatialFunctions.GeoSpatialFunctions.IsValid"; > > > Thanks > > > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
H2_spatialExtension1.1.jar
Description: application/java-archive
