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
