April 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3412) Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3412?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3412. ----------------------------------- Fix Version/s: 8.7.1.6_2 8.11 Resolution: Done > Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8 > ------------------------------------------------------------------------------ > > Key: TEIID-3412 > URL: https://issues.jboss.org/browse/TEIID-3412 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Kylin Soong > Fix For: 8.7.1.6_2, 8.11 > > > In JDK 1.8, the ODBC-JDBC bridge is removed, so accessing MS Access using this method will not be available. An alternative, open source, driver that can be used is: http://jackcess.sourceforge.net > In nexus: > <dependency> > <groupId>com.healthmarketscience.jackcess</groupId> > <artifactId>jackcess</artifactId> > <version>2.0.9</version> > </dependency> > This may require a new translator, but won't be know until a deeper look is done. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3412) Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3412?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3412: ---------------------------------- Affects Version/s: (was: 9.x) > Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8 > ------------------------------------------------------------------------------ > > Key: TEIID-3412 > URL: https://issues.jboss.org/browse/TEIID-3412 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Assignee: Kylin Soong > > In JDK 1.8, the ODBC-JDBC bridge is removed, so accessing MS Access using this method will not be available. An alternative, open source, driver that can be used is: http://jackcess.sourceforge.net > In nexus: > <dependency> > <groupId>com.healthmarketscience.jackcess</groupId> > <artifactId>jackcess</artifactId> > <version>2.0.9</version> > </dependency> > This may require a new translator, but won't be know until a deeper look is done. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3450) bulk values are set directly from client

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3450?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3450: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1213975 > bulk values are set directly from client > ---------------------------------------- > > Key: TEIID-3450 > URL: https://issues.jboss.org/browse/TEIID-3450 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.10.1, 8.11 > > > Using a prepared bulk query, such as "insert ... values (?, ...)" that is passed to the source, the bound values are coming directly from the client rather than being the resolved form - which will be the correct runtime object and type. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3450) bulk values are set directly from client

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3450?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3450: ---------------------------------- Fix Version/s: 8.7.1.6_2 > bulk values are set directly from client > ---------------------------------------- > > Key: TEIID-3450 > URL: https://issues.jboss.org/browse/TEIID-3450 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.10.1, 8.11 > > > Using a prepared bulk query, such as "insert ... values (?, ...)" that is passed to the source, the bound values are coming directly from the client rather than being the resolved form - which will be the correct runtime object and type. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3450) bulk values are set directly from client

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3450?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3450. ----------------------------------- Resolution: Done Updated the logic to use the resolved value. Added to 62_8.7.x since this is being picked up by support. > bulk values are set directly from client > ---------------------------------------- > > Key: TEIID-3450 > URL: https://issues.jboss.org/browse/TEIID-3450 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.10.1, 8.11 > > > Using a prepared bulk query, such as "insert ... values (?, ...)" that is passed to the source, the bound values are coming directly from the client rather than being the resolved form - which will be the correct runtime object and type. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3450) bulk values are set directly from client

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3450: ------------------------------------- Summary: bulk values are set directly from client Key: TEIID-3450 URL: https://issues.jboss.org/browse/TEIID-3450 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.10.1, 8.11 Using a prepared bulk query, such as "insert ... values (?, ...)" that is passed to the source, the bound values are coming directly from the client rather than being the resolved form - which will be the correct runtime object and type. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3449) Recursive call in PreparedStatement

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3449?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3449. ----------------------------------- Resolution: Done Updated the call. > Recursive call in PreparedStatement > ----------------------------------- > > Key: TEIID-3449 > URL: https://issues.jboss.org/browse/TEIID-3449 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > public void setObject (int parameterIndex, Object value, int targetJdbcType, int scale) throws SQLException > mistakenly calls itself with the TEIID-174 change. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3449) Recursive call in PreparedStatement

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3449: ------------------------------------- Summary: Recursive call in PreparedStatement Key: TEIID-3449 URL: https://issues.jboss.org/browse/TEIID-3449 Project: Teiid Issue Type: Bug Affects Versions: 8.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.11 public void setObject (int parameterIndex, Object value, int targetJdbcType, int scale) throws SQLException mistakenly calls itself with the TEIID-174 change. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3296) Some criteria are missing when indexes are used on the source tables

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3296?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3296: ------------------------------------------------ asmigala(a)redhat.com changed the Status of [bug 1185068|https://bugzilla.redhat.com/show_bug.cgi?id=1185068] from MODIFIED to VERIFIED > Some criteria are missing when indexes are used on the source tables > -------------------------------------------------------------------- > > Key: TEIID-3296 > URL: https://issues.jboss.org/browse/TEIID-3296 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.2 > Reporter: Salvatore R > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.10, 8.7.2, 8.7.1.6_2 > > > The following two tables are defined in two different datasources (PostgreSQL and MySQL): > {code:sql} > CREATE TABLE "pg"."tx1" > ( > a varchar(2147483647), > b varchar(2147483647), > c integer, > d integer, > e integer > ); > CREATE INDEX tx1_b ON "pg"."tx1"(b); > CREATE INDEX tx1_a ON "pg"."tx1"(a); > CREATE INDEX tx1_e ON "pg"."tx1"(e); > CREATE INDEX tx1_d ON "pg"."tx1"(d); > CREATE INDEX tx1_c ON "pg"."tx1"(c); > > CREATE TABLE "my"."tx2" > ( > a integer, > b integer, > c integer, > d integer, > e integer > ); > insert into tx1 VALUES(1,1,1,1,1) ; > insert into tx1 VALUES(1,2,2,2,2) ; > insert into tx1 VALUES(1,2,3,3,3) ; > insert into tx1 VALUES(1,2,3,4,4) ; > insert into tx1 VALUES(1,2,3,4,5) ; > insert into tx2 VALUES(1,2,3,4,5) ; > {code} > Running the following query: > {code:sql} > select tx1.* from pg.tx1 as tx1 join my.tx2 as tx2 on tx1.a=tx2.a and tx1.b=tx2.b and tx1.c=tx2.c and tx1.d=tx2.d and tx1.e!=tx2.e; > {code} > a wrong result is returned: > ||a||b||c||d||e|| > |1|2|2|2|2| > |1|2|3|3|3| > |1|2|3|4|4| > If indexes are removed from the source table, the expected result is correctly returned: > ||a||b||c||d||e|| > |1|2|3|4|4| -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3445) StackOverflowError on TempTableStore.getTempTable()

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3445?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3445. ----------------------------------- Resolution: Done Ensured that the final pop and reset restore expectations of the state. > StackOverflowError on TempTableStore.getTempTable() > --------------------------------------------------- > > Key: TEIID-3445 > URL: https://issues.jboss.org/browse/TEIID-3445 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Mark Addleman > Assignee: Steven Hawkins > Fix For: 8.11 > > > Below is a log snippet (working on getting the full plan) for a StackOverflowError on TempTableStore.getTempTable(): > Exception processin contiuous query begin > insert into #mom_collectors select * from (call mom.connected_collectors()) t; > insert into #apm_collectors select * from (call apm_server.connected_collectors()) t; > select 'add', hostname, port, id from #mom_collectors > where (hostname, port) not in (select (hostname, port) from #apm_collectors) > union > select 'delete', hostname, port, id from #apm_collectors > where (hostname, port) not in (select (hostname, port) from #mom_collectors) with return; > end > org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) > at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) > at org.teiid.jdbc.ResultSetImpl.processBatch(ResultSetImpl.java:425) > at org.teiid.jdbc.ResultSetImpl.access$000(ResultSetImpl.java:64) > at org.teiid.jdbc.ResultSetImpl$1.onCompletion(ResultSetImpl.java:242) > at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:135) > at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:40) > at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:79) > at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1056) > at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) > at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) > at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) > at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) > at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.j > ava:119) > at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) > at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > at java.lang.Thread.run(Thread.java:745) > Caused by: org.teiid.core.TeiidException > at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) > at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) > ... 10 more > Caused by: java.lang.StackOverflowError > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) > at org.teiid.query.tempdata.TempTableStore.getTempTable(TempTableStore.java:614) -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2015