[Gvsig_english] gvSIG, Oracle Spatial and Views

[Juan Lucas Dominguez Rubio]

Hello, Kornel.
 
Excuse me, I still have not explained something important:
 
- The option "Table - New - Database" does not work properly, I'm sorry, so you cannot add alphanumeric Oracle tables (without geometry) to gvSIG. The error message shown in the log file sent by Wolfgagng is caused by this.
 
- The option "Add layer - GeoBD" should work. After your last test, we must think that your view does have ROWID field, so it should be available from gvSIG if it's listed in the Oracle metadata, as I said before. You will probably to do a manual INSERT INTO...:
 
http://listserv.gva.es/pipermail/gvsig_internacional/2010-February/004874.html
 
(obviously, it must have a geometry column (type SDO_GEOMETRY))
 
regards,
 
Juan Lucas Domínguez Rubio
---
Prodevelop SL, Valencia (España)
Tlf.: 96.351.06.12 -- Fax: 96.351.09.68
http://www.prodevelop.es <http://www.prodevelop.es/> 
---

________________________________

De: gvsig_internacional-bounces at listserv.gva.es en nombre de K.Kiss
Enviado el: mar 23/02/2010 15:37
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] gvSIG, Oracle Spatial and Views




Hello,

I´m Kornel and the colleague of the Wolfgang in munich.
I´ve tested the oracle-statement again, and it works. The tool "Toad"  hide
normally
the "ROWID"-column and display only "NULL".

But in the mode "execute as skript" :

select rowid from uis_gis_muc_mobilfunkanl_v_r


ROWID
------------------
AAAXdQAAGAAAQwDAAk
AAAXdQAAGAAAQwDAAl
AAAXdQAAGAAAQwDAAm
AAAXdQAAGAAAQwDAAn
AAAXdQAAGAAAQwDAAo
AAAXdQAAGAAAQwDAAp

1007 Rows selected.

it worked!

Thanks for the moment. If i have new informations i would it post here.
--
View this message in context: http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4619150.html
Sent from the gvSIG international mailing list archive at Nabble.com.
_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20100223/bcd13c8a/attachment.htm