[Gvsig_english] Re: [ANTISPAMRT:] Gvsig_internacional Digest, Vol 23, Issue 15

[Juan Lucas Dominguez Rubio]

Hello, Andrea.
 
According to our table of correspondence, Oracle-82087 is EPSG:26591. You can try to use that EPSG code and in a future version of gvSIG we will add EPSG:3003 as a synonym for EPSG:26591.
 
The next problem in your log file (with a class called OracleWebRowSetXmlWriter) is very strange. I have done step-by-step execution and I think the class "oracle.jdbc.rowset.OracleWebRowSetXmlWriter" should not be instantiated in that part of the code. Maybe you have copied the ojdbc14.jar file in the wrong place? In which folder did you copy it? Have you copied it in more than one place?
 
Regarding the privileges, you can try to execute this SQL from another  application with the same user to see if you have permission do to it (replace USER with your username):
 
INSERT INTO ALL_SDO_GEOM_METADATA  ( OWNER, TABLE_NAME, COLUMN_NAME, DIMINFO, SRID )  VALUES ('USER', 'TEST_TABLE', 'GEOMETRY', MDSYS.SDO_DIM_ARRAY( MDSYS.SDO_DIM_ELEMENT ('X', 0, 100, 0.000005 ), MDSYS.SDO_DIM_ELEMENT ('Y', 0, 100, 0.000005 )), NULL )
 
If that SQL is successful, then you should remove that test row with this SQL:
 
DELETE FROM ALL_SDO_GEOM_METADATA WHERE OWNER = 'USER' AND TABLE_NAME = 'TEST_TABLE'
 
Please try it and tell me what happens.
 
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 runas.cap.gva.es en nombre de Ing. Andrea Peri
Enviado el: vie 21/12/2007 12:11
Para: gvsig_internacional at runas.cap.gva.es
Asunto: [Gvsig_english] Re: [ANTISPAMRT:] Gvsig_internacional Digest, Vol 23, Issue 15



Hi, Diego,
... I remember someone :)

Yes with this patch gvSig the settings are availables.
But there is another error.

gvSig give an error meanwhile export shapefile to oracle.

The account I use has sufficient privileges to create a table with
sdo_geometry, and to write/select a record from the
user_sdo_geom_metadata.
So I don't understand why it report "insufficient privilege".

I think is an error on index.

Perhaps for the SRS used ?

I used EPSG:3003, but Oracle don't know epsg:3003, it know SRID: 82087.

I put the log error in attach.

best Regards,
Andrea.


At 21/12/2007 11:20, you wrote:
>Hello, Diego:
>
>In gvSIG 1.1 there is a misplaced file that causes the problem you
>mention. To solve it, just copy the file:
>
>..\gvSIG_1.1\bin\gvSIG\extensiones\com.iver.cit.gvsig\images\jdbc.png
>
>to this folder:
>
>..\gvSIG_1.1\bin\gvSIG\extensiones\com.iver.cit.gvsig.oracle_spatial\images\
>

===================================================
Andrea Peri
Regione Toscana
Direzione Generale POLITICHE TERRITORIALI E AMBIENTALI
Settore SERVIZIO GEOGRAFICO REGIONALE
Via di Novoli, 26 - 50127 Firenze
Tel. +0039 055 438.3968
===================================================


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