[teiid-issues] [JBoss JIRA] (TEIID-5473) Make JDBCMetadataProcessor more extensible with protected methods

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13634520#comment-13634520 ] 

Steven Hawkins commented on TEIID-5473:
---------------------------------------

There is a getIndexInfoForTable protected method that needs a better java doc that should suffice.  If you override it you just need to return false to suppress the default logic from running.  If overriding that method can suffice, then I'll add an analogous method for foreign keys as well.

Ivan was using the progress driver for which there is the kb article: https://knowledgebase.progress.com/articles/Article/Calls-using-getImportedKeys-and-getExportedKeys-are-slow-with-the-Connect-for-JDBC-Oracle-driver

For the regular driver we've seen that useFetchSizeWithLongColumn=true https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html can improve things as well.





> Make JDBCMetadataProcessor more extensible with protected methods
> -----------------------------------------------------------------
>
>                 Key: TEIID-5473
>                 URL: https://issues.jboss.org/browse/TEIID-5473
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>    Affects Versions: 11.1
>            Reporter: Ken Geis
>            Assignee: Steven Hawkins
>             Fix For: 11.2
>
>
> I believe I can write a JDBCMetadataProcessor that works faster against my Oracle database. The important part to override is in getIndexes(..). This method is package-private, so I cannot override it. It would be useful to me if the method (and maybe others) were made protected so that they can be overridden.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)