[teiid-issues] [JBoss JIRA] (TEIID-2578) add/remove schema elements

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2578?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13309010#comment-13309010 ] 

Steven Hawkins commented on TEIID-2578:
---------------------------------------

> With this we are some what similar to other databases.

To an extent.  You loose ease of use of metadata reload in the import schema case.  That is something we could workaround by adding a high-level operation that drops all the objects of the schema, then reruns the import as part of a "restart" operation.  

However we are fundamentally breaking the expectations of the vdb reuse feature.  The reuse here is now only at the time of the import statement - any further changes to the imported vdb require a manual process on the part of the user to incorporate into all importing vdbs.  I don't see a simple workaround here since the load operation from the databasestore assumes everything is fully realized and in a valid state.  The load will need some work in general as any issue with any vdb load will cause the whole load to be aborted.

> They should work

Not yet, they require a RuntimeVDB acquired from the VDBService, which is not associated with a DDL based VDB. 

> I see the benefits of deployment and repository based vdbs, we need to articulate both positions in examples and documents to choose what is better for the user.

I'm a little uncomfortable with that if it means they have different capabilities/behavior.



> add/remove schema elements
> --------------------------
>
>                 Key: TEIID-2578
>                 URL: https://issues.jboss.org/browse/TEIID-2578
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Query Engine
>            Reporter: Ramesh Reddy
>            Assignee: Ramesh Reddy
>             Fix For: 9.2
>
>
> Schemas are currently static after load.  Modifications can only happen with restarts or new versions.  We should allow add/drop at runtime.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)