Postgis attribute Bug in 2.0 RC1

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgis attribute Bug in 2.0 RC1

Amit Kulkarni-5
Hi,

I have a table in PostGIS connection, when I try to edit and save attributes it doesn't save them. When I edit only attributes the "Commit changes"  button doesn't get active.

Thanks
Windows 2000, jre6 update 18, Postgres 8.4.2

_______________________________________________
Kosmo_int mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo_int
Reply | Threaded
Open this post in threaded view
|

Re: Postgis attribute Bug in 2.0 RC1

Sergio Baños Calvo
Good morning, Amit.

Could you send us the Kosmo.log file from the \bin\logs directory of
your Kosmo - Desktop install directory? It'll help us to find which the
problem is.

Regards,

Amit Kulkarni escribió:

> Hi,
>
> I have a table in PostGIS connection, when I try to edit and save
> attributes it doesn't save them. When I edit only attributes the
> "Commit changes"  button doesn't get active.
>
> Thanks
> Windows 2000, jre6 update 18, Postgres 8.4.2
> ------------------------------------------------------------------------
>
> _______________________________________________
> Kosmo_int mailing list
> [hidden email]
> http://lists.saig.es/mailman/listinfo/kosmo_int
>  

--

Sergio Baños Calvo

Jefe de desarrollos
Sistemas Abiertos de Información Geográfica, S.L. (SAIG S.L.)
Tlfno. móvil: 685005960
Tlfno. fijo: (+34) 954788876

E-mail: [hidden email]

_______________________________________________
Kosmo_int mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo_int
Reply | Threaded
Open this post in threaded view
|

Re: Postgis attribute Bug in 2.0 RC1

Amit Kulkarni-5
Hi Sergio,

I figured out the problem I was having. I have to modify the field by doing right click and "selected feature info" and tehn change what field I want to change, then click somewhere else in the same row, this is the only time the commit changes becomes active. This is for attribute only changes.

But the problem exists when the line feature I modify is not properly connected to the other line feature i.e the road feature is not broken correctly. It is connected directly and not at intersection.

Here is the relevant output

