January 2016 - teiid-designer-issues

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Barry LaFond resolved TEIIDDES-2751. ------------------------------------ Resolution: Done master: https://github.com/Teiid-Designer/teiid-designer/commit/a0abaf50db59dd28b... 9.0.x: > 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.0.5, 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)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-2751: ---------------------------------------- Looks like the JdbcProcedureTypeImpl is creating each JdbcProcedureImpl and has access to the resultSet string[] array. The first value, for Oracle would be PROCEDURE_CAT. Need to just capture this info at creation time, and use this value (if != null) in the Name In Source method. > 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.0.5, 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)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2751: ----------------------------------- Fix Version/s: 9.0.5 > 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.0.5, 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)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2720) Provide checks on VDB export and warn users if XML Document, Web Services or XSD models exist in the VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2720?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2720: ----------------------------------- Description: [~blafond]: {quote}WS Operations are really just Virtual Procedures, so we could convert WS models in the near term{quote} Exporting VDB with a web service model currently results in an empty model. Add the ability to export WS operations as virtual procedures. Provide checks on VDB export and warn users if XML Document, Web Services or XSD models exist in the VDB was: [~blafond]: {quote}WS Operations are really just Virtual Procedures, so we could convert WS models in the near term{quote} Exporting VDB with a web service model currently results in an empty model. Add the ability to export WS operations as virtual procedures. > Provide checks on VDB export and warn users if XML Document, Web Services or XSD models exist in the VDB > -------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2720 > URL: https://issues.jboss.org/browse/TEIIDDES-2720 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export, Patch Release, Web Services Support > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2.1 > > > [~blafond]: > {quote}WS Operations are really just Virtual Procedures, so we could convert WS models in the near term{quote} > Exporting VDB with a web service model currently results in an empty model. Add the ability to export WS operations as virtual procedures. > Provide checks on VDB export and warn users if XML Document, Web Services or XSD models exist in the VDB -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2720) Provide checks on VDB export and warn users if XML Document, Web Services or XSD models exist in the VDB

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2720?page=com.atlassian.jira.plu... ] Barry LaFond updated TEIIDDES-2720: ----------------------------------- Summary: Provide checks on VDB export and warn users if XML Document, Web Services or XSD models exist in the VDB (was: Convert WS models to procedures when exporting Dynamic VDB) > Provide checks on VDB export and warn users if XML Document, Web Services or XSD models exist in the VDB > -------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2720 > URL: https://issues.jboss.org/browse/TEIIDDES-2720 > Project: Teiid Designer > Issue Type: Bug > Components: Dynamic VDBs, Import/Export, Patch Release, Web Services Support > Affects Versions: 9.0.4 > Reporter: Andrej Šmigala > Assignee: Barry LaFond > Fix For: 9.2.1 > > > [~blafond]: > {quote}WS Operations are really just Virtual Procedures, so we could convert WS models in the near term{quote} > Exporting VDB with a web service model currently results in an empty model. Add the ability to export WS operations as virtual procedures. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Van Halbert edited comment on TEIIDDES-2751 at 1/13/16 4:02 PM: ---------------------------------------------------------------- First call to get the list of package objects: select distinct ua.object_name, ua.package_name from user_arguments ua where ua.package_name in (select object_name from user_objects where object_type in ('PACKAGE') ); Then call the following to get the arguments for a specific package object (procedure/function): select * from user_arguments where package_name = \'{package _name}\' and object_name = \'{object_name}\' was (Author: van.halbert): First call to get the list of package objects: select distinct ua.object_name, ua.package_name from user_arguments ua where ua.package_name in (select object_name from user_objects where object_type in ('PACKAGE') ); Then call the following to get the arguments for a specific package object (procedure/function): select * from user_arguments where package_name = '{package _name}' and object_name = '{object_name}' > 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)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Van Halbert edited comment on TEIIDDES-2751 at 1/13/16 4:02 PM: ---------------------------------------------------------------- First call to get the list of package objects: {code} select distinct ua.object_name, ua.package_name from user_arguments ua where ua.package_name in (select object_name from user_objects where object_type in ('PACKAGE') ); {code} Then call the following to get the arguments for a specific package object (procedure/function): {code} select * from user_arguments where package_name = '{package _name}' and object_name = '{object_name}' {code} was (Author: van.halbert): First call to get the list of package objects: select distinct ua.object_name, ua.package_name from user_arguments ua where ua.package_name in (select object_name from user_objects where object_type in ('PACKAGE') ); Then call the following to get the arguments for a specific package object (procedure/function): select * from user_arguments where package_name = \'{package _name}\' and object_name = \'{object_name}\' > 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)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-2751: --------------------------------------- First call to get the list of package objects: select distinct ua.object_name, ua.package_name from user_arguments ua where ua.package_name in (select object_name from user_objects where object_type in ('PACKAGE') ); Then call the following to get the arguments for a specific package object (procedure/function): select * from user_arguments where package_name = '{package _name}' and object_name = '{object_name}' > 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)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2751) Add ability to import Oracle Packages via JDBC Import

by Barry LaFond (JIRA)

[ 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)

8 years, 5 months

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2760) built-in varbinary datatype needs to be defined as a varbinary runtime type rather than string

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2760?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2760 at 1/13/16 9:49 AM: ----------------------------------------------------------------- master: https://github.com/Teiid-Designer/teiid-designer/commit/bf88579ea0e5654c8... 9.0.x: https://github.com/Teiid-Designer/teiid-designer/commit/921c48fad4468a1c3... was (Author: blafond): master: https://github.com/Teiid-Designer/teiid-designer/commit/bf88579ea0e5654c8... 9.0.x > built-in varbinary datatype needs to be defined as a varbinary runtime type rather than string > ---------------------------------------------------------------------------------------------- > > Key: TEIIDDES-2760 > URL: https://issues.jboss.org/browse/TEIIDDES-2760 > Project: Teiid Designer > Issue Type: Bug > Components: Patch Release, Teiid Integration > Reporter: Barry LaFond > Assignee: Barry LaFond > Priority: Critical > Fix For: 9.0.5, 9.2.1 > > > When base64Binary built in type was added to BuiltinDatatypes.xsd, the runtime type was mistakenly set to type "string" rather than varbinary. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 5 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues January 2016