gvSIG bugs #2114

Error restoring Feature from FeatureReference of JDBC source with a null value in pk

Added by Jose Manuel Vivó Arnal over 12 years ago. Updated over 12 years ago.

Status:Closed% Done:

0%

Priority:NormalSpent time:-
Assignee:Joaquín del Cerro Murciano
Category:Database
Target version:2.1.0-2217-devel
Severity: Add-on version:
gvSIG version:2.0.0 Add-on build:
gvSIG build:2066 Add-on resolve version:
Operative System: Add-on resolve build:
Keywords: Proyecto:
Has patch:Yes Hito:
Add-on name:Unknown

Description

When I've try to create a Feature instance from a FeatureReference I get a RuntimeException("Reference Not found").

After debug code, I've found that generated sql uses an invalid expression for a null value ("field = null") when it tries to locate the referred record if one of the pk-values is null.

This path modify JDBCStoreProvider to generate a expression "field is null" for null values.

Also, fixes a problem that makes that pk fields were added multiple times on select clause.

fixes_restore_feature_from_reference_with_null_value_in_pk.patch Magnifier (1.91 KB) Jose Manuel Vivó Arnal, 11/18/2013 03:46 PM

Associated revisions

Revision 40916
Added by Joaquín del Cerro Murciano over 12 years ago

refs #2114, Error restoring Feature from FeatureReference of JDBC source with a null value in pk

History

#1 Updated by Joaquín del Cerro Murciano over 12 years ago

  • Assignee set to Joaquín del Cerro Murciano

#2 Updated by Joaquín del Cerro Murciano over 12 years ago

  • Status changed from New to Fixed
  • Target version set to 2.1.0-2223-rc1

#3 Updated by Joaquín del Cerro Murciano over 12 years ago

  • Target version changed from 2.1.0-2223-rc1 to 2.1.0-2217-devel

#4 Updated by Álvaro Anguix over 12 years ago

  • Status changed from Fixed to Closed

Also available in: Atom PDF