Uploaded image for project: 'Syncope'
  1. Syncope
  2. SYNCOPE-209

DB Table connector does not see changes in underlying table until restart

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.1-incubating
    • Fix Version/s: 1.1.0
    • Component/s: core
    • Labels:
      None

      Description

      Steps to reproduce:

      1. generate a project from 1.0.2-incubating-SNAPSHOT or 1.1.0-incubating-SNAPSHOT archetypes (both tested)
      2. mvn clean package
      3. cd console && mvn -P embedded

      1. log in http://localhost:9080/syncope-console/
      2, go to resources -> resource-testdb -> mapping

      1. go to http://localhost:9082
      2. select "Generic H2 (Server)"
      3. set JDBC URL to "jdbc:h2:tcp://localhost:9092/testdb"
      4. set username 'sa' and password 'sa'
      5. connect
      6. send SQL statement 'ALTER TABLE TEST ADD COLUMN newcol VARCHAR(255)'

      1. log in http://localhost:9080/syncope-console/
      2, go to resources -> resource-testdb -> mapping

      At this point, when trying to add a new schema mapping, 'newcol' is not shown among available values until restart

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                ilgrosso Francesco Chicchiriccò
                Reporter:
                ilgrosso Francesco Chicchiriccò
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: