[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