Hi Paolo, Thanks for your reply, it makes things clearer to me. If I may, I would like to ask 2 or 3 more questions. Do you mean that you cannot access mixed case table names or field names from OpenJUMP's standard plugin, even quoting the names like "tablename".'fieldname" ? I should try anyway. What is the problem with loading multiple fileds primary key into jump ? Last question : I cannot get varchar fields in OpenJUMP with SIS plugin, do you have an idea where it can come from ?
Finally, thanks for this plugin and congratulation for using OJ to visualize your spatial data :-) . Michaël P.Rizzi Ag.Mobilità Ambiente a écrit : > Hi Michaël, > I'm glad to see you took the time to look into the different PostGIS > drivers > and here follows details about mine. > > If you wonder why I wrote it in the first place, having the others > available, the problem was > that we have mixed case names for tables and fields (i.e. > "ElementoStradale" or "distanzaMassima"), > and this is a problem with almost every GIS (Java or C++ or whatever). > Also we have tables > with multiple fields primary key, and this is another problem. > > Since I had already developed a Java data access library to deal with > this problems > and we were using it to transfer data between PostGIS and Oracle, it > was relatively > straightforward to write the JUMP plugin as thin layer upon it and > voila!!! > For the first time we were able to see our spatial data using an open > source Java GIS!!! > > Bye > Paolo Rizzi > > -------------------------------------------------- > > > *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 > > It is read only because the datastore api from Vividsolutions does not > support wrting. > If it would I could have added write support too. I also thought about > adding writing > support using a proprietary "Save As" UI, but didn't have time to... > > > - 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). > It has indeed many dependencies... I'd rather liked to have less of > them, but I prefer to have > many dependencies than to reinvent the wheel... > Seriously, dependencies are (approx) like this: > > .) spring-xxx.jar - Instead of using "bare" JDBC, I decided to use > Spring framework support for it. > It helps in many ways, like Error messages, Exception handling, > ensuring close of connection, statement, etc. > > .) commons-xxx.jar - This is from Apache commons project and I use it > for JDBC connection pooling. > > .) jtsxxx.jar - You know this stuff... > > .) postgresql-xxx.jar - This is the PostgreSQL JDBC driver. For Oracle > you need ojdbc14.jar that > can't be re-distributed, so it has to be downloaded from Oracle. > > .) postgis_1.1.0.jar - This is NOT the JUMP PostGIS plugin, this is > the JDBC extension driver for PostGIS. > I think it's not needed though, so I should remove it, but I have to > check... > > .) sisxxx.jar - This is the real meat of the plugin. I had already > developed a data access library that I use to transfer > data between PostGIS and Oracle and these are the JARs containing it. > When I discovered that JUMP was still > alive, I wrote the Plugin as a thin layer between JUMP and my data > access library. > > .) backport-util-concurrent.jar - To adapt my library to JUMP's > datastore api, I needed a multithreaded queue, > because there was no other way to let my library read data from the > DB, while the datastore api was requesting it. > Java 5 contains new classes that implements many concurrent structures > (queues, stacks, etc.), but they're not > present in Java 1.4. Since I wanted my library to work assle-free, I > used this backport so it can run with any Java > 1.3. > > > - I found postgis_1_1_0 in dependencies but I don't know if it is > > related to 1- and if it is used > This is NOT the JUMP plugin, but the PostGIS JDBC extension driver. > That's why you see all that dependencies, my plugin is NOT based on > another plugin > but on my own data access library. > > > - I get geometry, int, double and date values, but I cannot get string > > values when loading a table or a selection ! > This is "very" strange...!!! I use it every day and I never had any > problem with strings... > If you send me a sample table I can test it!!! > > ------------------------------------------------------------------------ > *Da:* [EMAIL PROTECTED] per conto di > Michaël Michaud > *Inviato:* mar 08/05/2007 21.23 > *A:* jump-pilot-devel@lists.sourceforge.net > *Oggetto:* [JPP-Devel] 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 > > ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > >------------------------------------------------------------------------ > >------------------------------------------------------------------------- >This SF.net email is sponsored by DB2 Express >Download DB2 Express C - the FREE version of DB2 express and take >control of your XML. No limits. Just data. Click to get it now. >http://sourceforge.net/powerbar/db2/ > >------------------------------------------------------------------------ > >_______________________________________________ >Jump-pilot-devel mailing list >Jump-pilot-devel@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
