All, I've had some experience here. The two modes of operation that are described are an accurate representation of the Oracle world. I would suggest at least including a descriptive difference in any sort of work order put out. There will likely need to be two separate modes of operation available (spatially). If you are building a true Oracle connector, you may want to even think of it as three separate modes, since a straight tabular linking is also a likely valuable addition. Connecting Oracle tabular data to Spatial constructs would be a usable business tool for many.
bobb >>> <[email protected]> wrote: I don't know much about Oracle either, only what I've had the misfortune to glean from trying to work with it. I raised it because due to the way that Oracle license, its easy to accidentally use Oracle Spatial functions when you only want to use Oracle Locator (which is a subset of Oracle Spatial functions). There are some pages that compare the two: http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/55/oracle-locator-vs-enterprise-licensing-the-sdogeom-package/ http://docs.oracle.com/cd/B19306_01/appdev.102/b14255/sdo_locator.htm I think from a driver perspective they're identical, but that QGIS shouldn't use any of the Spatial functions unless the user explicitly asks it to. Jonathan From: Andreas Neumann <[email protected]> To: "G. Allegri" <[email protected]> Cc: <[email protected]>, <[email protected]>, <[email protected]> Date: 03/04/2012 10:35 Subject: Re: [Qgis-user] Oracle Spatial Driver Hi, Shouldn't the Oracle driver work for both versions? I would assume so, but I may be wrong ... To me (not an oracle specialist) it seems like this is only a licensing difference? Thanks for clarifying, Andreas On Tue, 3 Apr 2012 11:27:26 +0200, G. Allegri wrote: > I suppose we're talking about Oracle Spatial, otherwise I don't think > it would worth it... > > giovanni > > 2012/4/3 > >> Just a quick general question - would this be an Oracle Spatial or >> an Oracle Locator driver? Because (for those who don't know), Oracle >> give quite a lot of their spatial stuff for "free" by way of Oracle >> Locator (it's included in Oracle Enterprise Edition), but there's a >> expensive extension called Oracle Spatial which adds a lot more >> functions. >> >> Ideally the driver would be able to use the Locator functionality >> without triggering the Spatial functionality unless that >> functionality is explicitly requested (Oracle have a weird licensing >> model - everything is enabled and you can't easily disable it; the >> onus is on the user not to use the extensions). >> >> My thoughts/observations anyway, but I'm not the one paying so... >> :-) >> Jonathan >> >> From: Andreas Neumann >> To: qgis-user , qgis-developer >> Date: 30/03/2012 08:26 >> Subject: [Qgis-user] Oracle Spatial Driver >> Sent by: [email protected] [4] >> >> ------------------------- >> >> Hi, >> >> The City of Dornbirn and the Province of Vorarlberg have an >> interest in >> getting an Oracle Spatial native driver developed for QGIS. They >> would >> finance the bulk of the development, but they are interested in >> other >> financial contributions if there are other interested commercial or >> >> governmental QGIS users with an interest in the access of Oracle >> databases. >> >> Please contact me if you have an interest in helping this project >> financially. We are not interested in small donations but in more >> substantial amounts in order not to complicate the billing process >> too >> much. >> >> Thanks, >> Andreas >> >> -- >> -- >> Andreas Neumann >> Böschacherstrasse 10A >> 8624 Grüt (Gossau ZH) >> Switzerland >> _______________________________________________ >> Qgis-user mailing list >> [email protected] [ 5] >> http://lists.osgeo.org/mailman/listinfo/qgis-user[6] >> >> This transmission is intended for the named addressee(s) only and >> may contain sensitive or protectively marked material up to >> RESTRICTED and should be handled accordingly. Unless you are the >> named addressee (or authorised to receive it for the addressee) you >> may not copy or use it, or disclose it to anyone else. If you have >> received this transmission in error please notify the sender >> immediately. All email traffic sent to or from us, including without >> limitation all GCSX traffic, may be subject to recording and/or >> monitoring in accordance with relevant legislation. >> >> _______________________________________________ >> Qgis-user mailing list >> [email protected] [7] >> http://lists.osgeo.org/mailman/listinfo/qgis-user[8] > > > > Links: > ------ > [1] mailto:[email protected] > [2] mailto:[email protected] > [3] mailto:[email protected] > [4] mailto:[email protected] > [5] mailto:[email protected] > [6] http://lists.osgeo.org/mailman/listinfo/qgis-user > [7] mailto:[email protected] > [8] http://lists.osgeo.org/mailman/listinfo/qgis-user > [9] mailto:[email protected] -- -- Andreas Neumann Böschacherstrasse 10A 8624 Grüt (Gossau ZH) Switzerland This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
