[teiid-issues] [JBoss JIRA] (TEIID-5963) Teiid imported all schemas from PG

[Ramesh Reddy (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14133347#comment-14133347 ] 

Ramesh Reddy commented on TEIID-5963:
-------------------------------------

> Can we set properties (or make beans config) in spring boot app to change this behavior?

You can disable loading metadata from data source, but for that you need to remove 

{code}
IMPORT FOREIGN SCHEMA manual_loads FROM SERVER pgserver INTO schpostgresql OPTIONS("importer.useFullSchemaName" 'false', "importer.tableTypes" 'TABLE,VIEW');
{code}

and then replace it with all the table definitions that represent your PG database statically.

I have not seen your confirmation from you for [~shawkins] question that is in fact type info which is taking long (am I reading wrong?). Second, why not also try disabling the retrieving type info as suggested to see if it improves things? for that you need to set 
{code}
importer.widenUnsignedTypes = false
{code}
on the vdb. 

Also can you update the version to `1.5.1` instead of `1.5.0` as I made couple enhancements with property handling.


> Teiid imported all schemas from PG
> ----------------------------------
>
>                 Key: TEIID-5963
>                 URL: https://issues.redhat.com/browse/TEIID-5963
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 14.0
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>
> When we started teiid spring boot app, we have long start time.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)