[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:
-----------------------------------
Component/s: Patch Release
> 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
> 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)
9 years
[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.2.1
> 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
> 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
> 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)
9 years
[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ]
Mark Drilling commented on TEIIDDES-2687:
-----------------------------------------
So is there any problem here then? I'm not clear if there is an issue and if so, what is it?
> Dynamic VDB generation - Default value for string column problem (DDL)
> ----------------------------------------------------------------------
>
> Key: TEIIDDES-2687
> URL: https://issues.jboss.org/browse/TEIIDDES-2687
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 9.2.1
>
>
> I have a model with table that has String column with default value "Stock".
> DDL generated by TD for dynamic VDB looks like this:
> {quote}
> ...
> TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'),
> ...
> {quote}
> *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'*
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[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 reassigned TEIIDDES-2751:
-------------------------------------
Assignee: Barry LaFond
> 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
> 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
>
> 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)
9 years
[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2687:
----------------------------------------
Van's comment from BZ: I don't think DEFAULT '("Stock")' is correct, even though it may work. Its not consistent with defining other attributes. Now, if you would have said something like: DEFAULT ('"Stock"') , then possibly.
> Dynamic VDB generation - Default value for string column problem (DDL)
> ----------------------------------------------------------------------
>
> Key: TEIIDDES-2687
> URL: https://issues.jboss.org/browse/TEIIDDES-2687
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 9.2.1
>
>
> I have a model with table that has String column with default value "Stock".
> DDL generated by TD for dynamic VDB looks like this:
> {quote}
> ...
> TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'),
> ...
> {quote}
> *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'*
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2687) Dynamic VDB generation - Default value for string column problem (DDL)
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2687?page=com.atlassian.jira.plu... ]
Mark Drilling commented on TEIIDDES-2687:
-----------------------------------------
Can you attach your modelProjectSet? I am trying different default values and do not see the DDL you are getting.
> Dynamic VDB generation - Default value for string column problem (DDL)
> ----------------------------------------------------------------------
>
> Key: TEIIDDES-2687
> URL: https://issues.jboss.org/browse/TEIIDDES-2687
> Project: Teiid Designer
> Issue Type: Bug
> Components: Dynamic VDBs, Patch Release, VDB & Execution
> Affects Versions: 9.0.4
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Fix For: 9.2.1
>
>
> I have a model with table that has String column with default value "Stock".
> DDL generated by TD for dynamic VDB looks like this:
> {quote}
> ...
> TYPE string(15) DEFAULT ('Stock') OPTIONS(NAMEINSOURCE '"TYPE"', NATIVE_TYPE 'VARCHAR2', UPDATABLE 'FALSE'),
> ...
> {quote}
> *DEFAULT ('Stock')* is not correct, it should be: *DEFAULT '("Stock")'*
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2297) I can't see whole model editor buttons on Fedora, they are cropped.
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2297?page=com.atlassian.jira.plu... ]
Mark Drilling edited comment on TEIIDDES-2297 at 12/18/15 3:56 PM:
-------------------------------------------------------------------
I am able to reproduce this issue on my Fedora laptop (vertical toolbar icons clipped).
I tried a lot of different ways to address this in code to keep the icons from getting clipped (different layouts, setting toolbar width, etc, etc) - But to no avail....
I think this needs to be addressed via gtk layouts on linux. I am able to provide a layout config (attached) via system property (GTK2_RC_FILES) which resolves the clipping issue. The layout is set via a system env variable so can be either set prior to launch or provided on designer/dev studio startup - like this:
GTK2_RC_FILES=/home/mdrilling/Desktop/linuxGtkLayout.conf ./jbdevstudio
I'm not sure the best way to provide a fix to users. [~blafond]? Do we just provide a layout configuration file with documentation on how to launch? This may be fixable by setting certain themes on linux, I haven't really dove into that and tested. If so, maybe we have a suggested theme which works.... I'm open for suggestions on how to provide this fix.
was (Author: mdrillin):
gtk layout to address 'vertical toolbar' issue
> I can't see whole model editor buttons on Fedora, they are cropped.
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2297
> URL: https://issues.jboss.org/browse/TEIIDDES-2297
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Patch Release
> Affects Versions: 8.3.3
> Environment: Fedora 20
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Priority: Minor
> Fix For: 9.2.1
>
> Attachments: linuxGtkLayout.conf, screen.png
>
>
> Model editor buttons are cropped. [screenshot] On Windows 7 they are OK, only on Linux (I have Fedora 20) user can't see whole buttons.
> User doesn't have the option to expand the panel on the left side to see whole buttons.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2297) I can't see whole model editor buttons on Fedora, they are cropped.
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2297?page=com.atlassian.jira.plu... ]
Mark Drilling updated TEIIDDES-2297:
------------------------------------
Attachment: linuxGtkLayout.conf
gtk layout to address 'vertical toolbar' issue
> I can't see whole model editor buttons on Fedora, they are cropped.
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2297
> URL: https://issues.jboss.org/browse/TEIIDDES-2297
> Project: Teiid Designer
> Issue Type: Bug
> Components: Editors, Patch Release
> Affects Versions: 8.3.3
> Environment: Fedora 20
> Reporter: Matus Makovy
> Assignee: Mark Drilling
> Priority: Minor
> Fix For: 9.2.1
>
> Attachments: linuxGtkLayout.conf, screen.png
>
>
> Model editor buttons are cropped. [screenshot] On Windows 7 they are OK, only on Linux (I have Fedora 20) user can't see whole buttons.
> User doesn't have the option to expand the panel on the left side to see whole buttons.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years
[JBoss JIRA] (TEIIDDES-2199) Designer deletes materialization setting in transformation Editor
by Paul Richardson (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2199?page=com.atlassian.jira.plu... ]
Paul Richardson commented on TEIIDDES-2199:
-------------------------------------------
The space makes the comment failing the parsing of the cache hint. This parsing syntax is synchronized with Teiid, ie. the client passed the SQL onto Teiid and the latter parsing in exactly the same manner. Therefore, any changes to Designer need to be reflected in Teiid as well.
[~shawkins], would you be likely to change this at all in Teiid?
> Designer deletes materialization setting in transformation Editor
> -----------------------------------------------------------------
>
> Key: TEIIDDES-2199
> URL: https://issues.jboss.org/browse/TEIIDDES-2199
> Project: Teiid Designer
> Issue Type: Bug
> Components: Patch Release, Transformations
> Affects Versions: 8.3.2
> Environment: fedora 19, Red Hat Data Virtualization 6, JBDS 7.1.1.GA
> Reporter: Jason Marley
> Assignee: Paul Richardson
> Fix For: 9.2.1
>
>
> In transformation editor and add caching comment /*+ cache(ttl:300000) */, if there is a space before + and the beginning of comment, upon save designer deletes the line.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
9 years