Autogenerating DB schema using hibernate spatial
|
|
Coquelicot-2
|
Hi all,
I'm quite new to hibernate spatial - we are using hibernate but we would like to involve some spatial querying as well so here I am :). So far I have tried the following: at one point of our build we generate SQL DB schema to initialize the database correctly. After my first attempt to use hibernate spatial, I have the following error message: -- CUT -- [hibernate-schema-export] 10:15:55,084 WARN HBSpatialExtension:138 - Hibernate Spatial Configured but no spatial dialect BUILD FAILED /home/luke/work/projects/csd/nsili/build.xml:929: org.hibernatespatial.HibernateSpatialException: No spatial Dialect could be created at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:160) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329) at org.apache.tools.ant.Project.executeTarget(Project.java:1298) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1181) at org.apache.tools.ant.Main.runBuild(Main.java:698) at org.apache.tools.ant.Main.startAnt(Main.java:199) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) Caused by: org.hibernatespatial.HibernateSpatialException: No spatial Dialect could be created at org.hibernatespatial.GeometryUserType.configure(GeometryUserType.java:69) at org.hibernatespatial.GeometryUserType.setParameterValues(GeometryUserType.java:226) at org.hibernate.type.TypeFactory.injectParameters(TypeFactory.java:339) at org.hibernate.type.CustomType.<init>(CustomType.java:67) at org.hibernate.type.TypeFactory.heuristicType(TypeFactory.java:245) at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:260) at org.hibernate.mapping.Column.getSqlTypeCode(Column.java:138) at org.hibernate.mapping.Column.getSqlType(Column.java:182) at org.hibernate.mapping.Table.sqlCreateString(Table.java:394) at org.hibernate.cfg.Configuration.generateSchemaCreationScript(Configuration.java:848) at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:94) at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:61) at org.hibernate.tool.hbm2ddl.SchemaExportTask.getSchemaExport(SchemaExportTask.java:220) at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:148) ... 16 more --- Nested Exception --- org.hibernatespatial.HibernateSpatialException: No spatial Dialect could be created at org.hibernatespatial.GeometryUserType.configure(GeometryUserType.java:69) at org.hibernatespatial.GeometryUserType.setParameterValues(GeometryUserType.java:226) at org.hibernate.type.TypeFactory.injectParameters(TypeFactory.java:339) at org.hibernate.type.CustomType.<init>(CustomType.java:67) at org.hibernate.type.TypeFactory.heuristicType(TypeFactory.java:245) at org.hibernate.mapping.SimpleValue.getType(SimpleValue.java:260) at org.hibernate.mapping.Column.getSqlTypeCode(Column.java:138) at org.hibernate.mapping.Column.getSqlType(Column.java:182) at org.hibernate.mapping.Table.sqlCreateString(Table.java:394) at org.hibernate.cfg.Configuration.generateSchemaCreationScript(Configuration.java:848) at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:94) at org.hibernate.tool.hbm2ddl.SchemaExport.<init>(SchemaExport.java:61) at org.hibernate.tool.hbm2ddl.SchemaExportTask.getSchemaExport(SchemaExportTask.java:220) at org.hibernate.tool.hbm2ddl.SchemaExportTask.execute(SchemaExportTask.java:148) at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288) at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:105) at org.apache.tools.ant.Task.perform(Task.java:348) at org.apache.tools.ant.Target.execute(Target.java:357) at org.apache.tools.ant.Target.performTasks(Target.java:385) at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1329) at org.apache.tools.ant.Project.executeTarget(Project.java:1298) at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41) at org.apache.tools.ant.Project.executeTargets(Project.java:1181) at org.apache.tools.ant.Main.runBuild(Main.java:698) at org.apache.tools.ant.Main.startAnt(Main.java:199) at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257) at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104) --- CUT --- I am pretty sure that I specify the correct dialect in the property file I am passing to schema generation Ant task (it's part of hibernate's tool suite). Has anyone succeeded in generating a hibernate spatial 'aware' schema ? Big thanks, -- Lukasz _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
andydale
|
Hi,
Can you actually confirm what you are setting hibnerate.dialect to ? It should be either org.hibernatespatial.postgis.PostgisDialect or org.hibernatespatial.oracle.OracleSpatial10gDialect. Although I only used the hbm2ddl task to create a very simple schema, it did it correctly under both Oracle and Postgis/Postgres. Cheers, Andy 2008/6/11 Coquelicot <[hidden email]>: Hi all, _______________________________________________ hibernatespatial-users mailing list [hidden email] http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users |
||||||||||||||||
| Free Embeddable Forum Powered by Nabble | Help |
