[SYNCOPE-209] DB Table connector does not see changes in underlying table until restart

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.1-incubating
• Fix Version/s: 1.1.0
• Component/s: core
• Assignee: Francesco Chicchiriccò
• Reporter: Francesco Chicchiriccò
• Created: 10/Sep/12 16:48
• Updated: 04/Apr/13 14:02
• Resolved: 20/Feb/13 11:29

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

Issue Links

• Is contained by: SYNCOPE-319 Provide feature for reloading all connectors