[
https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu...
]
Barry LaFond commented on TEIIDDES-2751:
----------------------------------------
Van's investigation shows that an Oracle 11 BQT2 test DB has some packages defined.
using a jdbc metadata.getCatalogs() call returns a result set but has not next() (==
false). Also, any supportsCatalogsXXXXX() method returns false.
Oracle documentation did define some specific queries to perform to obtain the package
data:
(01:30:55 PM) vhalbert: select object_name, object_type from user_objects where
object_type in ( 'PACKAGE', 'PACKAGE BODY' )
(01:31:11 PM) vhalbert: run that, it will give u the packages for what u have access
(01:33:19 PM) vhalbert: select distinct object_name from user_arguments where
package_name='DUMMY';
(01:33:44 PM) vhalbert: that gives u the unique objects in the package
(01:33:55 PM) vhalbert: select * from user_arguments where package_name='DUMMY';
(01:34:05 PM) vhalbert: will give u the arguments
I performed these queries in SQuirreL and it showed this information correctly.
Current Designer JDBC importer's JdbcDatabaseImpl does not yet have any
vendor-specific logic or mechanism to inject it. Seems like we'd maybe need to add an
OracleJdbcPackage that extended JdbcCatalogImpl and captured procedure/function children
only as metadata that users could select.
Add ability to import Oracle Packages via JDBC Import
-----------------------------------------------------
Key: TEIIDDES-2751
URL:
https://issues.jboss.org/browse/TEIIDDES-2751
Project: Teiid Designer
Issue Type: Feature Request
Components: Import/Export, Patch Release
Affects Versions: 9.0.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: Barry LaFond
Priority: Blocker
Fix For: 9.2.1
When using the JDBC importer with an Oracle datasource, Oracle Packages are not available
to be selected. I am only allowed to select Tables, Views, and Procedures. There should
be an option to select Packages, which in my case contains stored procedures.
A ticket was submitted on the TEIID side to support this functionality.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)