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

Reply via email to