Skip to main content
Solved

Oracle Spatial Object Reader VS SQLCreator when reading geometry

  • March 6, 2020
  • 4 replies
  • 63 views
R

Hi,

I've received an FME workbench from a colleague which uses an SQLCreator to read an Oracle Spatial database. I wanted to recreate the steps by reading from the database using the Oracle Spatial Object Reader, however when inspecting the same tables and features there seems to be no geometry related to (some of the) objects.

The weird thing is one table does show geometry, and others don't. I have also tried reading the database using an SQLExecutor as well as a FeatureReader and these two also don't read any geometry.

Does anyone know what might cause this problem/difference between transformers and readers, and knows how to solve it?

Thanks in advance.

Best answer by roetem

I seem to have found the solution based on this post . When adding the Oracle Spatial Reader there is an option under Advanced named "Handle multiple geometry columns". This allowed the geometry to be read.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

M
Forum|alt.badge.img+2

@roetem At guess, the spatial tables created (perhaps using SQLExecutor) without populating the appropriate metadata tables. The FME Oracle Spatial reader would need these. The FME Oracle Spatial writer would ensure that the appropriate tables are populated.

R
  • roetem
  • Author
  • March 9, 2020

@markatsafe Thanks for your answer. I'm not sure i completely understand your answer, but if I am right the metadata tables are not populated with geometry appropriately?

 

Is there a way to overcome this? Writing through the Oracle Spatial is not really an option because i have no permission to overwrite the database. Also, i want to review any changes in between.

 

Strangely one of my colleagues is using another software program calling the same database tables and he is also having trouble reading geometry.

R
  • roetem
  • Author
  • Best Answer
  • March 9, 2020

I seem to have found the solution based on this post . When adding the Oracle Spatial Reader there is an option under Advanced named "Handle multiple geometry columns". This allowed the geometry to be read.

R
  • roetem
  • Author
  • March 9, 2020

@markatsafe Thanks for your answer. I'm not sure i completely understand your answer, but if I am right the metadata tables are not populated with geometry appropriately?

 

Is there a way to overcome this? Writing through the Oracle Spatial is not really an option because i have no permission to overwrite the database. Also, i want to review any changes in between.

 

Strangely one of my colleagues is using another software program calling the same database tables and he is also having trouble reading geometry.

I seem to have found the solution based on this post . When adding the Oracle Spatial Reader there is an option under Advanced named "Handle multiple geometry columns". This allowed the geometry to be read.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.