Rahkonen,
Thanks for the response. But I believe SDO_GEOMETRY is not a type in oracle
10g. That is probably supported in Spatial. Am i right?
Thanks
Ashok
From: Rahkonen Jukka [mailto:jukka.rahko...@mmmtike.fi]
Sent: Thursday, March 08, 2012 10:25 AM
To: Guntu, Ashok (IS) (Contr); 'geoserver-users@lists.sourceforge.net'
Subject: EXT :Re: GeoServer with oracle (not spatial)
Hi,
You must have geometries in a column of type SDO_GEOMETRY. You can alter your
existing table and populate the sdo_geometry field from your x and y columns
with a SQL query. But if you have never heard about sdo_geometry before I would
recommend to use a few days by reading Oracle Spatial documents.
-Jukka Rahkonen-
Lähettäjä: Guntu, Ashok (IS) (Contr) [mailto:ashok.gu...@ngc.com]
Lähetetty: 8. maaliskuuta 2012 17:14
Vastaanottaja: Guntu, Ashok (IS) (Contr); geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] GeoServer with oracle (not spatial)
Hi,
I am new to GeoServer and am trying to create a layer using the data I have
in oracle 10g database. I am able to connect to my database and see all my
tables. I am also able to create a view. But anywhere in the documentation, I
was unable to find what kind of view/table is required to create a layer out of
it. I have used a table with columns like latitude and longitude and tried to
create a layer but was not successful. Is there any documentation which tells
me what the data model should be.
Any help is appreciated. Thanks in advance.
Ashok
--
Virtualization Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users