gvSIG bugs #2858

Fields of type Float have an invalid value in PostGIS layers

Added by Antonio Falciano over 9 years ago. Updated about 9 years ago.

Status:Closed% Done:

0%

Priority:HighSpent time:-
Assignee:José Badía
Category:Database
Target version:2.2.0-2302 (rev. org.gvsig.desktop-2.0.89)
Severity:Major Add-on version:
gvSIG version:2.1.0 Add-on build:
gvSIG build:2248 Add-on resolve version:
Operative System: Add-on resolve build:
Keywords:geodb, postgis, invalid, pattern Proyecto:
Has patch: Hito:
Add-on name:Unknown

Description

The "Info by point" tool reports that the fields of Float type have an invalid value in PostGIS layers.
If I open the table properties I see that the fields of Float type are read with length 131089 and precision 0.
Consider that the fields are declared of numeric type in PostGIS.
Related to #2694.

invalid_value_postgis.png (108 KB) Antonio Falciano, 10/08/2014 12:50 PM

table_properties_postgis.png (19.1 KB) Antonio Falciano, 10/08/2014 12:50 PM

1072
1073

Related issues

Related to Application: gvSIG desktop - gvSIG bugs #2694: Numeric types management of PostGIS tables Closed 07/21/2014

Associated revisions

Revision 42041
Added by José Badía about 9 years ago

fixes #2694, #2858
Numeric types management of PostGIS tables
Fields of type Float have an invalid value in PostGIS layers

History

#1 Updated by Álvaro Anguix over 9 years ago

#2 Updated by Antonio Falciano over 9 years ago

This issue is still present in the RC3.

#3 Updated by Álvaro Anguix about 9 years ago

  • Target version set to 2.2.0-2311-rc2
  • Assignee set to José Badía

#4 Updated by Joaquín del Cerro Murciano about 9 years ago

Añado este comentario de cara a desarrolo.

El codigo que puede verse afectado por estas correcciones deberia estar en el proyecto:

https://redmine.gvsig.net/redmine/projects/gvsig-postgresql

Habria que evaluar si se corrige ahi, o si es interesante elevar las correcciones a las clases de las se extiende en ese proyecto, que son las genericas de JDBC.
La parte de acceso a datos generica de JDBC esta en el core de gvSIG, en el proyecto del redmine:

https://redmine.gvsig.net/redmine/projects/gvsig-desktop

En:

org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc

#5 Updated by José Badía about 9 years ago

  • Status changed from New to Fixed

Finally modified JDBCHelper class at gvSIG core.
Fixed conflicted types to Double if it isn't enough, please reopen the ticket

#6 Updated by Joaquín del Cerro Murciano about 9 years ago

  • Target version changed from 2.2.0-2311-rc2 to 2.2.0-2302 (rev. org.gvsig.desktop-2.0.89)

#7 Updated by Álvaro Anguix about 9 years ago

  • Status changed from Fixed to Closed

Also available in: Atom PDF