October 2013 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2697) Change to use community bom

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2697?page=com.atlassian.jira.plugin... ] Van Halbert updated TEIID-2697: ------------------------------- Fix Version/s: 8.6 > Change to use community bom > --------------------------- > > Key: TEIID-2697 > URL: https://issues.jboss.org/browse/TEIID-2697 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.4.1, 8.6 > > > Teiid should import dependencies from the community bom (https://github.com/jboss-integration/jboss-integration-platform-bom/) -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2711) Better support for Oracle SQLXML values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2711?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2711: --------------------------------------- Also another workaround (similar to the patch) is to alter the source xml column type to instead by clob and use a native-query on the table to convert that column to a clob: select col1, col2, to_clob(xml_col) ... from tbl Based upon this workaround and the documented (but not locally verified) approach from the first comment, I'm inclined to not commit this just yet. > Better support for Oracle SQLXML values > --------------------------------------- > > Key: TEIID-2711 > URL: https://issues.jboss.org/browse/TEIID-2711 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Attachments: oracle.patch > > > When using a typical driver configuration to read oracle xml values, the driver will return an OPAQUE instance rather than a SQLXML value. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2711) Better support for Oracle SQLXML values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2711?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2711: ---------------------------------- Attachment: oracle.patch A patch showing an intermediate conversion of xml values through a clob. > Better support for Oracle SQLXML values > --------------------------------------- > > Key: TEIID-2711 > URL: https://issues.jboss.org/browse/TEIID-2711 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Attachments: oracle.patch > > > When using a typical driver configuration to read oracle xml values, the driver will return an OPAQUE instance rather than a SQLXML value. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2711) Better support for Oracle SQLXML values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2711?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2711: --------------------------------------- It looks like getObject may return a SQLXML value from oracle - if a later rev of the 11.2 driver is used (11.2.0.1 does not work), the xdb6.jar is in the classpath, and from http://docs.oracle.com/cd/E11882_01/java.112/e10589/jdbcvers.htm#BABGHBCC there is the system property setting -Doracle.jdbc.getObjectReturnsXMLType="false" > Better support for Oracle SQLXML values > --------------------------------------- > > Key: TEIID-2711 > URL: https://issues.jboss.org/browse/TEIID-2711 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > When using a typical driver configuration to read oracle xml values, the driver will return an OPAQUE instance rather than a SQLXML value. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2711) Better support for Oracle SQLXML values

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2711: ------------------------------------- Summary: Better support for Oracle SQLXML values Key: TEIID-2711 URL: https://issues.jboss.org/browse/TEIID-2711 Project: Teiid Issue Type: Quality Risk Components: JDBC Connector Reporter: Steven Hawkins Assignee: Steven Hawkins When using a typical driver configuration to read oracle xml values, the driver will return an OPAQUE instance rather than a SQLXML value. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2363) proactive buffering not occurring for the inner side of an outer join on "MERGE JOIN (SORT/ALREADY_SORTED)"

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2363?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2363. ----------------------------------- Resolution: Done Re-resolving by pulling out of 7.7.9. Addressed in 8.4.1 and 8.6 with TEIID-2707. > proactive buffering not occurring for the inner side of an outer join on "MERGE JOIN (SORT/ALREADY_SORTED)" > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-2363 > URL: https://issues.jboss.org/browse/TEIID-2363 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.2 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 7.7.7, 8.4 > > > The issue here is this is an outer join and the inner side (the already sorted side) will be buffered regardless. Current logic does not catch blocked exceptions from one side and pro-actively buffer the other - rather we are serially performing the sort and then continue with the loading of the inner side > For inner joins there is a clear trade-off between execution speed and buffering so this behavior may have to be hint or config driven for non-dependent non-outer joins. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2710) Rest procedures should support optional parameters

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2710: ------------------------------------- Summary: Rest procedures should support optional parameters Key: TEIID-2710 URL: https://issues.jboss.org/browse/TEIID-2710 Project: Teiid Issue Type: Enhancement Components: Server Reporter: Steven Hawkins Assignee: Steven Hawkins We need to test our rest logic to ensure it supports optional parameters in the uri pattern: {code}@Path("/mypath{param1 : (/param2)?}"){code} And then update the procedure call to use named parameters so that defaultable missing parameters will use defaults (similar to the TeiidProducer/LocalClient logic used for OData). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2690) Tuples lost in a with clause item.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2690?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2690: ---------------------------------- Fix Version/s: 7.7.8 > Tuples lost in a with clause item. > ---------------------------------- > > Key: TEIID-2690 > URL: https://issues.jboss.org/browse/TEIID-2690 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.1, 7.7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.4.1, 8.6, 7.7.8 > > > Related to TEIID-2442 - the BatchIterator created for the creation of the temp table backing a with clause item cannot be created after blocking without loosing tuples. > On 8.3.x+ a single block is not sufficient to induce this behavior if there are any tuples that have been retrieved since the last block as the access node logic will return the partial batch. Thus may occur as a somewhat rare timing issue in 8.3.x+. However in 7.7.7/7.7.8 a single block cause the recreation of the BatchIterator making the affect almost certain once the row count exceeds the computed working batch size (nominally 256 rows, but allowed to vary based upon the row width). -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2696) Update Teiid datasource examples to be fully parameterized

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2696?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2696: ------------------------------------- Do not open new one, I believe the question was to check if the issue can be moved to resolved state, looks like it is not. > Update Teiid datasource examples to be fully parameterized > ---------------------------------------------------------- > > Key: TEIID-2696 > URL: https://issues.jboss.org/browse/TEIID-2696 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.4.1, 8.6 > > > Change the example datasources to be parameterized, and add an associated properties file so that to install, run: > jboss-cli.sh -c --file={datasource}-ds.cli --properties=/{datasource}-ds.properties -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2696) Update Teiid datasource examples to be fully parameterized

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2696?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-2696: ------------------------------------ I guess it could be. But I'm still planning on updating the rest of the examples over the next week, so I could open up a new jira then. > Update Teiid datasource examples to be fully parameterized > ---------------------------------------------------------- > > Key: TEIID-2696 > URL: https://issues.jboss.org/browse/TEIID-2696 > Project: Teiid > Issue Type: Enhancement > Components: Build/Kits > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.4.1, 8.6 > > > Change the example datasources to be parameterized, and add an associated properties file so that to install, run: > jboss-cli.sh -c --file={datasource}-ds.cli --properties=/{datasource}-ds.properties -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

11 years, 2 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2013