[
https://issues.jboss.org/browse/TEIID-3870?page=com.atlassian.jira.plugin...
]
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)