Hello Jody,
Jody Garnett said:
> Hi Ugo;
>
> I can only speak from experience based on the previous implementation
> of oracle datastore; so we will have to ask the geotools list for
> clarification.
>
> In looking at the old code it made use of the "MDSYS.CS_SRS" table
> directly and did not make use of the official epsg database.
>
> Let me check the new implementation ...
>
> public CoordinateReferenceSystem createCRS(int srid, Connection cx)
> throws SQLException {
> // if the official EPSG database has an answer, use that one
> CoordinateReferenceSystem crs = super.createCRS(srid, cx);
> if(crs != null)
> return crs;
>
> // otherwise try to decode the WKT, most of the time it's
> invalid, but
> // for new codes they learned the proper WKT syntax
> String sql = "SELECT WKTEXT FROM MDSYS.CS_SRS WHERE SRID = "
> + srid;
>
> So it is checking the database - but only as a las resort; and since
> createCRS is failing with an exception it never gets the chance.
>
> Reported bug:
> - http://jira.codehaus.org/browse/GEOT-2703
>
> Ugo will need to tell me if you want this in M7; as it will involve me
> issuing a patch to GeoTools to the 2.6-M2. Or if you can work of trunk
> for a bit?
We can live with trunk for a bit. (I'm increasingly in need of the gt
sources! :-)
We had a hard time yesterday. Apparently the oracle driver is doing
something evil
(http://forums.oracle.com/forums/thread.jspa?threadID=210782), which ends
up blocking the db and thus udig.
Apart from that we're making progress. Though I think somethings in udig
will need fixing before the oracle service is 100%.
Cheers,
Ugo
>
> Jody
>
> On 11/09/2009, at 4:11 PM, Ugo Taddei wrote:
>
>> being thrown on me by
>>
>> IGeoResourceShpInfo() throws IOException {
>> this.ft =
>> OracleGeoResource.this.parent.getDS(null).getSchema
>> (OracleGeoResource.this.typename);
>
> I would like to rename IGeoResoruceShpInof so it is more obviously
> oracle being involved.
>
>> Apparently the FeatureSource (?) is trying to make an oracle srs code
>> (8307) into an epsg one. So, before I bother the good people on the gt
>> mailing list, I ask here if someone has go an idea of what's going on.
>> There has been some recent changes in udig regarding the epsg db,
>> hasn't it?
>>
>> Thanks in advance.
>>
>> Ugo
>>
>> _______________________________________________
>> User-friendly Desktop Internet GIS (uDig)
>> http://udig.refractions.net
>> http://lists.refractions.net/mailman/listinfo/udig-devel
>
>
_______________________________________________
User-friendly Desktop Internet GIS (uDig)
http://udig.refractions.net
http://lists.refractions.net/mailman/listinfo/udig-devel
