July 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2994) DDL Option properties not namespaced for salesforce

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2994?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2994. --------------------------------- > DDL Option properties not namespaced for salesforce > --------------------------------------------------- > > Key: TEIID-2994 > URL: https://issues.jboss.org/browse/TEIID-2994 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: AdminApi > Affects Versions: 8.7 > Reporter: Mark Drilling > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.8, 8.7.1 > > Attachments: DDLExtOptionsComparison.txt > > > The Option keys for DDL with saleforce source are not getting namespaced. This is inconsistent with other sources like excel. See attached file - comparison of two tables - Excel source vs Salesforce source. The excel keys are prefixed with a namespace teiid_excel: but the salesforce keys are not. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2952) Crypto exception with client/server running on different java versions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2952?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2952. --------------------------------- > Crypto exception with client/server running on different java versions > ---------------------------------------------------------------------- > > Key: TEIID-2952 > URL: https://issues.jboss.org/browse/TEIID-2952 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: JDBC Driver, Server > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 7.7.10, 8.8, 8.7.1 > > > The DiffieHellman key generation logic varies by platform with the handling of leading 0's in the secret. 1.6 seems to strip while most 1.7 vms do not. A related Java bug is http://bugs.java.com/bugdatabase/view_bug.do?bug_id=8014618 which indicates Sun/OpenJDK JRE 7u17 - 8b94 are affected. > If there is conflicting handling between the client/server then approximately 1 out of 256 connection attempts will fail with a bad padding exception, since the client/server will be operating against different symmetric keys. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2931) Perform equi-join full outer joins in a streaming manner

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2931?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2931. --------------------------------- > Perform equi-join full outer joins in a streaming manner > -------------------------------------------------------- > > Key: TEIID-2931 > URL: https://issues.jboss.org/browse/TEIID-2931 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 7.7.9, 8.8, 8.7.1 > > > A pass to compute the right outer matches is only needed when there is non-equi join criteria, since we'll already have determined the right outer values that fail to match the equi-join predicates on the first pass. Note that second passes are limited only to the match regions, but we don't have effective buffering logic for that so we just fully buffer each side. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3017) jpa type mappings need simplified

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3017?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3017. --------------------------------- > jpa type mappings need simplified > --------------------------------- > > Key: TEIID-3017 > URL: https://issues.jboss.org/browse/TEIID-3017 > Project: Teiid > Issue Type: Quality Risk > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.8, 8.7.1 > > > There is type mapping logic in the jpa translator that duplicates data type manager logic. It also has several incorrect mappings, such as Byte[] to Blob. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2647) Add an impala translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2647?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2647. --------------------------------- > Add an impala translator > ------------------------ > > Key: TEIID-2647 > URL: https://issues.jboss.org/browse/TEIID-2647 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Labels: alpha1 > Fix For: 8.8, 8.7.1 > > > Impala offers an alternative to Hive SQL access: > http://blog.cloudera.com/blog/2012/10/cloudera-impala-real-time-queries-i... -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2986) issues with embedded

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2986?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2986. --------------------------------- > issues with embedded > -------------------- > > Key: TEIID-2986 > URL: https://issues.jboss.org/browse/TEIID-2986 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Embedded > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.8, 8.7.1 > > > The dependency set for the ws translator is incomplete the cxf bundle jar and several other dependencies are needed. > We are not including the JBoss modules jar, but have an implied dependency through EmbeddedProfile, which should be refactored so that the modules jar is not needed in the embedded kit. > Also the classpaths in the example scripts are incorrect with the 8.7 refactoring to put optional dependencies in subfolders. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3024) QueryTimeout not working for synchronous local queries against Teiid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3024?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3024. --------------------------------- > QueryTimeout not working for synchronous local queries against Teiid > -------------------------------------------------------------------- > > Key: TEIID-3024 > URL: https://issues.jboss.org/browse/TEIID-3024 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: JDBC Driver > Affects Versions: 8.1, 8.7 > Reporter: gaurav singhal > Assignee: Steven Hawkins > Fix For: 8.8, 8.7.1 > > Attachments: query timeout bug.zip > > > If i run a query with synchronous query with a timeout set using PreparedStatementImpl.setQueryTimeout() method, that timeout is not honored. But if i run the same query with all the same setup and execute the query asynchronously then a timeout happens and warning message like below is printed: > > Jul 02, 2014 10:19:21 AM org.teiid.jdbc.StatementImpl timeoutOccurred > WARNING: Timeout occurred in Statement. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2757) XML 1.0 invalid characters not supported in Odata Atom feed

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2757?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2757. --------------------------------- > XML 1.0 invalid characters not supported in Odata Atom feed > ----------------------------------------------------------- > > Key: TEIID-2757 > URL: https://issues.jboss.org/browse/TEIID-2757 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Server > Affects Versions: 8.4 > Environment: EAP version 6.1 with Teiid 8.5 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 8.7, 8.4.2 > > Attachments: List of invalid XML characters.docx, TEIID-2757-Webservices-Stacktrace.txt > > > The odata framework sometimes has problems with transforming characters (invalid in XML 1.0) from the source data to the XML result. The result is an exception: TEIID16013 Error occured producing OData result.: java.lang.RuntimeException: com.ctc.wstx.exc.WstxIOException: Invalid white space character (0x1b) in text to output (in xml 1.1, could output as a character entity). -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2963) ORDER BY and UNION fails

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2963?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2963. --------------------------------- > ORDER BY and UNION fails > ------------------------ > > Key: TEIID-2963 > URL: https://issues.jboss.org/browse/TEIID-2963 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Query Engine > Affects Versions: 8.7, 8.8 > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: oracle, order, select, union > Fix For: 8.8, 8.7.1 > > > I can reproduce this in Teiid 8.7.0.Final and nightly build from master (09e396f). The same query works fine when performed directly against Oracle. > {code:sql} > select > "FOO"."FOO_ID" "FOO_ID" > from ( > (select "ITEMS"."ITEM_ID" "FOO_ID" from "BLAH"."ITEMS" "ITEMS" group by "ITEMS"."ITEM_ID") > union all > (select "ITEMS"."ITEM_ID" "FOO_ID" from "BLAH"."ITEMS" "ITEMS") > ) "FOO" > order by "FOO_ID" desc; > {code} > {code} > 03:47:21,218 WARN [org.teiid.CONNECTOR] (Worker7_QueryProcessorQueue189) 6w9Z3uBcAONA Connector worker process failed for atomic-request=6w9Z3uBcAONA.8.1.39: org.teiid.translator.jdbc.JDBCExecutionException: 904 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_1."ITEM_ID" AS c_0 FROM "BLAH"."ITEMS" g_1 GROUP BY g_1."ITEM_ID" UNION ALL SELECT g_0."ITEM_ID" AS c_0 FROM "BLAH"."ITEMS" g_0 ORDER BY FOO_ID DESC] > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) > at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:326) [teiid-engine-8.8.0.Alpha2-SNAPSHOT.jar:8.8.0.Alpha2-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.8.0.Alpha2-SNAPSHOT.jar:8.8.0.Alpha2-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.8.0.Alpha2-SNAPSHOT.jar:8.8.0.Alpha2-SNAPSHOT] > at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.8.0.Alpha2-SNAPSHOT.jar:8.8.0.Alpha2-SNAPSHOT] > at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_02] > at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_02] > at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.8.0.Alpha2-SNAPSHOT.jar:8.8.0.Alpha2-SNAPSHOT] > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.8.0.Alpha2-SNAPSHOT.jar:8.8.0.Alpha2-SNAPSHOT] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.8.0.Alpha2-SNAPSHOT.jar:8.8.0.Alpha2-SNAPSHOT] > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.8.0.Alpha2-SNAPSHOT.jar:8.8.0.Alpha2-SNAPSHOT] > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_02] > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_02] > at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_02] > Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "FOO_ID": invalid identifier > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) > at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) > at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017) > at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655) > at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249) > at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566) > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215) > at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58) > at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776) > at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897) > at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034) > at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820) > at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867) > at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502) > at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) > at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) > ... 13 more > {code} -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2852) Retrieval of AUTO GENERATED Keys does not work with JDBC Translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2852?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2852. --------------------------------- > Retrieval of AUTO GENERATED Keys does not work with JDBC Translator > -------------------------------------------------------------------- > > Key: TEIID-2852 > URL: https://issues.jboss.org/browse/TEIID-2852 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: JDBC Connector > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 8.7, 8.4.3 > > > Auto generation of JDBC identity keys not working because the statement that executed the insert is closed before the the "stmt.getGeneratedKeys()" is called. -- This message was sent by Atlassian JIRA (v6.2.6#6264)

11 years, 8 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 July 2014