1 Reply Latest reply on Jan 22, 2013 10:29 AM by Steven Hawkins

    How to access synonym via teiid

    jaigates vg Newbie

      Hi

      i am trying to configure/setup Teeid 7.7.1(deployed in jboss soa 5.3) to acess my oracle 11 tables(employee) via synonyms(employee_syn). After creating necessary datasource file, vdb file,i am able to fetch the table via select query (select * from employee) using teeid client but when i try to do select on synonym(select * from employee_syn) i am getting below exception.

      Pls let me know how to access my tables via synonym in Teeid.

       

      ---- vdb file -----

      <vdb name="sample_1" version="1">

      <property name="UseConnectorMetadata" value="true" />

      <model name="sample_1">  

      <property name="importer.useFullSchemaName" value="false"/>

      <property name="importer.tableTypes" value="TABLE,VIEW"/>

      <property name="importer.schemaPattern" value="user"/>

      <source name="oracle-connector" translator-name="oracle" connection-jndi-name="java:/1-local-oracleDS"/>

      </model>

      </vdb>

       

       

      --- ds file ----

      <datasources>

         <local-tx-datasource>

            <user-name>user</user-name>

            <password>password</password>

            <connection-property name="includeSynonyms">true</connection-property>

            <jndi-name>1-local-oracleDS</jndi-name>

            <connection-url>jdbc:oracle:thin:@localhost:1521/XE</connection-url>

            <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

            <min-pool-size>5</min-pool-size>

            <max-pool-size>20</max-pool-size>

            <idle-timeout-minutes>0</idle-timeout-minutes>

            <track-statements/>

            <prepared-statement-cache-size>32</prepared-statement-cache-size>

            <metadata>

               <type-mapping>Oracle9i</type-mapping>

            </metadata>

         </local-tx-datasource>

      </datasources>

       

       

      --- exception ----

      group employee_syn not found