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
