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
