General question how to persist oracle spatial polygons with many vertexes

[fgdrf]

Hallo,

I would like to persist polygon objects in an oracle 10g database and get the following exception from hibernate:

org.hibernate.validator.InvalidStateException: validation failed for: my.object.ToStore
at org.hibernate.validator.event.ValidateEventListener.validate(ValidateEventListener.java:148)
at org.hibernate.validator.event.ValidateEventListener.onPreInsert(ValidateEventListener.java:172)
at org.hibernate.action.EntityInsertAction.preInsert(EntityInsertAction.java:178)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:72)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)

I debugged a little bit and I figured out that the statement is to long (longer than 4000 chars). I guess it's because using the WKT representation of the geometry. The geometry I used was the border of a country with more than 150 Points (latitude/longitude). How can I use the hibernate-spatial components in combination with the sdoapi? I read an older post (http://n2.nabble.com/java.lang.ClassCastException%3A-when-trying-to-use-JGeometry-and-Geometry-class-tp1141125p1141126.html) where Karel Maesen wrote that sdoapi isn't required anymore. Does anybody have suggestions how to store this kind of features and how to query features with such geometry in spatial conditions?

Thanks for help!

In regards
Frank Gasdorf

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users

[Karel Maesen]

Hi,

Have a look at the tutorial on: http://www.hibernatespatial.org/ 
tutorial.html (don't worry about any older versions of dependencies.  
Hibernate Spatial works also with newer versions of Hibernate and  
other dependencies).

Regards,

Karel

On 03 Jun 2009, at 12:14, [hidden email] wrote:

> Hallo,
>
> I would like to persist polygon objects in an oracle 10g database  
> and get the following exception from hibernate:
>
> org.hibernate.validator.InvalidStateException: validation failed  
> for: my.object.ToStore
> at org.hibernate.validator.event.ValidateEventListener.validate
> (ValidateEventListener.java:148)
> at org.hibernate.validator.event.ValidateEventListener.onPreInsert
> (ValidateEventListener.java:172)
> at org.hibernate.action.EntityInsertAction.preInsert
> (EntityInsertAction.java:178)
> at org.hibernate.action.EntityInsertAction.execute
> (EntityInsertAction.java:72)
> at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:
> 263)
> at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:
> 167)
> at  
> org.hibernate.event.def.AbstractFlushingEventListener.performExecution
> s(AbstractFlushingEventListener.java:321)
> at org.hibernate.event.def.DefaultFlushEventListener.onFlush
> (DefaultFlushEventListener.java:50)
> at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
> at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
> at org.hibernate.transaction.JDBCTransaction.commit
> (JDBCTransaction.java:137)
>
> I debugged a little bit and I figured out that the statement is to  
> long (longer than 4000 chars). I guess it's because using the WKT  
> representation of the geometry. The geometry I used was the border  
> of a country with more than 150 Points (latitude/longitude). How  
> can I use the hibernate-spatial components in combination with the  
> sdoapi? I read an older post (http://n2.nabble.com/ 
> java.lang.ClassCastException%3A-when-trying-to-use-JGeometry-and-
> Geometry-class-tp1141125p1141126.html) where Karel Maesen wrote  
> that sdoapi isn't required anymore. Does anybody have suggestions  
> how to store this kind of features and how to query features with  
> such geometry in spatial conditions?
>
> Thanks for help!
>
> In regards
> Frank Gasdorf
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users