Hi Francesco, you did it before me. I was suspecting the issue happen after the first time. Many thanks thanks, Denis
-----Messaggio originale----- Da: Francesco Chicchiriccò [mailto:[email protected]] Inviato: lunedì 10 settembre 2012 18.49 A: [email protected] Oggetto: Re: Allow Connector update the database schema without restart On 10/09/2012 16:01, Francesco Chicchiriccò wrote: On 10/09/2012 09:38, Denis Signoretto wrote: Hi Francesco, probably yes it could be an issue related to ConnId Table Connector. If you alter a table, for instance adding a column, and you try to update schema mapping on a existing resource the structure of the table it's not reread and the new column cannot be associated until a JVM restart (this is the only solution I've found). Denis, I've run the following procedure: 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 At this point: 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)' Then: 1. log in http://localhost:9080/syncope-console/ 2, go to resources -> resource-testdb -> mapping The column "NEWCOL" is there when adding a new mapping, hence I am not able to reproduce what you say above. Is this the kind of result you are looking for? Actually, "NEWCOL" is the only column available (because the other 3 columns are mapped to special ConnId attributes) and this makes the console to show NEWCOL everywhere. I am going to open an issue for this (probably related to SYNCOPE-207). Hi Denis, I've finally been able to reproduce your issue: just execute the last two steps (e.g. looking at console's resource mapping) right after start (mvn -P embedded), then follow the steps reported above, including the last 2. I've also made some pure-ConnId tests and everything works fine, hence it's Syncope's not ConnId's. I've created SYNCOPE-209 for this. Regards. -----Messaggio originale----- Da: Francesco Chicchiriccò [ mailto:[email protected]] Inviato: sabato 8 settembre 2012 20.41 A: [email protected] Oggetto: Re: Allow Connector update the database schema without restart On 30/07/2012 09:41, Denis Signoretto wrote: Hi Syncopers, at the moment if an external resource schema changes (e.g. column added or renamed), the DB connector, can't see the changes until a Syncope restart (I'm wrong?). As a future improvement what do you think about a "db schema update" functionality for DB connector? Hi Denis, sorry, I've completely overlooked this e-mail (it was archived in the wrong mail thread...): could you please describe with some more detail the feature you are looking for? I suspect this is more ConnId's than Syncope's... Regards. -- Francesco Chicchiriccò ASF Member, Apache Cocoon PMC and Apache Syncope PPMC Member http://people.apache.org/~ilgrosso/
