[Gvsig_english] Problems using geoBD with Oracle layer

[Jorge Sanz]

Hi,
 
gvSIG needs that Oracle Spatial Geometry columns have an spatial index. That is to say, you must create a spatial index on your GEOM column to be able to make spatial queries (gvSIG makes spatial queries to retrieve data from the database). For example:
 
CREATE INDEX MYTABLE_SPIDX ON MYTABLE (MYGEOMCOL)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
PARAMETERS ('');
 
In addition, before you create the Index, you must insert metadata about your table into the MDSYS.USER_SDO_GEOM_METADATA view. For example:
 
INSERT INTO mdsys.USER_SDO_GEOM_METADATA (TABLE_NAME,COLUMN_NAME,DIMINFO,SRID)
VALUES ('MYTABLE','MYGEOMCOL',
mdsys.SDO_DIM_ARRAY(mdsys.SDO_DIM_ELEMENT('X', -180, 180, 0.001), mdsys.SDO_DIM_ELEMENT('Y', -90, 90, 0.001)), 8307);
 
Regards

Jorge Gaspar Sanz Salinas 
Ingeniero en Geodesia y Cartografía 
Prodevelop S.L. - Valencia - España 
Tlf.:  96.351.06.12 - Fax:   96.351.09.68 
jsanz[en]prodevelop[punto]es 
http://www.prodevelop.es <http://www.prodevelop.es/>  

________________________________

De: gvsig_internacional-bounces at runas.cap.gva.es en nombre de Wolfgang Qual
Enviado el: mié 30/05/2007 11:26
Para: gvsig_internacional at runas.cap.gva.es
Asunto: [Gvsig_english] Problems using geoBD with Oracle layer



Hi list,
I just had the possibility to test geoBD-extension with an Oracle Spatial Connection.
I could connect to the Oracle Database, all layers appear in the GeoBD-dialogue box.
However, when trying to activate one of them, the error message appears:
"Error while getting valid geometry fields: no spatial indexes found on geometry field of table [tablename]".
This is strange, as I see the column "GEOM" in the list of columns of this table. Is there a reason, why this column is not recognised? Geom is of type MDSYS.SDO_GEOMETRY.

I would be grateful for any comments!
Best,
Wolfgang

--
Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer
_______________________________________________
Gvsig_internacional mailing list
Gvsig_internacional at runas.cap.gva.es
http://runas.cap.gva.es/mailman/listinfo/gvsig_internacional


-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5687 bytes
Desc: not available
Url : http://runas.cap.gva.es/pipermail/gvsig_internacional/attachments/20070530/7743691a/attachment.bin