GeoTools
  1. GeoTools
  2. GEOT-4525

JDBCAccessPGRaster - updating mosaic extent/resolutions table

    Details

      Description

      I have noticed that the JDBCAccessPGRaster class does some initialization steps where it looks for overviews (ImageLevelInfo) extents and resolutions.

      Then it setup values for preparedStatement to do updates of resolutoins and extent within the MOSAIC table (which contains the name of the coverage, the name of the table containing a specific level, extent and resolution).

      However, I see that line 116 contains a "con.commit();" being commented-out.
      Therefore, no fields are updated into the DB since no commit occurs.(moreover, line 109 set autocommit fo talse).

      Had some synch up with Christian which suggested to out-comment that.
      Trying it, things stopped working and this is why:

      if out-commented, the statementMap map is empty (since it isn't updated due to resolutions and extents being known in advance).
      This result into errors when starting tile decoders which are taking the gridStatement from the statementMap.

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            Christian Mueller
            Reporter:
            Daniele Romagnoli
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: