Hi Uwe, 1. jump_postgis_plugin_srid_v1.2.1 --> this is the version of plugin downloaded on 17-11-2008. I checked that the latest download on date has the same number v1.2.1. 2. The postgis table saved earlier with SRID=3000 retains it when opened afresh in Oj.
Cheers Ravi Kumar > From: Uwe Dalluege <[email protected]> > Subject: Re: [jump-users] SRID Puzle > To: [email protected], "JUMP Users Discussion" > <[email protected]> > Date: Monday, February 9, 2009, 12:14 PM > Hi Ravi, > > 1. Do you use the PostGIS-Plugin V6.11.6B ? > > 2. Is it possible, that the table already exists > in PostGIS? > > If this table already exists please load it to > OJ and have a look to the SRID-Value. > > Regards > > Uwe > > > RAVI KUMAR schrieb: > > Hi, > > using OJ on Vista. > > 1. getting the error below when I try to save a file > in PostGIS. > > > > java.lang.IllegalStateException: AddGeometryColumn > statement failed: org.postgresql.util.PSQLException: ERROR: > AddGeometryColumns() - invalid SRID > > SELECT AddGeometryColumn( 'postgis', > 'lithologysrid100', 'geometry', 100, > 'GEOMETRY', 2 ) > > at > net.refractions.postgis.PostGISConnection.executeUpdate(PostGISConnection.java:779) > > at > net.refractions.postgis.PostGISConnection.executeUpdate(PostGISConnection.java:1185) > > 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) > > 2. How ever the same is saved when I change SRID > > Layer -> Change SRID Plugin -> SRID=3000 (this I > arrived at by chance) > > > > SRID= 0 or SRID=100, give the above error. > > > > 3. I wish not to project the layer at all.. > > I can save layer as ESRI Shape file but not as > PostGIS data. > > > > Cheers > > > > Ravi > > > > > > _______________________________________________ > > 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
