Re: [udig-users] udig 1.2 and oracle connection an layers

[k0b3@xxxxxxxx]

 > --------- Original Message --------
> Da: "Jody Garnett" <jody.garnett@xxxxxxxxx>
 
 Thanks fof your fast reply!!

 > What do you mean by the relational layers?

I'm sorry for misunderstanding!
Prior oracle ver.8.1 oracle stored the spatial data and index in the same table with the column GEOM (like potgres/postgis).
now oracle use the relational model (i'm sure you can teach me, i'll write only for better explain) with the tables name, name_SDODIM, name_SDOGEOM, name_SDOINDEX, name_SDOLAYER 
In a database i stored a "object" (one table) layer and a "relational" (5 tables indexed) layer both imported using fme translator (safe software).
With udig i can view (but not edit) the oracle object layer and the relational tables are all displayed as simple alphanumeric data tables, not as something spatial! So i don't know what's wrong, because i
 'm
quite sure thet udig support oracle spatial "relational model".
 
 > It usually means that the query is taking place; it blinks as long as the query is taking ...
 
why the query is taking place? 
i mean, when i select a feature with the mouse on a active layer i'm working in a udig level, it's correct?
If i import a layer from a db i make a query, when the db returns the data udig display the features, but it stores the data, i suppose, into a temporary udig data structure, right? (if not please answer, because this is important for me to understand the udig behavior).
So, when i click with the mouse on a feature in order to select and edit the shape udig perform a query? I think it's only a intersection function between the point's coordinates and the layer stored in udig temporary structure... 
if udig perform a query the problem can be the database server connection or other like primary key... and i have to seek in this
direction,
otherwise may be a software bug... i don't know! 

 > It does respect permissions; so read-only tables or view are not considered editable.
 in order to access udig into a db i use the "owner" account so i haven't read only tables... it's a mistery for me!


 > If you are available when we make the next release (after to foss4g conference) we would love a hand testing oracle connection support.
 you're welcome... i don't know if i'm able... i'm a newbie.

really thanks for your explainations

----
Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it

Sponsor:
Le migliori proposte Last Minute al Mare nelle localita' piu' famose della Riviera Adriatica e della Sardegna… prenota subito, ultime disponibilita'!!
Clicca qui