5 Replies Latest reply on Dec 9, 2012 4:20 AM by rakeshsagar

    Re-Fetching teiid metadata

    rakeshsagar

      Hi,

       

      The normal process of fetching metadata for a model is that the getMetadata() is called when the vdb is deployed.

      Now during the VDB deployment if we are unable to connect to the datasource we are adding some dummy metadata to that model so that the VDB is Active and we can access the other models in the VDB.

       

      Is there a way to tell teiid that the data source is available now and please re-fetch the metadata for that particular model?

      One way to do this is to recycle JBoss so that the vdb is redeployed. We do not want to recycle JBoss and have a mechanism by which we can re-fetch the metadata for that model and after this is done we should ne able to fetch the data from that model.

       

      Please suggest.

       

      Thanks

      Rakesh.

        • 1. Re: Re-Fetching teiid metadata
          rareddy

          with 8.2, the VDB deployment gets delayed until the data source is available. If available but fails to fetch metadata then it would be in not valid state, that requires a re-deployment.

          • 2. Re: Re-Fetching teiid metadata
            shawkins

            You can modify view/procedure definitions via alters, but unfortunately you cannot modify the structual metadata of a running vdb.  A full redeploy is not necessary as you could use the vdb restart operation, but that, like a redeployment, will stop any active sessions against the vdb.

             

            Steve

            • 3. Re: Re-Fetching teiid metadata
              rakeshsagar

              Thanks for the responses Ramesh/Steve.

               

              The only option rught now is to redeploy the vdb.

               

              Can I open a JIRA issue for a feature request for this functionality??

               

              Thanks

              Rakesh

              • 4. Re: Re-Fetching teiid metadata
                rareddy

                It is a limitation of VDB deployment model that Teiid has, there is not much more we can do on that part until Teiid supports full range of DDL, like create/alter views ad-hoc during the runtime like traditional RDBMS.

                 

                Restart is your best choice for now, as it can reload that particular model, where as re-deploy would load the all the models in the VDB.

                 

                So no for the JIRA.

                 

                Ramesh..

                • 5. Re: Re-Fetching teiid metadata
                  rakeshsagar

                  Thanks Ramesh.