Hi! I have been using latest OpenJUMP from SVN and PostGIS PlugIn from https://sourceforge.net/project/showfiles.php?group_id=118054&package_id=179545&release_id=464883 . There was some problems compiling PostGIS PlugIn from SVN trunk as maven wanted to write stuff to /home/lemeser and then properties files were missing something. Plugin version tagged 1.20 compiled nicely, but as we had no actual need for modifying the plugin, the readily available PlugIn package was considered sufficient. This was some weeks ago. Now I actually tested compiling PlugIn from trunk (rev 1420) again and it worked. Five minutes of testing and everything works.
File load dialog has two options for PostGIS PlugIn. For writing I mostly used "Insert". I don't remember now what, if any, warnings were given, definitely no java.lang.IllegalStateException errors then and no warning or errors for inserting(/updating) now. SVN write access could come handy, but at the moment I'm not sure how much time I can use with OpenJUMP. Br, Jaakko > -----Original Message----- > From: Stefan Steiniger [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 20, 2008 6:35 AM > To: Ruutiainen, Jaakko > Cc: List for discussion of JPP development and use. > Subject: Re: [JPP-Devel] Few patches for PostGIS and WMS functionality > > Hei Jaakko > > No problem :) > > However, I asked Uwe on testing the current version of the > PostGIS-Plugin and he discoverd four issues with the actual > version (that was adapted by Eric to the new Framework, but > based on Uwe's version). > The three major issues where: > - two images appear with the new file load framework > - when trying to write to PostGIS an error message appears (see below) > - if a table already exists then no warning for the > overwriting appears (as it did previously) (4th and minor was > a version difference between file name and splash-screen) > > Now my questions to you: > - Do you have the same issues? (or do you use an older > version of PlugIn and OpenJUMP) > - Did you pulled your version from the SVN? when? > > I will add the patch after your answer, as I need to get sure > that we are not talking about different versions (Otherwise I > need to check the things in more detail). > > BTW: if you want, I can give you also write access to the SVN > in case you are contracted for a longer time to solve several issues. > > stefan > > -------- > error trace for writing to PostGIS > > java.lang.IllegalStateException: Insert statement failed: > org.postgresql.util.PSQLException: ERROR: current transaction > is aborted, commands ignored until end of transaction block > INSERT INTO wald ( pktnr, baumart, baumart_lat, stamm, krone, > hoehe, jg, vital, standort, geometry ) VALUES ( 1052, > 'Blutbuche', 'Fagus sylvatica Atropunicea', 170, 7, 12, 1945, > 82, '', GeometryFromText( 'POINT > (3564178.54897135 5951709.29425931)', 0) ) > at > net.refractions.postgis.PostGISConnection.executeUpdate(PostGI > SConnection.java:800) > at > net.refractions.postgis.PostGISConnection.executeUpdate(PostGI > SConnection.java:1212) > at > com.vividsolutions.jump.workbench.datasource.AbstractSaveDatas > etAsPlugIn.run(AbstractSaveDatasetAsPlugIn.java:33) > at > com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$T > askWrapper.run(TaskMonitorManager.java:149) > at java.lang.Thread.run(Unknown Source) > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
