[Gvsig_desarrolladores] Problemas Oracle Spatial

Antonio Fdez Carpio carpio1 en gmail.com
Mie Oct 24 09:24:30 CEST 2007


Hola lista. Tengo un problema al ejecutar el siguiente código que devuelve
el driver de una conexion Oracle

*try* {

String fidField = "id"; // BE CAREFUL => MAY BE NOT!!!

String geomField = "localizacion"; // BE CAREFUL => MAY BE NOT!!! =>

String[] fields = *new* String[1];

fields[0] = "id";

String whereClause = "";

OracleSpatialDriver driver = *new* OracleSpatialDriver();

// Here you can set the workingArea

// driver.setWorkingArea(dbLayerDefinition.getWorkingArea());

String strEPSG = "23030";

DBLayerDefinition lyrDef = *new* DBLayerDefinition();

lyrDef.setName(dbtable);

lyrDef.setTableName(dbtable);

lyrDef.setWhereClause(whereClause);

lyrDef.setFieldNames(fields);

lyrDef.setFieldGeometry(geomField);

lyrDef.setFieldID(fidField);

// if (dbLayerDefinition.getWorkingArea() != null)

// lyrDef.setWorkingArea(dbLayerDefinition.getWorkingArea());

lyrDef.setSRID_EPSG(strEPSG);

*if* (driver *instanceof* ICanReproject) {

((ICanReproject) driver).setDestProjection(strEPSG);

}

driver.setData(conn, lyrDef);

IProjection proj = *null*;

*if* (driver *instanceof* ICanReproject) {

proj = CRSFactory.*getCRS*("EPSG:23030");

}

*return* driver;

}

*catch* (Exception e) {

e.printStackTrace();

}



Este codigo devuelve los siguiente errores en Eclipse:

ERROR [main] (*OracleSpatialDriver.java:3167*) - Error with SQL statement. *
com.hardcode.gdbms.engine.data.NoSuchTableException*: ORA_EPSG

WARN [main] (*OracleSpatialDriver.java:450*) - No SRID found for this table.

ERROR [main] (*OracleSpatialDriver.java:3224*) - Error with SQL statement. *
com.hardcode.gdbms.engine.data.NoSuchTableException*: ORA_EPSG

ERROR [main] (*OracleSpatialDriver.java:3167*) - Error with SQL statement. *
com.hardcode.gdbms.engine.data.NoSuchTableException*: ORA_EPSG

SPHEROID["WGS84", 6378137.0, 298.257223563]

DEBUG [Thread-1] (*OracleSpatialDriver.java:871*) - SQL para leer ids:
select rowid, c.localizacion.SDO_ELEM_INFO from TRAMO c

INFO [Thread-1] (*OracleSpatialDriver.java:879*) - FETCH_SIZE = 15000

DEBUG [Thread-1] (*OracleSpatialDriver.java:899*) - Beginning of result set:

INFO [Thread-1] (*OracleSpatialDriver.java:922*) - IDs read: 0

INFO [Thread-1] (*OracleSpatialDriver.java:352*) - Ids thread delayed by:
938 ms.



Alguien sabe porque puede ocurrir esto??
------------ próxima parte ------------
Se ha borrado un adjunto en formato HTML...
URL: http://runas.cap.gva.es/pipermail/gvsig_desarrolladores/attachments/20071024/83da73b1/attachment.htm


Más información sobre la lista de distribución gvSIG_desarrolladores