[teiid-issues] [JBoss JIRA] (TEIID-3870) Add ability to properly qualify package objects

[Van Halbert (JIRA)]

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

Van Halbert commented on TEIID-3870:
------------------------------------

Can you explain how to use the JDBC api database metadata to get objects in packages?

To my knowledge, there is no current way, using the JDBC api metadata, to get a list of packages and then obtain of list of objects within each package.   To do this, you must query the system tables.         

> Add ability to properly qualify package objects
> -----------------------------------------------
>
>                 Key: TEIID-3870
>                 URL: https://issues.jboss.org/browse/TEIID-3870
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>    Affects Versions: 8.7.1.6_2
>         Environment: Red Hat JBoss Data Virtualization 6.2 on EAP6.4.0 patched to version 6.4.3,
> JBoss Developer Studio 8.1.0GA with Teiid Designer plugin 9.0.3.Final.v20150810-1438-B1157
> 64-bit Windows 7 environment
>            Reporter: Steve Tran
>            Assignee: Steven Hawkins
>             Fix For: 8.13, 8.12.4
>
>
> Even if the catalog name pattern matches package names, there is no option or recognition that contained procedures should be qualified as <package / catalog>.<name>.
> We need this because at least in Oracle, procedures may be encapsulated in Oracle Packages that are used as catalog names in the DatabaseMetaData.  When trying to import these into Teiid, the "Name in Source" field does not allow me to specify the Package name, so I can't call those procedures.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)