1 Reply Latest reply on Sep 17, 2013 6:10 PM by lawrence jesu

    Is Teiid having any Functions to read key value of properties file?

    lawrence jesu Newbie


      Hi,

              I do have all connection perameters in Properties file. Is there any way to read and connect those details TEIID VDB and reading other key value pairs thro

      teiid function.

       

       

      Thanks

      Lawrence

        • 1. Re: Is Teiid having any Functions to read key value of properties file?
          lawrence jesu Newbie

          Hi,

              Some more details on this question. I am able to retrieve connection object informations such as user and VDB name by running the following query in Teiid. ( Select USER(), Select CURRENT_DATABASE() )  I want set some more properties in connection object and be able to retrive them in TEIID in same way i get USER and DATABASE Name.

           

                     Is there any way to set additional properties in connection object and retrieve them in TEIID designer?

                     Is any way to retrieve URL property  from below connection object from TEIID designer?

                         String url = "jdbc:teiid:GFA_IRD@mm://localhost:31000";

                              connection = DriverManager.getConnection(url, "user", "user");


           

          Thanks

          lawrence