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
