Hi Uwe, I am in a happy situation in having a brand new and controlled environment and data so I can well answer your question.
PostgreSQL is installed from Windows installer postgresql-8.2.4-1.zip PostGIS comes from postgis-pg82-setup-1.3.2-1.exe The data is OpenStreetMap data loaded into PostGIS with a osm2pgsql utility that is still under development. I will ask the author if I can send the executable for you. In that case you could very simply install the same data for you by downloading OSM data dump from hypercube.telasciense.org and running osm2pgsql. The error comes if I try to read those OSM data layers with PostGIS-PlugIn. OpenJUMP reads the same tables fine with its own "Open Datastore Layer" function. And If I create new layers in OpenJUMP I can store them into PostGIS with PostGIS-PlugIn, and those tables I can also read with the PlugIn. I will let you hear if I can send the development version of osm2pgslq for Windows for you. In any case it will be available soon for everybody and it makes the use of OSM data through PostGIS extremely easy. Regards, -Jukka- -----Alkuperäinen viesti----- Lähettäjä: [EMAIL PROTECTED] puolesta: Uwe Dalluege Lähetetty: pe 11.1.2008 9:00 Vastaanottaja: JUMP Users Discussion Aihe: Re: [jump-users] Newbie's experience on OpenJUMP and PostGIS Hi Rahkonen, please tell me what do you do to reveive this error-message with the PostGIS-Plugin? It is not clear whether you use OpenJUMP with the PostGIS-PlugIn or JUMP??? Which version of PostgreSQL/PostGIS do you use? Rahkonen Jukka schrieb: > Hi, > > ... > > PostGIS with SRID Plugin > The installation of this plugin went OK. However, I wonder why the Postgres > driver must be copied into the Java directory instead of OpenJUMP lib or > /lib/ext. Actually in the OpenJUMP installed from nightly build there seems > to be newer Postres driver in /lib folder. Not a brand new that either. I > wonder if I still need to copy that old driver into Java directory. In our > managed environment I could not even do that by myself but I had to bother > administrators. > Strange thing with this plugin was that I managed to store new layers made > with JUMP into new tables in PostGIS and read those self made tables back. > However, I could not read the existing tables but got error messages like > this: > > java.lang.IllegalStateException: ERROR: syntax error at or near "," > at > net.refractions.postgis.PostGISConnection.executeQuery(PostGISConnection.java:274) > at > net.refractions.postgis.PostGISConnection.executeQuery(PostGISConnection.java:1169) > at > org.openjump.core.ui.plugin.file.DataSourceQueryChooserOpenWizard.run(DataSourceQueryChooserOpenWizard.java:84) > at > org.openjump.core.ui.plugin.file.OpenWizardPlugIn.run(OpenWizardPlugIn.java:93) > at > com.vividsolutions.jump.workbench.ui.task.TaskMonitorManager$TaskWrapper.run(TaskMonitorManager.java:149) > at java.lang.Thread.run(Unknown Source) > > ... > > Regards, > > -Jukka Rahkonen- Regards Uwe _______________________________________________ jump-users mailing list [email protected] http://lists.refractions.net/mailman/listinfo/jump-users _______________________________________________ jump-users mailing list [email protected] http://lists.refractions.net/mailman/listinfo/jump-users
