RE: [Geoserver-users] 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/
___________________________________________________________________________

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