OMG.. I forgot to update this post.. The problem was on my side... with all the rush... I forgot to 'spatially enable' the db... Shame on me...
At this time everything is working quite well in OJ. (using nightly build 'openjump-20061203-0014') Although it's more and more apparent that OJ isn't designed to manage 'serious' work... For example: A shapefile with only 58Mb and a GeoTiff ~230Mb simply blow OJ to smithereens.. It usually disappears from the screen without even an exception caught... And this in a wks with 4Gb of ram ... Xms1024M Xmx2048M Now this can be caused either by Java or OJ... Again my apologies for letting this post slip. Pedro Doria Meunier. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sunburned Surveyor Sent: segunda-feira, 4 de Dezembro de 2006 19:58 To: List for discussion of JPP development and use. Subject: Re: [JPP-Devel] another one - PostGIS Save layer Pedro, I've been doing a little work with the old PostGIS Driver worked on by Uwe and Refractions Research. So I might be able to help. Can you let me know how you are trying to connect to PostgreSQL from JUMP. It appears that you are using the same plug-in from the stack trace you pasted in your e-mail. I remember looking at the PostGISConnection.executeUpdate() method, so I am familiar with the code you are executing. Please don't take offense, but when I read "addgeometrycolumn("unknown", "unknown", "unknown", integer, "unknown", integer) does not exist" in your error message, I almost think that PostGIS isn't installed correctly. This might not be a problem with OpenJUMP, but with the database or PostgreSQL. Have you sucessfully connected with the same data, database, and command sequence using an older version of OpenJUMP? The Sunburned Surveyor On 12/2/06, Pedro Doria Meunier <[EMAIL PROTECTED]> wrote: > > > > Hi guys, > > > > Still with nightly build 'openjump-20061126-0013' > > > > Using PostGIS driver V60729B > > > > java.lang.IllegalStateException: AddGeometryColumn statement failed: > org.postgresql.util.PSQLException: ERROR: function > addgeometrycolumn("unknown", "unknown", "unknown", integer, "unknown", > integer) does not exist > > SELECT AddGeometryColumn( 'portugal', 'freguesias', 'geometry', 4274, > 'GEOMETRY', 2 ) > > at > net.refractions.postgis.PostGISConnection.executeUpdate(PostGISConnection.ja va:772) > > at > net.refractions.postgis.PostGISConnection.executeUpdate(PostGISConnection.ja va:1178) > > at > com.vividsolutions.jump.workbench.datasource.AbstractSaveDatasetAsPlugIn.run (AbstractSaveDatasetAsPlugIn.java:33) > > at > com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run (TaskMonitorManager.java:149) > > at java.lang.Thread.run(Unknown Source) > > > > More and more annoying 'glitches' are surfacing with each new nightly build. > L > > > > Could anyone hint me on this one, please? > > > > Txs! > > > > Pedro. > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share your > opinions on IT & business topics through brief surveys - and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV > > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > > ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
