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
>
--
public class WhoDidIt{ // A comment. I love comments
private static Person sender;
public static void main (String[] foo){
sender = new Person();
sender.setName(new String[]{"Edgar", "Soldin"});
Address address = new Address();
address.setStreet("Stadtweg 119");
address.setZip(39116);
address.setCity("Magdeburg");
address.setCountry("Germany");
sender.setAddress(address);
sender.setMobilePhone(" +49(0)171-2782880 ");
sender.setWebSiteUrl(" http://www.soldin.de ");
sender.setEmail(" [email protected] ");
sender.setPGPPublicKey(" http://www.soldin.de/edgar_soldin.asc ");
sender.setGender(true);
System.out.println(sender.toString());
}
}
------------------------------------------------------------------------------
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
