October 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3432) support: MongoDB 3.0

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3432?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3432. --------------------------------- > support: MongoDB 3.0 > --------------------- > > Key: TEIID-3432 > URL: https://issues.jboss.org/browse/TEIID-3432 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Affects Versions: 8.10 > Reporter: Ivan Chan > Assignee: Ramesh Reddy > Fix For: 8.11 > > > According latest documentation for MongoDB 3.0 (Driver Compatibility Changes[1]) the minimum driver version required is 2.13. Currently Teiid 8.10 is using 2.12 > http://docs.mongodb.org/manual/release-notes/3.0-compatibility/ -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3446) NumberFormatException By Oracle during metadata import

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3446?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3446. --------------------------------- > NumberFormatException By Oracle during metadata import > ------------------------------------------------------ > > Key: TEIID-3446 > URL: https://issues.jboss.org/browse/TEIID-3446 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > > When dealing with very high cardinatlity in Oracle source table, during the metadata retrieval in JDBC translator the driver throws a NumberFormatException. > The largest table has 6 Billion rows -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3447) Attempt to get JDBC cardinalities with getLong

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3447?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3447. --------------------------------- > Attempt to get JDBC cardinalities with getLong > ---------------------------------------------- > > Key: TEIID-3447 > URL: https://issues.jboss.org/browse/TEIID-3447 > Project: Teiid > Issue Type: Quality Risk > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > Oracle, and possibly other drivers, can have an issue (numericoverflow) with table cardinalities over max int. when getInt is used on the ResultSet (int is expected according to JDBC). We can try getLong first and then getInt if there is an issue. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3444) Add the model properties as extension metadata on the schema

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3444?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3444. --------------------------------- > Add the model properties as extension metadata on the schema > ------------------------------------------------------------ > > Key: TEIID-3444 > URL: https://issues.jboss.org/browse/TEIID-3444 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > To provide an ability to set extension metadata on the schema we would either need to introduce a new ddl construct or let the existing model property functionality be used. To promote a single mechanism it seems good to let the model properties be injected onto the schema object as extension metadata. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 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 closed TEIID-3445. --------------------------------- > 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.4.11#64026)

9 years, 2 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 closed TEIID-3449. --------------------------------- > Recursive call in PreparedStatement > ----------------------------------- > > Key: TEIID-3449 > URL: https://issues.jboss.org/browse/TEIID-3449 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > 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.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3266) Support set session characteristics for txn isolation level

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3266?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3266. --------------------------------- > Support set session characteristics for txn isolation level > ----------------------------------------------------------- > > Key: TEIID-3266 > URL: https://issues.jboss.org/browse/TEIID-3266 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > We should support set session characteristics - at least for the transaction isolation level. For example: https://mariadb.com/kb/en/sql-99/38-sql-sessions/sql-session-management/s... > This is used by Tableau TEIID-3073 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3390) Improve SQL/XML generation performance and limit disk usage

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3390?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3390. --------------------------------- > Improve SQL/XML generation performance and limit disk usage > ----------------------------------------------------------- > > Key: TEIID-3390 > URL: https://issues.jboss.org/browse/TEIID-3390 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.11 > > > Deeply nested large xml documents generated by SQL/XML can create a lot of temporary disk backed objects. These objects can have slow cleanup based upon when their references get cleared. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3434) Ability to enable/disable caching by table and/or source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3434?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3434: ---------------------------------- Component/s: Query Engine > Ability to enable/disable caching by table and/or source > -------------------------------------------------------- > > Key: TEIID-3434 > URL: https://issues.jboss.org/browse/TEIID-3434 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Burak Serdar > Assignee: Steven Hawkins > Fix For: 8.11 > > > We need to be able to enable/disable caching by table and/or source. Some of our tables have real-time data, and we do not want to cache those, and some other tables can use cached data. It is not sufficient to use SQL options to turn caching on or off, because we're using 3rd party tools, and we don't have control over the SQL they generate. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 2 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3412) Change MS Access to use another client, 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: ---------------------------------- Description: In JDK 1.8, the ODBC-JDBC bridge is removed, so accessing MS Access using this method will not be available. This may require a new translator, but won't be know until a deeper look is done. was: 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. Summary: Change MS Access to use another client, since ODBC-JDBC bridge is removed in JDK 1.8 (was: Change MS Access to use jackcess, since ODBC-JDBC bridge is removed in JDK 1.8) > Change MS Access to use another client, 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. > 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.4.11#64026)

9 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 2015