[Geoserver-users] Oracle 10G Data Store

I am using an Oracle 10G Server, but do not own the Oracle Spatial option. Can I Configure Feature Types? If so, what loss of capability will I have without the Oracle Spatial Option?

Hi,

Without the spatial option I don't think you will be able to use your
oracle database with GeoServer. There is some work going on by rob
atkinson to support "geometryless" tables in which data is specified in
x,y coordinates, etc... and not necessary a full blown geometry. But
that work is still in a very experimental state from what i believe.

How are you storing your spatial data? I wonder if it might be possible
to "trick" GeoServer into thinking your database is a spatial one by
creating the necessary metadata tables. Although this would be a stretch.

-Justin

Rishmawi, Sami wrote:

I am using an Oracle 10G Server, but do not own the Oracle Spatial
option. Can I Configure Feature Types? If so, what loss of capability
will I have without the Oracle Spatial Option?

Sami Rishmawi ( sami@anonymised.com <mailto:sami@anonymised.com> )

!DSPAM:4007,46cb0cd5133634901796417!

------------------------------------------------------------------------

-------------------------------------------------------------------------
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/

!DSPAM:4007,46cb0cd5133634901796417!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,46cb0cd5133634901796417!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

Justin, all

  Oracle 10G has a built in "mini" spatial option called
"Locator". It is provides limited GIS support. Oracle White Paper
Reference:
http://www.oracle.com/technology/products/spatial/pdf/10gr2_collateral/l
ocator_twp_10gr2.pdf. I have not yet got into the implementation
details.

  I was hoping to use GeoServer as my WFS data feed to my Oracle
"locator" enabled data.

Sam

Sami Rishmawi (sami@anonymised.com)

WebSked Lead Engineer

FGM (www.fgm.com)

voice: 619-221-1327

-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Sent: Tuesday, August 21, 2007 9:12 AM
To: Rishmawi, Sami
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Oracle 10G Data Store

Hi,

Without the spatial option I don't think you will be able to use your
oracle database with GeoServer. There is some work going on by rob
atkinson to support "geometryless" tables in which data is specified in
x,y coordinates, etc... and not necessary a full blown geometry. But
that work is still in a very experimental state from what i believe.

How are you storing your spatial data? I wonder if it might be possible
to "trick" GeoServer into thinking your database is a spatial one by
creating the necessary metadata tables. Although this would be a
stretch.

-Justin

Rishmawi, Sami wrote:

I am using an Oracle 10G Server, but do not own the Oracle Spatial
option. Can I Configure Feature Types? If so, what loss of

capability

will I have without the Oracle Spatial Option?

Sami Rishmawi ( sami@anonymised.com <mailto:sami@anonymised.com> )

!DSPAM:4007,46cb0cd5133634901796417!

------------------------------------------------------------------------

------------------------------------------------------------------------
-

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/

!DSPAM:4007,46cb0cd5133634901796417!

------------------------------------------------------------------------

_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,46cb0cd5133634901796417!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org