Does anyone have any experience of using geoserver to connect to a table in
Oracle that has been spatially enabled using SDE. The table is called
TEST_QUAKE and is in the BEN schema and is populated with 5000 records.
Name Null? Type
----------------------------------------- -------- ------------------
EVENT_ID NUMBER(11)
LAT NUMBER(8,5)
LON NUMBER(8,5)
SHAPE BEN.ST_GEOMETRY
OBJECTID NOT NULL NUMBER(38)
PK NOT NULL NUMBER(5)
When I create a data store (selecting Oracle in the Feature Data Set
Description) called quake and then try to create a new FeatureType from
available DataStores and select quake::TEST_QUAKE i only see the following 4
fields: EVENT_ID, LAT, LON, OBJECTID. PK and SHAPE are not listed.
Generating a bounding box yields the following error: The FeatureType
'TEST_QUAKE' has a NULL extent. HINT: the dataset is empty or has no default
geometry attribute.
Is there a subtle issue here or does geoserver just not understand the ESRI
spatial type?
Many thanks
Paul
--
View this message in context: http://www.nabble.com/ST_GEOMETRY-in-Oracle-tf4644885.html#a13267845
Sent from the GeoServer - User mailing list archive at Nabble.com.
Paul Grimwood ha scritto:
Does anyone have any experience of using geoserver to connect to a table in
Oracle that has been spatially enabled using SDE. The table is called
TEST_QUAKE and is in the BEN schema and is populated with 5000 records.
Name Null? Type
----------------------------------------- -------- ------------------
EVENT_ID NUMBER(11)
LAT NUMBER(8,5)
LON NUMBER(8,5)
SHAPE BEN.ST_GEOMETRY
OBJECTID NOT NULL NUMBER(38)
PK NOT NULL NUMBER(5)
When I create a data store (selecting Oracle in the Feature Data Set
Description) called quake and then try to create a new FeatureType from
available DataStores and select quake::TEST_QUAKE i only see the following 4
fields: EVENT_ID, LAT, LON, OBJECTID. PK and SHAPE are not listed.
Generating a bounding box yields the following error: The FeatureType
'TEST_QUAKE' has a NULL extent. HINT: the dataset is empty or has no default
geometry attribute.
Is there a subtle issue here or does geoserver just not understand the ESRI
spatial type?
The second. The Oracle data store understands only SDO_GEOMETRY.
Yet, if you have SDE, you can connect GeoServer to ArcSDE using
the plugin you can find in the "extension datastores" downloads.
Hope this helps
Cheres
Andrea
Many thanks for that Andrea. I guess we'll be looking into the options of
connecting to SDE, forking out for Oracle Spatial or looking into synching
Oracle with Postgres.
Best regards
Paul
aaime wrote:
Paul Grimwood ha scritto:
Does anyone have any experience of using geoserver to connect to a table
in
Oracle that has been spatially enabled using SDE. The table is called
TEST_QUAKE and is in the BEN schema and is populated with 5000 records.
Name Null? Type
----------------------------------------- -------- ------------------
EVENT_ID NUMBER(11)
LAT NUMBER(8,5)
LON NUMBER(8,5)
SHAPE BEN.ST_GEOMETRY
OBJECTID NOT NULL NUMBER(38)
PK NOT NULL NUMBER(5)
When I create a data store (selecting Oracle in the Feature Data Set
Description) called quake and then try to create a new FeatureType from
available DataStores and select quake::TEST_QUAKE i only see the
following 4
fields: EVENT_ID, LAT, LON, OBJECTID. PK and SHAPE are not listed.
Generating a bounding box yields the following error: The FeatureType
'TEST_QUAKE' has a NULL extent. HINT: the dataset is empty or has no
default
geometry attribute.
Is there a subtle issue here or does geoserver just not understand the
ESRI
spatial type?
The second. The Oracle data store understands only SDO_GEOMETRY.
Yet, if you have SDE, you can connect GeoServer to ArcSDE using
the plugin you can find in the "extension datastores" downloads.
Hope this helps
Cheres
Andrea
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
View this message in context: http://www.nabble.com/ST_GEOMETRY-in-Oracle-tf4644885.html#a13283347
Sent from the GeoServer - User mailing list archive at Nabble.com.