1 2 Previous Next 20 Replies Latest reply on Nov 6, 2014 9:00 AM by afrieden Go to original post
      • 15. Re: Re: Re: Re: Re: Re: Re: Re: Re: adding oracle to my vdb
        shawkins

        > I would rather not change versions unless there was a particular reason to.

         

        8.9 will show the full stack trace.

         

        > The trace was logged in my previous server.log.

         

        I couldn't see any further details in your attachments related to this.

         

        > Is there a way to just exclude the AUDIT_ACTIONS table? 

         

        If you have determined that this is where the issue is, or just in general yes you can exclude it. Presumably it's in the SYS schema, if you don't need any of that schema or need just to just import a specific schema, then use the importer.schemaPattern.  You can also use the importer.excludeTables regex - see JDBC Translator - Teiid 8.9 (draft) - Project Documentation Editor

        • 16. Re: adding oracle to my vdb
          afrieden

          Is there an example in the vdb to exclude particular tables?

          • 17. Re: adding oracle to my vdb
            rareddy

            value like "importer.excludeTables = AUDIT_ACTIONS" will be suffice. If you want to import just your schema (which is what you need to do in most cases) use like "importer.schemaPattern=myschema" that will exclude all SYS and other tables out.

            1 of 1 people found this helpful
            • 18. Re: Re: adding oracle to my vdb
              afrieden

              Thanks again both of you for your insight.  From the logs it appears that it can find the database but there is a problem with my model.  I have attached my vdb file and my server log.  What am I doing wrong here?  Thanks!

              • 19. Re: Re: adding oracle to my vdb
                rareddy

                Teiid is saying, the supplied schema "erp" does not have any tables or procedures to import metadata.

                1 of 1 people found this helpful
                • 20. Re: Re: Re: adding oracle to my vdb
                  afrieden

                  Fixed finally!  Thanks guys!

                   

                  Here is how I solved it, added these to my model:

                   

                          <model name="erp">
                                  <property name="importer.useFullSchemaName" value="true"/>
                                  <property name="importer.tableTypes" value="TABLE,VIEW"/>
                                  <property name="importer.schemaPattern" value="MY-SCHEMA" /> <!-- MY-SCHEMA is case sensitive-->
                                  <property name="importer.includeSynonyms" value="true" />
                                  <source name="oracle" translator-name="oracle" connection-jndi-name="java:/OracleDS"/>
                          </model>
                  
                  1 2 Previous Next