ok, convinced. go ahead.. ede On 16.02.2015 21:01, Nicolas Ribot wrote: > AFAIK for Geotools, there will be heavy dependences if we want to use it to > support several spatial database. > The gt-oracle-spatial.jar, for instance, in the latest geotools release > depends on at least 10 jars. > > What I like in the current OJ code is that geometric object retrieval is > summarized to its simplest expression: > query some metadata tables, build a query to get objects, transform objects > at JDBC level directly. > For what I see, everything we need is already coded in OJ. With a minor > refactoring, same logic can be extended to several spatial databases. > > My 2 cents ;) > > On 16 February 2015 at 20:41, <[email protected]> wrote: > >> on the other hand: could you research existing java APIs first. this >> probably exists already in geotools and others and is maintained. if the >> size constraint isn't to bi we could use those. >> >> ..ede >> >> On 16.02.2015 19:57, [email protected] wrote: >>> ok, a reusable API then. sure, go ahead.. Mike? Larry? ..ede >>> >>> On 16.02.2015 19:45, Nicolas Ribot wrote: >>>> I'm not sure to understand your question. >>>> I was thinking about about adding base classes in OJ core to allow easy >>>> spatial database support. >>>> PostGIS support would stay in core, and other supports could be either >> in >>>> extension or in core if JAR licensing allows it. >>>> >>>> DB Query could stay as a standalone extension at beginning and be >>>> integrated to core DB support later. >>>> >>>> Nico >>>> >>>> On 16 February 2015 at 19:32, <[email protected]> wrote: >>>> >>>>> would it make sense to bundle efforts and create the on that rules all >> db >>>>> access for OJ, meaning to take the best from DB Query and Postgis >>>>> datasource and make that into an extension? >>>>> >>>>> there is a lot of functionality already there. >>>>> >>>>> ..ede >>>>> >>>>> On 16.02.2015 19:21, Nicolas Ribot wrote: >>>>>> Hi all, >>>>>> >>>>>> Do you think it would be interesting to have a more generic spatial >>>>>> databases vector format support in OJ ? >>>>>> >>>>>> Playing with DataStore classes to support Oracle Spatial, I saw that >> it >>>>>> could be implemented with few efforts: >>>>>> >>>>>> Most of spatial databases tend to adhere to OGC Simple Features >>>>>> Specifications for SQL. >>>>>> They are accessible through a JDBC Driver providing information about >>>>>> database metadata (tables, columns, indexes, primary keys, etc.). >>>>>> >>>>>> AFAIU, supporting a spatial database involves these steps: >>>>>> • Retrieving list of spatial tables (through OGC catalog or equivalent >>>>>> metadata query: could also be done with JDBC DatabaseMetadata by >> looking >>>>> at >>>>>> columns types: maybe an option in the DataStore Layer: "list only >>>>>> registered tables" or "list all geometric tables") >>>>>> >>>>>> • Retrieving name, srid, maybe geo type of the tables' geo columns >>>>>> >>>>>> • Retrieving tables extents with a metadata query or a custom query >> if MD >>>>>> unavailable >>>>>> >>>>>> • Loading geometric objects and converting them to OJ model. >>>>>> >>>>>> I was thinking about base classes >>>>>> (org.openjump.core.ui.plugin.datastore.spatialdatabases) implementing >>>>> core >>>>>> functionalities (DatabaseMetadata stuff and queries) and subclasses >>>>>> providing custom information (JDBC properties, default schema, custom >>>>>> queries, etc.) for each supported database. >>>>>> >>>>>> DB Query plugin showed us that Oracle, Spatialite and MySQL spatial >>>>> objects >>>>>> can be efficiently loaded into OJ. >>>>>> >>>>>> I was thinking adding support for Oracle Spatial (POC code available >> in >>>>> the >>>>>> SpatialDatabasesPlugin), MySQL/MariaDB, SQL Server, Spatialite. >>>>>> >>>>>> Nicolas >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >> ------------------------------------------------------------------------------ >>>>>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >>>>>> from Actuate! Instantly Supercharge Your Business Reports and >> Dashboards >>>>>> with Interactivity, Sharing, Native Excel Exports, App Integration & >> more >>>>>> Get technology previously reserved for billion-dollar corporations, >> FREE >>>>>> >>>>> >> http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk >>>>>> >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Jump-pilot-devel mailing list >>>>>> [email protected] >>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> >>>>> >>>>> >> ------------------------------------------------------------------------------ >>>>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >>>>> from Actuate! Instantly Supercharge Your Business Reports and >> Dashboards >>>>> with Interactivity, Sharing, Native Excel Exports, App Integration & >> more >>>>> Get technology previously reserved for billion-dollar corporations, >> FREE >>>>> >>>>> >> http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk >>>>> _______________________________________________ >>>>> Jump-pilot-devel mailing list >>>>> [email protected] >>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> >>>> >>>> >>>> >>>> >> ------------------------------------------------------------------------------ >>>> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >>>> from Actuate! Instantly Supercharge Your Business Reports and Dashboards >>>> with Interactivity, Sharing, Native Excel Exports, App Integration & >> more >>>> Get technology previously reserved for billion-dollar corporations, FREE >>>> >> http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk >>>> >>>> >>>> >>>> _______________________________________________ >>>> Jump-pilot-devel mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>> >>> >> >> >> ------------------------------------------------------------------------------ >> Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server >> from Actuate! Instantly Supercharge Your Business Reports and Dashboards >> with Interactivity, Sharing, Native Excel Exports, App Integration & more >> Get technology previously reserved for billion-dollar corporations, FREE >> >> http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk >> _______________________________________________ >> Jump-pilot-devel mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> > > > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk > > > > _______________________________________________ > Jump-pilot-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >
------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=190641631&iu=/4140/ostg.clktrk _______________________________________________ Jump-pilot-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
