[Gvsig_english] gvSIG, Oracle Spatial and Views
K.Kiss
kornel.kiss at muenchen.de
Wed Apr 14 16:43:29 CEST 2010
Hello,
i changed my original problem. I´ve converted the original view in standard
oracle-table. Here the create skript:
delete from user_sdo_geom_metadata where table_name='MOBIL_R'
/
insert into user_sdo_geom_metadata values(
'MOBIL_R','GEOM',mdsys.sdo_dim_array(mdsys.sdo_dim_element( 'X', 4356000,
4612550, 0.0005),mdsys.sdo_dim_element( 'Y', 522550, 5496000,
0.0005),mdsys.sdo_dim_element( 'Z', -255, 255, 0.0005)),82032)
/
DROP TABLE MOBIL_R CASCADE CONSTRAINTS
/
CREATE TABLE MOBIL_R
(
OBJEKT_ID NUMBER,
NAME VARCHAR2(80 BYTE),
STRASSEHAUSNR VARCHAR2(80 BYTE),
PLZ VARCHAR2(255 BYTE),
ORT VARCHAR2(255 BYTE),
GEOM MDSYS.SDO_GEOMETRY,
ANNOTATIONO VARCHAR2(255 BYTE),
CITYO VARCHAR2(255 BYTE),
CLASSIFICATIONO VARCHAR2(255 BYTE),
EASTINGO VARCHAR2(255 BYTE),
EPLUSO VARCHAR2(255 BYTE),
EPLUSUMTSO VARCHAR2(255 BYTE),
EUROO VARCHAR2(255 BYTE),
INITIALOPERATIONO VARCHAR2(255 BYTE),
NEWOPERATIONO VARCHAR2(255 BYTE),
NORTHINGO VARCHAR2(255 BYTE),
OFFICESO VARCHAR2(255 BYTE),
OTHERSO VARCHAR2(255 BYTE),
O2O VARCHAR2(255 BYTE),
O2UMTSO VARCHAR2(255 BYTE),
RADIOSTATIONSKWO VARCHAR2(255 BYTE),
RADIOSTATIONSUKWO VARCHAR2(255 BYTE),
SAFETYDISTANCEO VARCHAR2(255 BYTE),
TMOBILEO VARCHAR2(255 BYTE),
TMOBILEUMTSO VARCHAR2(255 BYTE),
TVSTATIONSO VARCHAR2(255 BYTE),
VODAFONEO VARCHAR2(255 BYTE),
VODAFONEUMTSO VARCHAR2(255 BYTE)
)
/
CREATE INDEX MOBIL_PUNKT_GEOM_R ON MOBIL_R
(GEOM)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
/
insert into mobil_r select * from UIS_GIS_MUC_MOBILFUNKANL_V_R
/
commit
/
So wide so good, the loading of the data of the oracle-table work!
----------------------------------------------------------------
Change to 1000Byte Varchar2()!
delete from user_sdo_geom_metadata where table_name='MOBIL_R'
/
insert into user_sdo_geom_metadata values(
'MOBIL_R','GEOM',mdsys.sdo_dim_array(mdsys.sdo_dim_element( 'X', 4356000,
46110000, 0.0005),mdsys.sdo_dim_element( 'Y', 5210000, 5496000,
0.0005),mdsys.sdo_dim_element( 'Z', -1000, 1000, 0.0005)),82032)
/
DROP TABLE MOBIL_R CASCADE CONSTRAINTS
/
CREATE TABLE MOBIL_R
(
OBJEKT_ID NUMBER,
NAME VARCHAR2(80 BYTE),
STRASSEHAUSNR VARCHAR2(80 BYTE),
PLZ VARCHAR2(1000 BYTE),
ORT VARCHAR2(1000 BYTE),
GEOM MDSYS.SDO_GEOMETRY,
ANNOTATIONO VARCHAR2(1000 BYTE),
CITYO VARCHAR2(1000 BYTE),
CLASSIFICATIONO VARCHAR2(1000 BYTE),
EASTINGO VARCHAR2(1000 BYTE),
EPLUSO VARCHAR2(1000 BYTE),
EPLUSUMTSO VARCHAR2(1000 BYTE),
EUROO VARCHAR2(1000 BYTE),
INITIALOPERATIONO VARCHAR2(1000 BYTE),
NEWOPERATIONO VARCHAR2(1000 BYTE),
NORTHINGO VARCHAR2(1000 BYTE),
OFFICESO VARCHAR2(1000 BYTE),
OTHERSO VARCHAR2(1000 BYTE),
O2O VARCHAR2(1000 BYTE),
O2UMTSO VARCHAR2(1000 BYTE),
RADIOSTATIONSKWO VARCHAR2(1000 BYTE),
RADIOSTATIONSUKWO VARCHAR2(1000 BYTE),
SAFETYDISTANCEO VARCHAR2(1000 BYTE),
TMOBILEO VARCHAR2(1000 BYTE),
TMOBILEUMTSO VARCHAR2(1000 BYTE),
TVSTATIONSO VARCHAR2(1000 BYTE),
VODAFONEO VARCHAR2(1000 BYTE),
VODAFONEUMTSO VARCHAR2(1000 BYTE)
)
/
CREATE INDEX MOBIL_PUNKT_GEOM_R ON MOBIL_R
(GEOM)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
/
insert into mobil_r select * from UIS_GIS_MUC_MOBILFUNKANL_V_R
/
commit
/
The same datas producing any errors in GVSIG:
ERROR AWT-EventQueue-1
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver -
===============
DEBUG Thread-26
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - SQL
para leer ids: select rowid, c.GEOM.SDO_ELEM_INFO from UMSYSGIS.MOBIL_R c
INFO Thread-26
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver -
FETCH_SIZE = 15000
DEBUG Thread-26
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver -
Beginning of result set:
INFO Thread-26
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - IDs
read: 0
DEBUG AWT-EventQueue-1 com.iver.cit.gvsig.fmap.layers.FLyrDefault -
setTocStatusImage sun.awt.image.ToolkitImage at 55fd43 sobre capa
UMSYSGIS.MOBIL_R
INFO Thread-26
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - Ids
thread delayed by: 953 ms.
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
60236 KB
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
60236 KB
DEBUG Thread-26 com.iver.cit.gvsig.fmap.layers.FLyrDefault -
setTocStatusImage null sobre capa UMSYSGIS.MOBIL_R
DEBUG Thread-19
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - MAIN
SEL = select ROWID, c."OBJEKT_ID", c."NAME", c."STRASSEHAUSNR", c."PLZ",
c."ORT", c."ANNOTATIONO", c."CITYO", c."CLASSIFICATIONO", c."EASTINGO",
c."EPLUSO", c."EPLUSUMTSO", c."EUROO", c."INITIALOPERATIONO",
c."NEWOPERATIONO", c."NORTHINGO", c."OFFICESO", c."OTHERSO", c."O2O",
c."O2UMTSO", c."RADIOSTATIONSKWO", c."RADIOSTATIONSUKWO",
c."SAFETYDISTANCEO", c."TMOBILEO", c."TMOBILEUMTSO", c."TVSTATIONSO",
c."VODAFONEO", c."VODAFONEUMTSO", c.GEOM from UMSYSGIS.MOBIL_R c where
(sdo_relate(GEOM, mdsys.sdo_geometry(2003, 82032, null,
mdsys.sdo_elem_info_array(1, 1003, 3), mdsys.sdo_ordinate_array(4356000.0,
-1.40906537313433E7, 4.611E7, 2.47966537313433E7)), 'mask=anyinteract
querytype=window') = 'TRUE')
DEBUG Thread-19 com.iver.andami.messages.NotificationManager - Java heap
space
java.lang.OutOfMemoryError: Java heap space
DEBUG Thread-19
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - MAIN
SEL = select ROWID, c."OBJEKT_ID", c."NAME", c."STRASSEHAUSNR", c."PLZ",
c."ORT", c."ANNOTATIONO", c."CITYO", c."CLASSIFICATIONO", c."EASTINGO",
c."EPLUSO", c."EPLUSUMTSO", c."EUROO", c."INITIALOPERATIONO",
c."NEWOPERATIONO", c."NORTHINGO", c."OFFICESO", c."OTHERSO", c."O2O",
c."O2UMTSO", c."RADIOSTATIONSKWO", c."RADIOSTATIONSUKWO",
c."SAFETYDISTANCEO", c."TMOBILEO", c."TMOBILEUMTSO", c."TVSTATIONSO",
c."VODAFONEO", c."VODAFONEUMTSO", c.GEOM from UMSYSGIS.MOBIL_R c where
(sdo_relate(GEOM, mdsys.sdo_geometry(2003, 82032, null,
mdsys.sdo_elem_info_array(1, 1003, 3), mdsys.sdo_ordinate_array(4356000.0,
-1.40906537313433E7, 4.611E7, 2.47966537313433E7)), 'mask=anyinteract
querytype=window') = 'TRUE')
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core
-- Konnte Übersetzung nicht finden für: Informations-Konsole
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core
-- Konnte Übersetzung nicht finden für: Aktiviert das Fenster
DEBUG Thread-19 com.iver.andami.messages.NotificationManager - Java heap
space
java.lang.OutOfMemoryError: Java heap space
DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin - Activando
Informations-Konsole
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
52627 KB
DEBUG Thread-19
es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver - MAIN
SEL = select ROWID, c."OBJEKT_ID", c."NAME", c."STRASSEHAUSNR", c."PLZ",
c."ORT", c."ANNOTATIONO", c."CITYO", c."CLASSIFICATIONO", c."EASTINGO",
c."EPLUSO", c."EPLUSUMTSO", c."EUROO", c."INITIALOPERATIONO",
c."NEWOPERATIONO", c."NORTHINGO", c."OFFICESO", c."OTHERSO", c."O2O",
c."O2UMTSO", c."RADIOSTATIONSKWO", c."RADIOSTATIONSUKWO",
c."SAFETYDISTANCEO", c."TMOBILEO", c."TMOBILEUMTSO", c."TVSTATIONSO",
c."VODAFONEO", c."VODAFONEUMTSO", c.GEOM from UMSYSGIS.MOBIL_R c where
(sdo_relate(GEOM, mdsys.sdo_geometry(2003, 82032, null,
mdsys.sdo_elem_info_array(1, 1003, 3), mdsys.sdo_ordinate_array(4356000.0,
-1.40906537313433E7, 4.611E7, 2.47966537313433E7)), 'mask=anyinteract
querytype=window') = 'TRUE')
DEBUG Thread-19 com.iver.andami.messages.NotificationManager - Java heap
space
java.lang.OutOfMemoryError: Java heap space
.................................
--
View this message in context: http://n2.nabble.com/gvSIG-Oracle-Spatial-and-Views-tp4611156p4902016.html
Sent from the gvSIG international mailing list archive at Nabble.com.
More information about the Gvsig_internacional
mailing list