June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3694) Netezza translator - add additional support for other regexp functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3694?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3694. --------------------------------- > Netezza translator - add additional support for other regexp functions > ---------------------------------------------------------------------- > > Key: TEIID-3694 > URL: https://issues.jboss.org/browse/TEIID-3694 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.12 > > > Support for LIKE_REGEX predicate was added, now would like to add support for the following: > Netezza doesn't support regular expression by default, but with the installation of SQL Extensions toolkit this functionality is added. After installation Netezza provide the regular expression functions: > regexp_extract() > regexp_extract_all() > regexp_extract_all_sp() > regexp_extract_sp() > regexp_instr() > regexp_like() > regexp_match_count() > regexp_replace() > regexp_replace_sp() > IBM Netezza SQL Extensions toolkit is an optional package for IBM Netezza data warehouse appliances. > After installing this toolkit on Netezza and requires that regular expression in JBoss DV syntax are pushed down (delegated) to Netezza to prevent that filtering in the Jboss DV server most be done. > So please provide a configurable option in the Netezza translator of Jboss DV by which we can enable the LIKE_REGEX predicate for Netezza. This option when enabled will assume that the Netezza SQL extension toolkit is installed and the function regexp_like() is available. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3651) misc performance enhancements

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3651?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3651. --------------------------------- > misc performance enhancements > ----------------------------- > > Key: TEIID-3651 > URL: https://issues.jboss.org/browse/TEIID-3651 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Driver, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > To improve socket performance, there are some quick changes that can be made. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3687) Provide infinispan-cache translator override to add supportsNotCriteria

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3687?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3687. --------------------------------- > Provide infinispan-cache translator override to add supportsNotCriteria > ----------------------------------------------------------------------- > > Key: TEIID-3687 > URL: https://issues.jboss.org/browse/TEIID-3687 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.7.1.6_2 > Reporter: Van Halbert > Assignee: Van Halbert > Fix For: 8.12 > > > Change the translator to add an override for supportsNotCriteria so that the user could enable push down of the GT/LT operators. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3824) Asynch connector work item close

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3824?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3824. --------------------------------- > Asynch connector work item close > -------------------------------- > > Key: TEIID-3824 > URL: https://issues.jboss.org/browse/TEIID-3824 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13 > > > Related to TEIID-3612 we need to improve how close is called on the connector work item. Since the work item will always be done it's likely that the processing thread will call close while the workitem lock is held and hold up the processing thread unnecessarily. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3513) make saxon dependency optional for embedded

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3513?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3513. --------------------------------- > make saxon dependency optional for embedded > ------------------------------------------- > > Key: TEIID-3513 > URL: https://issues.jboss.org/browse/TEIID-3513 > Project: Teiid > Issue Type: Quality Risk > Components: Embedded > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Minor > > To further modularize embedded saxon should be an optional dependency. Currently the ties into the object model and validation are not isolated. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3709) PreparedStatement parameters should not be cleared after addBatch

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3709?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3709. --------------------------------- > PreparedStatement parameters should not be cleared after addBatch > ----------------------------------------------------------------- > > Key: TEIID-3709 > URL: https://issues.jboss.org/browse/TEIID-3709 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 7.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > After addBatch is called on a PreparedStatement we are clearing the parameter values. The parameters however should remain present until clearParameters is explicitly called. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3576) Issues with waitForLoad

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3576?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3576. --------------------------------- > Issues with waitForLoad > ----------------------- > > Key: TEIID-3576 > URL: https://issues.jboss.org/browse/TEIID-3576 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver, Server > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12, 8.11.2 > > > TEIID-2059 should be refined in that the existing loginTimeout property should be used instead of waitForLoad. > Also we're not properly using the property. When waitForLoad is specified, we're actually using the system default property instead. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3790) Restrict any authenticated roles

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3790?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3790. --------------------------------- > Restrict any authenticated roles > -------------------------------- > > Key: TEIID-3790 > URL: https://issues.jboss.org/browse/TEIID-3790 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.1, 8.13, 9.0 > > > A local connection with the pass-through flag set will allow any connection if no security domain is set (the 8.x default). Beyond that the role assignment logic will any authenticated roles to those users. We need to restrict any-authenticated roles to only properly authenticated users. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3827) multi-source view insert throwing TEIID30492 error

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3827?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3827. --------------------------------- > multi-source view insert throwing TEIID30492 error > -------------------------------------------------- > > Key: TEIID-3827 > URL: https://issues.jboss.org/browse/TEIID-3827 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.3 > 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 > MySQL 5.7 and Postgres 9.4 > 64-bit Windows 7 environment > Reporter: Steve Tran > Assignee: Steven Hawkins > Fix For: 8.12.3, 8.13 > > Attachments: joined_vdb.vdb > > > I'm trying to POC this multi-source INSERT. I have a MySQL DB and Postgres DB on my local machine. Added the drivers, datasource, and created a VBL with 1:1 mapping to my test tables. I created an EBL that is a join of my two tables. Both VBLs and EBL are set to support updates. I'm trying to work through this error. > {quote} > insert into "Joined_EBL"."joined2"(idtestm, randomstring, idtestp, randomint) values(0, 'randomstring', 0, 12345) > org.teiid.runtime.client.TeiidClientException: org.teiid.api.exception.query.QueryValidatorException: Remote TEIID30492 A multi-source table, Joined_EBL.joined2, cannot be used in an INSERT with query expression or SELECT INTO statement. > {quote} > I updated my INSERT tab on the EBL transformation page with the following. > {code}FOR EACH ROW > BEGIN ATOMIC > INSERT INTO Postgres_VBL.testp (Postgres_VBL.testp.idtestp, Postgres_VBL.testp.randomint) VALUES (0, "NEW".randomint); > INSERT INTO MySQL_VBL.testm (MySQL_VBL.testm.idtestm, MySQL_VBL.testm.randomstring) VALUES (0, "NEW".randomstring); > END > {code} > Postgres table > {code} > CREATE TABLE testp > ( > idtestp integer NOT NULL, > randomint integer, > CONSTRAINT pk_id PRIMARY KEY (idtestp) > ) > WITH ( > OIDS=FALSE > ); > ALTER TABLE testp > OWNER TO postgres; > {code} > MySQL table > {code} > CREATE TABLE `testm` ( > `idtestm` int(11) NOT NULL AUTO_INCREMENT, > `randomstring` varchar(45) DEFAULT NULL, > PRIMARY KEY (`idtestm`), > UNIQUE KEY `idtestm_UNIQUE` (`idtestm`) > ) ENGINE=InnoDB DEFAULT CHARSET=tis620; > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3036) Update CXF to current version (3.0.0)

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3036?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3036. --------------------------------- > Update CXF to current version (3.0.0) > ------------------------------------- > > Key: TEIID-3036 > URL: https://issues.jboss.org/browse/TEIID-3036 > Project: Teiid > Issue Type: Sub-task > Components: Embedded > Affects Versions: 8.8 > Reporter: Gary Gregory > Assignee: Ramesh Reddy > Fix For: 8.13 > > > In the same vein as TEIID-3030, we embed CXF and Teiid in our server. We use CXF 2.7.10 and are about to update to 3.0.0. At worse, we'll go to 2.7.11 as an interim step to 3.0.0. > Teiid embedded delivers CXF 2.6.6 for web services support. > It would be great if we could get Teiid to the latest and greatest from CXF so we can all live in the same space without being forced to deal with any incompatibilities or class loader hacks. > Thank you, > Gary -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 10 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016