Uploaded image for project: 'Configuration Persistence Service'
  1. Configuration Persistence Service
  2. CPS-1573

Remove 32K limit for DB operations

XMLWordPrintable

      Repository queries taking collection parameters are limited to 32K collection items. (This is caused by Hibernate PostgreSQL driver having limit of 32767 bind variables per statement.)
      For example, org.onap.cps.spi.repository.FragmentRepository#deleteByAnchorIn:

      @Modifying
      @Query("DELETE FROM FragmentEntity WHERE anchor IN (:anchors)")
      void deleteByAnchorIn(@Param("anchors") Collection<AnchorEntity> anchorEntities);
      

      This would throw an exception if supplied with a collection of 32,768 items.

      This task to remove those limits (and write tests to verify).

            danielhanrahan Daniel Hanrahan
            danielhanrahan Daniel Hanrahan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: