March 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3181) Use Teiid as default JAAS application name

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3181?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3181. --------------------------------- > Use Teiid as default JAAS application name > ------------------------------------------ > > Key: TEIID-3181 > URL: https://issues.jboss.org/browse/TEIID-3181 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Affects Versions: 8.8 > Reporter: Cristiano Nicolai > Assignee: Steven Hawkins > Fix For: 8.9 > > > Enhancement for the client side of setting up JDBC connections using GSS API. Suggestion is to use "Teiid" as default JAAS application name. This is to be used in case jaasName is not supplied in the connection properties. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3044) Add function metadata to system tables / databasemetadata

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3044?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3044. --------------------------------- > Add function metadata to system tables / databasemetadata > --------------------------------------------------------- > > Key: TEIID-3044 > URL: https://issues.jboss.org/browse/TEIID-3044 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver, Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should expose source/system/udf functions via system metadata. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3222) Dependent join planning modifies left outer to inner join

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3222?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3222. --------------------------------- > Dependent join planning modifies left outer to inner join > --------------------------------------------------------- > > Key: TEIID-3222 > URL: https://issues.jboss.org/browse/TEIID-3222 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 8.9 > > > When planning a dependent join with a nested left outer join, the left outer join can get modified to an inner join inappropriately. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-1049) Create data source for each VDB deployed automaticaly

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1049?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-1049. --------------------------------- > Create data source for each VDB deployed automaticaly > ----------------------------------------------------- > > Key: TEIID-1049 > URL: https://issues.jboss.org/browse/TEIID-1049 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 7.0 > Reporter: Ramesh Reddy > Priority: Minor > Fix For: 8.10 > > > When a VDB is deployed, auto create a data source for the deployed VDB using the Teiid's "embedded" data source class. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3163) Add TEXTTABLE capability to support Custom Line Separator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3163?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3163. --------------------------------- > Add TEXTTABLE capability to support Custom Line Separator > ---------------------------------------------------------- > > Key: TEIID-3163 > URL: https://issues.jboss.org/browse/TEIID-3163 > Project: Teiid > Issue Type: Enhancement > Environment: Teiid 8.8.0.Final > Reporter: Shiveeta Mattoo > Assignee: Steven Hawkins > Labels: FileConnector, TEXTTABLE > Fix For: 8.10 > > > Add TEXTTABLE capability to support Custom Line Separator -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3042) expose dependency information in system tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3042?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3042. --------------------------------- > expose dependency information in system tables > ---------------------------------------------- > > Key: TEIID-3042 > URL: https://issues.jboss.org/browse/TEIID-3042 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should expose additional view/procedure and even column information in terms of their dependencies. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3188) ORA-01702: a view is not appropriate here

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3188?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3188. --------------------------------- > ORA-01702: a view is not appropriate here > ----------------------------------------- > > Key: TEIID-3188 > URL: https://issues.jboss.org/browse/TEIID-3188 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 7.4 > Reporter: Tom Arnold > Assignee: Steven Hawkins > Fix For: 8.9 > > > When importing tables/views from Oracle, importing keys/indexes fails. Workaround is to disable importing of either views or indexes. I think the issue is that Oracle views cannot have indexes/primary-keys, so the fix would be to not call getIndexInfo() on views. > {code} > <property name="importer.tableTypes" value="TABLE,VIEW"/> > <property name="importer.importKeys" value="true"/> > {code} > {code} > 23:03:42,170 CONFIG [oracle.jdbc.driver] (teiid-async-threads - 4) 593E0A4C SQL: analyze table FOO.MY_VIEW compute statistics: java.lang.Throwable: No Error > at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1592) > at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2618) > at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2547) > at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:1073) > at oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:9365) > at org.teiid.translator.jdbc.JDBCMetdataProcessor.getIndexes(JDBCMetdataProcessor.java:553) > at org.teiid.translator.jdbc.JDBCMetdataProcessor.getConnectorMetadata(JDBCMetdataProcessor.java:135) > at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:309) > at org.teiid.translator.jdbc.JDBCExecutionFactory.getMetadata(JDBCExecutionFactory.java:57) > at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] > at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] > at org.teiid.jboss.VDBService$6.run(VDBService.java:395) [teiid-jboss-integration-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] > at org.teiid.jboss.VDBService$7.run(VDBService.java:442) [teiid-jboss-integration-8.9.0.Alpha2-SNAPSHOT.jar:8.9.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] > at org.jboss.threads.JBossThread.run(JBossThread.java:122) > {code} > {code} > 23:03:42,173 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB Foo.1 model "foo" metadata failed to load. Reason:TEIID11010 java.sql.SQLSyntaxErrorException: ORA-01702: a view is not appropriate here > {code} -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2223) Compiled Groovy cannot deploy a dynamic VDB, using AdminShell methods, that is recognized as ACTIVE by the Groovy script

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2223?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2223. --------------------------------- > Compiled Groovy cannot deploy a dynamic VDB, using AdminShell methods, that is recognized as ACTIVE by the Groovy script > ------------------------------------------------------------------------------------------------------------------------ > > Key: TEIID-2223 > URL: https://issues.jboss.org/browse/TEIID-2223 > Project: Teiid > Issue Type: Bug > Components: AdminApi > Affects Versions: 7.7.2 > Reporter: Paul Nittel > Assignee: Johnathon Lee > Priority: Optional > Fix For: Open To Community > > Attachments: CrummyWeather.groovy, ShortWeatherNoTest.groovy, weather-vdb.xml > > > This is a weird case. If I deploy a dynamic VDB from a compiled Groovy script, it is not seen as ACTIVE by the script. The server log shows it is active. > If I use a non-compiled Groovy script, it all works fine. > To add to the intrigue, if the compiled script periodically polls to see if the VDB is active, and I go to the Virtual Databases display in RHQ, the script magically sees the VDB as ACTIVE. > I'm attaching the materials used in this test. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3167) Enhance TEXTTABLE to support TRIM as a configurable option for Delimited Text Files

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3167?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3167. --------------------------------- > Enhance TEXTTABLE to support TRIM as a configurable option for Delimited Text Files > ----------------------------------------------------------------------------------- > > Key: TEIID-3167 > URL: https://issues.jboss.org/browse/TEIID-3167 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Environment: Teiid 8.8.0 Final > Reporter: Shiveeta Mattoo > Assignee: Steven Hawkins > Labels: File-connector, TEXTTABLE, TRIM > Fix For: 8.10 > > > In case of Delimited text files, currently, we always TRIM the input data. > The enhancement request is to make this behaviour configurable, and let user determine, whether the leading or trailing spaces for the column text should be trimmed or not. > Refer thread https://developer.jboss.org/message/905658?et=watches.email.thread#905658 for complete background discussion. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3095) Expose system and pushdown functions

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3095?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3095. --------------------------------- > Expose system and pushdown functions > ------------------------------------ > > Key: TEIID-3095 > URL: https://issues.jboss.org/browse/TEIID-3095 > Project: Teiid > Issue Type: Sub-task > Components: Query Engine > Affects Versions: 8.9 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > The system functions and pushdown functions are not added as normal schema scoped functions, and thus were not exposed by TEIID-3044. We should properly expose them and if possible also add uuids and the ability to lookup system properties. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

9 years, 10 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2015