1 Reply Latest reply on Jan 17, 2017 9:00 AM by Ramesh Reddy

    Oracle connection VDB stays in Loading state when added support to execute direct query procedure

    Kulbhushan Chaskar Master

      I am trying to deploy VDB for a oracle connection to support "SupportsDirectQueryProcedure" property.

      My VDB file look like:

       

      <?xml version="1.0" ?><vdb name="SvcSourceVdb_oracleTest" version="1"><description>VDB for: SvcSourceVdb_oracleTest, Version: 1</description><connection-type>BY_VERSION</connection-type><property name="deployment-name" value="SvcSourceVdb_oracleTest-vdb.xml"></property><model name="oracleTest" type="PHYSICAL" visible="true"><property name="importer.tableTypes" value="TABLE"></property><property name="importer.schemaPattern" value="USERNAME"></property><source name="oracleTest" translator-name="oracle" connection-jndi-name="java:/DSORACLE20161216223832036"></source></model><model name="oracleTestNative" type="PHYSICAL" visible="true"><source name="oracleTestNative" translator-name="oracle-native" connection-jndi-name="java:/DSORACLE20161216223832036"></source></model><translator name="oracle-native" type="oracle"><property name="SupportsDirectQueryProcedure" value="true"></property></translator></vdb>

       

      It stays in Loading state for longer time and after it return VDB status as failed.

       

      When I remove model "oracleTestNative" then it work fine.... i.e. VDB gets activated after some time of deployment.

       

      Note: I am using teiid 8.13

       

      Thanks,

      Kulbhushan Chaskar