inserting data in an Oracle spatial database registered in ArcSDE

[Saelen Bart-2]

Hello,

We have a problem with inserting data in an Oracle spatial database. The table with spatial data is also registered in ArcSDE 9.1. When we try to insert a record in the table with hibernate spatial we get an error.
 ORA-01400: cannot insert NULL int
o ("GEODB"."POI_POI"."OBJECTID")

This error occurs because ArcSDE added an objectid field to our table and this field can't be NULL. Is there a way to register Oracle spatial data in ArcSDE without adding the objectid field? Or is there some work around?
I know this isn't really a hibernate spatial issue, but maybe some people on this list have had the same problem and found a solution for it.

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

[Karel Maesen]

Hi Bart,

On 14 Oct 2008, at 16:56, Saelen Bart wrote:
> This error occurs because ArcSDE added an objectid field to our  
> table and this field can't be NULL. Is there a way to register  
> Oracle spatial data in ArcSDE without adding the objectid field?

I don't think so.

> Or is there some work around?

Can't you add objectID as an attribute in the persistent class as the  
identifier (primary key) ? That way Hibernate will never insert NULL  
into the field. I think ArcSDE doesn't object where the objectID  
values come from, as long as they are unique numbers.

Regards,

Karel Maesen




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