Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [udig-users] udig 1.2 and oracle connection an layers

Some more thoughts inline ...

On 24/08/2010, at 8:46 PM, k0b3@xxxxxxxx wrote:

> Hi all!
> I'm a new user and i have some question about udig...
> Is oracle fully supported? Viewing, editing and so on...
> i'm trying to connect an oracle 10g server with the most recent 1.2.0 udig
> i can read the resources but i can view in my map only the oracle spatial objects (ver. oracle 8), not the relational-oracle layers!

What do you mean by the relational layers?

If they are a table that you would like to join with a spatial table in order to visualise (for example traffic lights are often a table with an relation to spatial intersection table) there are two options:
- (today) create a view - and show the view in your map
- (pending) make use of the app-schema module to define a feature type combing several tables (and mapping the relationships)

> there is some guide or howto oracle connection?

> when i'm tryin' to edit my oracle (object) geometries i can select the modal tool edit but when i select the feature the cursor start to blinking with a little red circle... and nothing else what it mean? Not supported?

It usually means that the query is taking place; it blinks as long as the query is taking ...

> other times, when i select the editing modal tool, udig say me that the editing is not possible on a such layer... but why?

It does respect permissions; so read-only tables or view are not considered editable.

> i can edit the same layer with several other software and i don't understand what udig need... maybe need some primary key, or gid, or someting else... or is not supported, but where i can find more detailed error messages? there is som e detailed log file?

The error log is available in the help menu; instructions are here:
- http://udig.refractions.net/confluence/display/EN/View+Error+Log+and+Configuration+Details

I don't know of any special requirements off the top of my head; the library we are using is here (http://docs.codehaus.org/display/GEOTOOLS/JDBC+Module).

>  
> thank you very much for any suggestion

If you are available when we make the next release (after to foss4g conference) we would love a hand testing oracle connection support.




Back to the top