|
Hi everybody,
I checked the "4 - paolo rizzi's SIS plugin" and it actually uses file "postgis_1_1_0.jar", but it is provided inside the plugin's directory, so it's not necessary to have it inside OJ main lib directory. This plugin comes with many .jar files because it is an adapter between Vividsolutions Datastore API and a library for accessing PostGIS and Oracle that I wrote at the time (2004-2006). I wrote the plugin because we were using MixedCase names for tables and fields and also multiple schemas (beside "public"), and none of the open-source GIS available at that time, supported our use case. >> - I get geometry, int, double and date values, but I cannot get string values when loading a table or a selection ! As for this point I don't know... with the original JUMP 1.2.0 from Vividsolutions it perfectly works... I also just downloaded and tried with "OpenJUMP-1.5.2-r2930-PLUS" portable version and it worked as well. Albeit I'm not working anymore in this field (Java GIS), I still follow your mailing lists and the fantastic job of the OpenJUMP community, bravi!!! :-) Bye Paolo Rizzi Bugs item #1716059, was opened at 2007-05-09 12:01 Message generated for change (Comment added) made by michaudm You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=679906&aid=1716059&group_id=118054Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nobody/Anonymous (nobody) Assigned to: Nobody/Anonymous (nobody) Summary: remove postgis code and postgis_1_0_0.jar Initial Comment: see investigations by michael: OpenJUMP and postgreSQL/PostGIS Hi everybody, I tried to understand differences between the 4 versions of postgresql/postgis drivers I found at different places. Here are the results of my investigations Comments are welcome. *Different versions I found *1 - a plugin (postgis_1_0_0.jar) from 2005 written by Markus Schaber and bundled with OpenJUMP distribution. As far as I could see, the plugin is bundled but unused in the distribution (nothing happened, even after I have had the jar file to the classpath) 2 - a plugin from uwe dalluege distributed as the "PostGIS PlugIn" on OpenJUMP sourceforge site (2006-11-19). May be based on the previous one. 3 - datastore api from vividsolutions added to the code on december of 2005, but not activated in the original jump version 4 - paolo rizzi's SIS plugin for postgresql/postgis and oracle database access, based on the framework developped in 3 *Disimilarities between versions* *1 - postgis plugin* 1.0.0 - Don't know how to make this postgis_1_0_0.jar work. If it has no use, it should be removed from the distribution *2 - Uwe's postgis plugin* - the plugin is the only one able to create/update the database. Other ones are read only - it works well with postgresql 8.2 and postgis 1.1+ - the plugin load data from the load dataset menu and does not use the nice interface from vividsolution in the layer menu (see 3) - the plugin load data (in-memory) and does not offer a select option or a feature-on-demand option *3 - Vividsolutions's framework* - Vividsolutions's datastore api has a nice design and a nice user interface, but at the moment, it is read-only. - the interface make it possible to cache features (in-memory ?) or not (feature on demand ?) - I could not read a posgis table with Vividsolution's api and OpenJUMP until I made two changes in the code : a) in PostgisValueConverterFactory, if dbTypeName is geometry, I return WKB mapper instead of WKT (since postgis 1.0, default storage format in postgis is binary) b) If there are more than one geometry type in the resultset, the second is read as AttributeType.STRING instead of throwing an exception (in a select * statement, I can get more than one geometry from my database). *4 - SIS PlugIn from Paolo Rizzi *- The plugin is based on Vividsolutions's api - It is a read-only driver for postgis and oracle tables - The plugin includes many dependencies (3 Mo). I don't know why it needs all this stuff because there is not much more features in this plugin than in vivid's api (maybe hidden classes for futur work). - I found postgis_1_1_0 in dependencies but I don't know if it is related to 1- and if it is used - I get geometry, int, double and date values, but I cannot get string values when loading a table or a selection ! PS : I know there is also a hard work done by projet-SIGLE team to write a generic data/database driver called GDBMS... Hope that helps, Michaël ----------------------------------------------------------------------Comment By: michael michaud (michaudm)Date: 2012-10-10 22:52 Message: remove postgis_1_0_0.jar dependency (r3043) and close the bug ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=679906&aid=1716059&group_id=118054 ------------------------------------------------------------------------------ Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel |
------------------------------------------------------------------------------ Don't let slow site performance ruin your business. Deploy New Relic APM Deploy New Relic app performance management and know exactly what is happening inside your Ruby, Python, PHP, Java, and .NET app Try New Relic at no cost today and get our sweet Data Nerd shirt too! http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
