Update of top-level data node fails with SQL error 64/135764/4
authordanielhanrahan <daniel.hanrahan@est.tech>
Thu, 17 Aug 2023 14:43:34 +0000 (15:43 +0100)
committerDaniel Hanrahan <daniel.hanrahan@est.tech>
Thu, 17 Aug 2023 15:17:15 +0000 (15:17 +0000)
commit996d0c2b23a70e62853632f0b644b3fe4d212143
treeb9f1dfb76dcae12074cf5fd42a553189af6f651b
parenta52b1825f99318181cd356dcde1b1db46c1098ac
Update of top-level data node fails with SQL error

The error is caused by the fetch-descendants code using
ResultSet.getLong which returns a 'long' primitive instead
of a 'Long' object. Thus a parent ID of 'NULL' becomes '0',
which causes an error during update. To preserve the NULL
value, ResultSet.getObject must be used.

Issue-ID: CPS-1841
Signed-off-by: danielhanrahan <daniel.hanrahan@est.tech>
Change-Id: Ida6837a04954cd3c23f0f2faabd7d0712d8ee19d
cps-ri/src/main/java/org/onap/cps/spi/repository/FragmentPrefetchRepositoryImpl.java
docs/release-notes.rst
integration-test/src/test/groovy/org/onap/cps/integration/functional/CpsDataServiceIntegrationSpec.groovy