-
15. Re: Re: Re: Re: Re: Re: Re: Re: Re: adding oracle to my vdb
shawkins Nov 5, 2014 9:43 AM (in response to afrieden)> 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 Nov 5, 2014 10:59 AM (in response to shawkins)Is there an example in the vdb to exclude particular tables?
-
17. Re: adding oracle to my vdb
rareddy Nov 5, 2014 11:05 AM (in response to afrieden)1 of 1 people found this helpfulvalue 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.
-
18. Re: Re: adding oracle to my vdb
afrieden Nov 5, 2014 12:41 PM (in response to rareddy)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!
-
mongodb-vdb.xml 1.1 KB
-
server.log.zip 5.1 KB
-
-
19. Re: Re: adding oracle to my vdb
rareddy Nov 5, 2014 1:52 PM (in response to afrieden)1 of 1 people found this helpfulTeiid is saying, the supplied schema "erp" does not have any tables or procedures to import metadata.
-
20. Re: Re: Re: adding oracle to my vdb
afrieden Nov 6, 2014 9:00 AM (in response to rareddy)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>