19/03/2010 09:25:14  INFO AbstractJDBCDataSource:1894 - /*****************BEGIN TRANSACTION********************/
19/03/2010 09:25:51 ERROR LayerTableModel:234 -
org.saig.core.model.relations.topology.TopologyRelationException: Error: Topology relation Only connected at end points ( roads ) -> Feature [gid (PK) = 7550], [FRADDL=17651], [ZIPR=0], [ROADTYPE=PARISH ROADS], [ROAD_ALIAS=null], [COMMUNITY=SPRINGFIELD], [the_geom=MULTILINESTRING ((-90.57253836903199 30.325302045474295, -90.57193754817021 30.324183406639364))], [FEDIRS=null], [FRADDR=17650], [ROAD_NAME=SCRATCH'S], [FEDIRP=null], [EDITED=AMIT 03/01/2010], [SUBDIV_NAM=null], [ID1=7553], [FETYPE=LN], [TOADDR=17700], [COMMENT=null], [ZIPL=0], [OLD_RDNAME=null], [ESN=205], [TOADDL=17699], [ROAD_LABEL=SCRATCH'S LN], [ID = 171]
    at org.saig.core.model.relations.topology.AbstractTopologyRelation.failure(AbstractTopologyRelation.java:253)
    at org.saig.core.model.feature.FeatureCollectionOnDemand.checkTopologicRelations(FeatureCollectionOnDemand.java:528)
    at org.saig.core.model.feature.FeatureCollectionOnDemand.update(FeatureCollectionOnDemand.java:389)
    at com.vividsolutions.jump.workbench.ui.LayerTableModel.setAttributesOf(LayerTableModel.java:249)
    at com.vividsolutions.jump.workbench.ui.LayerTableModel.access$3(LayerTableModel.java:244)
    at com.vividsolutions.jump.workbench.ui.LayerTableModel$3$1.unexecute(LayerTableModel.java:227)
    at com.vividsolutions.jump.workbench.ui.LayerTableModel$3$1.execute(LayerTableModel.java:221)
    at com.vividsolutions.jump.workbench.ui.LayerTableModel$3.setValue(LayerTableModel.java:230)
    at com.vividsolutions.jump.workbench.ui.LayerTableModel$MyColumn.setValueAt(LayerTableModel.java:94)
    at com.vividsolutions.jump.workbench.ui.ColumnBasedTableModel.setValueAt(ColumnBasedTableModel.java:153)
    at javax.swing.JTable.setValueAt(Unknown Source)
    at javax.swing.JTable.editingStopped(Unknown Source)
    at javax.swing.AbstractCellEditor.fireEditingStopped(Unknown Source)
    at javax.swing.DefaultCellEditor$EditorDelegate.stopCellEditing(Unknown Source)
    at javax.swing.DefaultCellEditor.stopCellEditing(Unknown Source)
    at javax.swing.JTable$GenericEditor.stopCellEditing(Unknown Source)
    at javax.swing.plaf.basic.BasicTableUI$Handler.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
    at java.awt.Component.processMouseEvent(Unknown Source)
    at javax.swing.JComponent.processMouseEvent(Unknown Source)
    at java.awt.Component.processEvent(Unknown Source)
    at java.awt.Container.processEvent(Unknown Source)
    at java.awt.Component.dispatchEventImpl(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
    at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
    at java.awt.Container.dispatchEventImpl(Unknown Source)
    at java.awt.Window.dispatchEventImpl(Unknown Source)
    at java.awt.Component.dispatchEvent(Unknown Source)
    at java.awt.EventQueue.dispatchEvent(Unknown Source)
    at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
    at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
    at java.awt.EventDispatchThread.run(Unknown Source)


Thanks

2010/3/18 Sergio Baños Calvo <[hidden email]>
Good morning, Amit.

Could you send us the Kosmo.log file from the \bin\logs directory of your Kosmo - Desktop install directory? It'll help us to find which the problem is.

Regards,

Amit Kulkarni escribió:
Hi,

I have a table in PostGIS connection, when I try to edit and save attributes it doesn't save them. When I edit only attributes the "Commit changes"  button doesn't get active.

Thanks
Windows 2000, jre6 update 18, Postgres 8.4.2
------------------------------------------------------------------------

_______________________________________________
Kosmo_int mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo_int
 

--

Sergio Baños Calvo

Jefe de desarrollos
Sistemas Abiertos de Información Geográfica, S.L. (SAIG S.L.)
Tlfno. móvil: 685005960
Tlfno. fijo: (+34) 954788876

E-mail: [hidden email]

_______________________________________________
Kosmo_int mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo_int


_______________________________________________
Kosmo_int mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo_int
Reply | Threaded
Open this post in threaded view
|

Re: Postgis attribute Bug in 2.0 RC1

Sergio Baños Calvo
Good morning Amit.

The problem is caused by the topology rule that have been set at the
layer (Only connected at end points): I think you have set the rule but
you haven't assure that the initial data is correct, so we you change
the attribute for one of the wrong roads, the topology rule is aborting
the change, so the "Save changes" button is not being activated.

Could you check the layer to see if this is true?

Regards,

Amit Kulkarni escribió:

> Hi Sergio,
>
> I figured out the problem I was having. I have to modify the field by
> doing right click and "selected feature info" and tehn change what
> field I want to change, then click somewhere else in the same row,
> this is the only time the commit changes becomes active. This is for
> attribute only changes.
>
> But the problem exists when the line feature I modify is not properly
> connected to the other line feature i.e the road feature is not broken
> correctly. It is connected directly and not at intersection.
>
> Here is the relevant output
>
> 19/03/2010 09:25:14  INFO AbstractJDBCDataSource:1894 -
> /*****************BEGIN TRANSACTION********************/
> 19/03/2010 09:25:51 ERROR LayerTableModel:234 -
> org.saig.core.model.relations.topology.TopologyRelationException:
> Error: Topology relation Only connected at end points ( roads ) ->
> Feature [gid (PK) = 7550], [FRADDL=17651], [ZIPR=0], [ROADTYPE=PARISH
> ROADS], [ROAD_ALIAS=null], [COMMUNITY=SPRINGFIELD],
> [the_geom=MULTILINESTRING ((-90.57253836903199 30.325302045474295,
> -90.57193754817021 30.324183406639364))], [FEDIRS=null],
> [FRADDR=17650], [ROAD_NAME=SCRATCH'S], [FEDIRP=null], [EDITED=AMIT
> 03/01/2010], [SUBDIV_NAM=null], [ID1=7553], [FETYPE=LN],
> [TOADDR=17700], [COMMENT=null], [ZIPL=0], [OLD_RDNAME=null],
> [ESN=205], [TOADDL=17699], [ROAD_LABEL=SCRATCH'S LN], [ID = 171]
>     at
> org.saig.core.model.relations.topology.AbstractTopologyRelation.failure(AbstractTopologyRelation.java:253)
>     at
> org.saig.core.model.feature.FeatureCollectionOnDemand.checkTopologicRelations(FeatureCollectionOnDemand.java:528)
>     at
> org.saig.core.model.feature.FeatureCollectionOnDemand.update(FeatureCollectionOnDemand.java:389)
>     at
> com.vividsolutions.jump.workbench.ui.LayerTableModel.setAttributesOf(LayerTableModel.java:249)
>     at
> com.vividsolutions.jump.workbench.ui.LayerTableModel.access$3(LayerTableModel.java:244)
>     at
> com.vividsolutions.jump.workbench.ui.LayerTableModel$3$1.unexecute(LayerTableModel.java:227)
>     at
> com.vividsolutions.jump.workbench.ui.LayerTableModel$3$1.execute(LayerTableModel.java:221)
>     at
> com.vividsolutions.jump.workbench.ui.LayerTableModel$3.setValue(LayerTableModel.java:230)
>     at
> com.vividsolutions.jump.workbench.ui.LayerTableModel$MyColumn.setValueAt(LayerTableModel.java:94)
>     at
> com.vividsolutions.jump.workbench.ui.ColumnBasedTableModel.setValueAt(ColumnBasedTableModel.java:153)
>     at javax.swing.JTable.setValueAt(Unknown Source)
>     at javax.swing.JTable.editingStopped(Unknown Source)
>     at javax.swing.AbstractCellEditor.fireEditingStopped(Unknown Source)
>     at
> javax.swing.DefaultCellEditor$EditorDelegate.stopCellEditing(Unknown
> Source)
>     at javax.swing.DefaultCellEditor.stopCellEditing(Unknown Source)
>     at javax.swing.JTable$GenericEditor.stopCellEditing(Unknown Source)
>     at
> javax.swing.plaf.basic.BasicTableUI$Handler.mousePressed(Unknown Source)
>     at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
>     at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
>     at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
>     at java.awt.AWTEventMulticaster.mousePressed(Unknown Source)
>     at java.awt.Component.processMouseEvent(Unknown Source)
>     at javax.swing.JComponent.processMouseEvent(Unknown Source)
>     at java.awt.Component.processEvent(Unknown Source)
>     at java.awt.Container.processEvent(Unknown Source)
>     at java.awt.Component.dispatchEventImpl(Unknown Source)
>     at java.awt.Container.dispatchEventImpl(Unknown Source)
>     at java.awt.Component.dispatchEvent(Unknown Source)
>     at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
>     at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
>     at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
>     at java.awt.Container.dispatchEventImpl(Unknown Source)
>     at java.awt.Window.dispatchEventImpl(Unknown Source)
>     at java.awt.Component.dispatchEvent(Unknown Source)
>     at java.awt.EventQueue.dispatchEvent(Unknown Source)
>     at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
>     at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
>     at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
>     at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>     at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
>     at java.awt.EventDispatchThread.run(Unknown Source)
>
>
> Thanks
>
> 2010/3/18 Sergio Baños Calvo <[hidden email] <mailto:[hidden email]>>
>
>     Good morning, Amit.
>
>     Could you send us the Kosmo.log file from the \bin\logs directory
>     of your Kosmo - Desktop install directory? It'll help us to find
>     which the problem is.
>
>     Regards,
>
>     Amit Kulkarni escribió:
>
>         Hi,
>
>         I have a table in PostGIS connection, when I try to edit and
>         save attributes it doesn't save them. When I edit only
>         attributes the "Commit changes"  button doesn't get active.
>
>         Thanks
>         Windows 2000, jre6 update 18, Postgres 8.4.2
>         ------------------------------------------------------------------------
>
>         _______________________________________________
>         Kosmo_int mailing list
>         [hidden email] <mailto:[hidden email]>
>         http://lists.saig.es/mailman/listinfo/kosmo_int
>          
>
>
>     --
>
>     Sergio Baños Calvo
>
>     Jefe de desarrollos
>     Sistemas Abiertos de Información Geográfica, S.L. (SAIG S.L.)
>     Tlfno. móvil: 685005960
>     Tlfno. fijo: (+34) 954788876
>
>     E-mail: [hidden email] <mailto:[hidden email]>
>
>     _______________________________________________
>     Kosmo_int mailing list
>     [hidden email] <mailto:[hidden email]>
>     http://lists.saig.es/mailman/listinfo/kosmo_int
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Kosmo_int mailing list
> [hidden email]
> http://lists.saig.es/mailman/listinfo/kosmo_int
>  

--

Sergio Baños Calvo

Jefe de desarrollos
Sistemas Abiertos de Información Geográfica, S.L. (SAIG S.L.)
Tlfno. móvil: 685005960
Tlfno. fijo: (+34) 954788876

E-mail: [hidden email]

_______________________________________________
Kosmo_int mailing list
[hidden email]
http://lists.saig.es/mailman/listinfo/kosmo_int