Skip to main content
Question

Oracle spatial writer in update mode.


Forum|alt.badge.img+1
Hi,

 

 

I am trying to update a geometry of a feature stored in oracle spatial. I've set the writer mode to UPDATE also I've mentioned the key columns (combination of four colums is unque).

 

 

The workbench executes without giving any error, the log shows that it has written fatures but the geometry column does not change.

 

 

Please suggest if I am missing anything in this.

 

 

Regards

 

IMRAN

6 replies

fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • August 23, 2013
Hi Imran,

 

 

Have you specified the target geometry column name? and made sure the update geometry contents is set to yes?

 

 

Itay

 


Forum|alt.badge.img+1
  • Author
  • August 23, 2013
Yes Itay, I did that..

fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • August 23, 2013
And the writer on none? Did you refresh the viewer?

Forum|alt.badge.img+1
  • Author
  • August 23, 2013
Yes I Did..

 

And I am checking the output in the database itself.

fmelizard
Safer
Forum|alt.badge.img+18
  • Safer
  • August 23, 2013
A database also needs to be refreshed, but my guess is that you are doiing that too?

 

 

mmm I am running out of ideas then.....since you mention that the translation is succesful  I find it hard to believe that the update is not taking place.

 

 

I have many workspaces updating oracle data on a daily basis and it works like a charm.

 

 

Can you  provide more detalis? (log filsnap shot)

Forum|alt.badge.img+1
  • Author
  • August 27, 2013
Hi Itay,

 

 

The problem was with the database server, 

 

Thanks for the reply.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings