headers
Rahkonen Jukka | 23 Mar 13:59
Picon

Problem with Oracle 9i FeatureType - Solved

Hi,

As an introduction, I used to have a problem in making a new Geoserver
FeatureType from my existing Oracle 9i spatial table created and
maintained by MapInfo tools. Creating DataStore from the Oracle database
was successful. When trying to create FeatureType all the available
Oracel tables came to selection list of the Geoserver administration
tool. Howeever, when I selected the desired table I could not create a
FeatureType from it. Administration application gave a hint that my
spatial table maybe does not have a geometry column, or the table is
empty.

After quite a many trials with my table and smaller spatial tables I
created into the same database with "shp2sdo" utility I have learned at
least the following things:

- There has to be a record in ALL_SDO_GEOM_METADATA that corresponds to
the spatial table.
- You need to have a primary key in your data. If you create it by using
shp2sdo utility it is easiest to tell the utility to create it.

These requirements are also mentioned in the Geoserver datastore
document. This additional information would have helped me a lot:

- You do not need to have SRID value set in your data but it can be null
as well. Geoserver do not care about that value in any case. It is
enough to tell Geoserver the EPSG code to be used with the FeatureType
editor.
- If you however have SRID value in your data then you must have the
same value also in the ALL_SDO_GEOM_METADATA table. Geoserver is not
(Continue reading)

Permalink | Reply |
headers
Chris Holmes | 23 Mar 17:31

Re: Problem with Oracle 9i FeatureType - Solved

Hey, these last two emails have been great information for anyone doing 
oracle.  Would you mind adding them to the docs? 
http://docs.codehaus.org/display/GEOSDOC/Oracle+DataStore is a wiki, so 
you can edit it directly 
(http://docs.codehaus.org/display/GEOSDOC/Guide+to+Documenting+GeoServer 
will get you started on editing).

The hints you give here would be good to just include in the tests.  And 
I think it might be good to make a full new sub-page on 'loading with 
shp2sdo', since I imagine lots of people will go that route.  If you 
need help with wiki editing let me know, or you can just dump it in to 
the wiki and I can take some time to clean it up.

thanks!

Chris

Rahkonen Jukka wrote:
> Hi,
> 
> As an introduction, I used to have a problem in making a new Geoserver
> FeatureType from my existing Oracle 9i spatial table created and
> maintained by MapInfo tools. Creating DataStore from the Oracle database
> was successful. When trying to create FeatureType all the available
> Oracel tables came to selection list of the Geoserver administration
> tool. Howeever, when I selected the desired table I could not create a
> FeatureType from it. Administration application gave a hint that my
> spatial table maybe does not have a geometry column, or the table is
> empty.
>
(Continue reading)

Permalink | Reply |
headers
Rahkonen Jukka | 20 Apr 07:59
Picon

Re: Problem with Oracle 9i FeatureType - Solved

Hello,

You are welcome to use those emails for whatever you want. I would appreciate your help in putting them to
documents. However, I think this Oracle datastore thing might be worth doing in a better and more
controlled way. I believe that most beginners with Oracle datastore would benefit greatly it there
exists a step-by step guide about how to make the trick. It would be essential to include well known test
data and perhaps the "Tasmania_water_bodies" shapefile could be a suitable dataset to start with. It the
newbie just starts hassling with some own data like I did it is just impossible to find out if the possible
problems are due to Geoserver or Oracle, or the data. I will try to find some time for improving the document.

Regards,

-Jukka Rahkonen-

________________________________

Lähettäjä: Chris Holmes [mailto:cholmes <at> openplans.org]
Lähetetty: to 23.3.2006 18:31
Vastaanottaja: Rahkonen Jukka
Kopio: geoserver-users <at> lists.sourceforge.net
Aihe: Re: [Geoserver-users] Problem with Oracle 9i FeatureType - Solved

Hey, these last two emails have been great information for anyone doing
oracle.  Would you mind adding them to the docs?
http://docs.codehaus.org/display/GEOSDOC/Oracle+DataStore is a wiki, so
you can edit it directly
(http://docs.codehaus.org/display/GEOSDOC/Guide+to+Documenting+GeoServer
will get you started on editing).

The hints you give here would be good to just include in the tests.  And
(Continue reading)

Permalink | Reply |
headers
Miles Jordan | 16 Mar 23:39
Picon

RE: Problem with Oracle 9i FeatureType - maybe solved, but still problem

> But maybe there 
> will some day exist a kind of conversion table to tie the 
> equivalent EPSG and Oracle SRID codes together so both the 
> Oracle and Geoserver could feel good at the same time?

Oracle 10g Release 2 does support EPSG codes (finally), and using a
conversion table is how its done. They've done heaps of work on the
spatial stuff since 9i. We're using 9i aswell and have been experiencing
problems. Hopefully we'll be moving to 10 soon(ish) so will be able to
see if any of our problems (like some features sporadically not
rendering after being pulled out of the database) disappear. 

Miles Jordan
Applications Developer
The Australian Antarctic Data Centre
___________________________________________________________________________

    Australian Antarctic Division - Commonwealth of Australia
IMPORTANT: This transmission is intended for the addressee only. If you are not the
intended recipient, you are notified that use or dissemination of this communication is
strictly prohibited by Commonwealth law. If you have received this transmission in error,
please notify the sender immediately by e-mail or by telephoning +61 3 6232 3209 and
DELETE the message.
        Visit our web site at http://www.aad.gov.au/
___________________________________________________________________________

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
(Continue reading)

Permalink | Reply |
headers
Luca Morandini | 17 Mar 08:52
Picon

Re: Problem with Oracle 9i FeatureType - maybe solved, but still problem

Miles Jordan wrote:
>>But maybe there 
>>will some day exist a kind of conversion table to tie the 
>>equivalent EPSG and Oracle SRID codes together so both the 
>>Oracle and Geoserver could feel good at the same time?
> 
> Oracle 10g Release 2 does support EPSG codes (finally), and using a
> conversion table is how its done. They've done heaps of work on the
> spatial stuff since 9i. We're using 9i aswell and have been experiencing
> problems. Hopefully we'll be moving to 10 soon(ish) so will be able to
> see if any of our problems (like some features sporadically not
> rendering after being pulled out of the database) disappear. 

Hmmm... the 10g Release 1 I own has limited support for coordinate 
transformation, and EPSG codes aren't mentioned at all. At any rate, 
data are shown in Geoserver even specifying the Oracle SRID in both the 
layer and metadata tables (but using the EPSG code when defining the 
layer in Geoserver).

Regards,

--------------------
    Luca Morandini
www.lucamorandini.it
--------------------

-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
(Continue reading)

Permalink | Reply |

Gmane