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:[email protected]]
Sent: Thursday, March 08, 2012 10:25 AM
To: Guntu, Ashok (IS) (Contr); '[email protected]'
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:[email protected]]
Lähetetty: 8. maaliskuuta 2012 17:14
Vastaanottaja: Guntu, Ashok (IS) (Contr); [email protected]
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
