Description of problem: At first, I can create a sourcemodel based on VDB. See attached screenshot named import_by_jdbc_teiid_connection1.png. I'll call this sourcemodel like "imported VDB as source model". Although imported relational db as sourcemodel can be updated using a "Create source model for JDBC data source" wizard provided by Teiid Designer, imported VDB as sourcemodel can not be updated. This is the instruction to updated imported relational db as sourcemodel. 1: create VDB which has a sourcemodel for relational db 2: deploy VDB 3: update schema for relational db like: ALTER TABLE person ADD COLUMN name varchar(20); 4: start "Create source model for JDBC data source" wizard 5: mark the check box named "Update(if existing model selected) check box" Screenshot is attached as import_by_jdbc_connection.png 6: finish up the wizard. When I try to update an imported VDB as source model, I can't mark the check box named "Update(if existing model selected) check box". Screenshot is attached as import_by_jdbc_teiid_connection2.png Steps to Reproduce: 1. create a VDB 2. create another VDB which has a sourcemodel based on the VDB created at step 1 3. modify VDB created at step 1 4. using "Create source model for JDBC data source", update VDB created at step 2 Actual results: User can not mark the check box named "Update(if existing model selected) check box" Expected results: User can mark the check box named "Update(if existing model selected) check box", and can update a VDB. Additional info: I used Teiid Designer 8.3.2.Final-v20140328-2123-B54
Created attachment 896195 [details] import_by_jdbc_connection.png
Created attachment 896196 [details] import_by_jdbc_teiid_connection1.png
Created attachment 896197 [details] import_by_jdbc_teiid_connection2.png
Steven Hawkins <shawkins> updated the status of jira TEIID-2982 to Closed
The checkbox "Update (if existing model selected)" is still disabled. In org.teiid.designer.jdbc.ui.wizards.JdbcImportOptionsPage.java, there is: if( this.importer.isVdbSourceModel() ) { .. this.updateCheckBox.setEnabled(false); .. }
I was talking to Barry about this and from the TD point of view this a correct behavior. If you import from Teiid VDB the checkbox is disabled on purpose.
The Teiid engine provided the feature to override the visibility. Why is designer not enabling that option? By default being "false" is fine. But it should allow the use to change the visibility after importing.
I am not sure if this issue has something to do with visibility. This might a question for Barry.
The Import VDB Designer support was limited to allowing users to import source models from deployed VDBs via JDBC. These VDB Source Models are treated as read-only and can be used as any other source. The Import VDB come into play when adding your view models to your VDB. Any reference to a VDB Source Model will be interpreted as an ImportVDB and the source model will NOT be added to the VDB. The description of this BZ indicated the user expected to be able to "re-import" a VDB Source Model. When we designed this feature, we decided to treat the imported model as read-only since it represented the "schema" for a model in a specific VDB on the server. As addition to the read-only state of the model, we disabled the ability to "update" the source model and required users to delete their VDB source model first, then re-import it from their "changed" VDB.
According to Barry's comment this is not a bug.