October 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2929) Provide ability define "execution properties" as VDB properties

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2929?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2929. --------------------------------- > Provide ability define "execution properties" as VDB properties > --------------------------------------------------------------- > > Key: TEIID-2929 > URL: https://issues.jboss.org/browse/TEIID-2929 > Project: Teiid > Issue Type: Enhancement > Components: Server > Reporter: Ramesh Reddy > Assignee: Steven Hawkins > Fix For: 8.8 > > > Currently if user needs to set any execution properties on their connection, with JDBC they can define on the URL or use "SET " statement to issue a query. In ODBC can also use "SET " method. > However, when working with packaged applications and ODBC or in some situations it may be better to configure these properties VDB wide so that all the connections are using same execution properties. > This JIRA proposes ability to add execution properties as vdb properties in vdb.xml file. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2935) OData inline count is not correct when used with skip/top

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2935?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2935. --------------------------------- > OData inline count is not correct when used with skip/top > --------------------------------------------------------- > > Key: TEIID-2935 > URL: https://issues.jboss.org/browse/TEIID-2935 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.3 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.8, 8.7.1 > > > Inline count should be computed prior to the application of top/skip. Currently we apply it afterwords (they are added to the root query on the limit clause). -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2944) getIndexInfo should return statistical information

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2944?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2944. --------------------------------- > getIndexInfo should return statistical information > -------------------------------------------------- > > Key: TEIID-2944 > URL: https://issues.jboss.org/browse/TEIID-2944 > Project: Teiid > Issue Type: Enhancement > Components: JDBC Driver > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.8 > > > DatabaseMetaData.getIndexInfo can return statistical indexes with cardinality information and/or cardinality can be returned on the other index info for the table. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2954) support older designer metadata for ws translator invoke

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2954?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2954. --------------------------------- > support older designer metadata for ws translator invoke > -------------------------------------------------------- > > Key: TEIID-2954 > URL: https://issues.jboss.org/browse/TEIID-2954 > Project: Teiid > Issue Type: Quality Risk > Components: Misc. Connectors > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.8, 8.7.1 > > > Desinger modeled the invoke procedure with the result as an out parameter rather than a return, which was not accounted for with TEIID-2268 > The workaround is to modify the invoke procedure metadata so that the result is a return parameter. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2912) Teiid JDBC-ODBC bridge metada import fails from MS Access 2013

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2912?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2912. --------------------------------- > Teiid JDBC-ODBC bridge metada import fails from MS Access 2013 > -------------------------------------------------------------- > > Key: TEIID-2912 > URL: https://issues.jboss.org/browse/TEIID-2912 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.4 > Reporter: Filip Nguyen > Fix For: 8.8, 8.7.1 > > Attachments: server-importKeysFalse.log, server.log, standalone.xml, test-vdb.xml > > > Environment: > * MS Access 2013 > * Windows 2012 Server > VDB: > {code:xml} > <?xml version="1.0" encoding="UTF-8" standalone="yes"?> > <vdb name="testVDB" version="1"> > <description>Importer VDB</description> > <property name="UseConnectorMetadata" value="true" /> > <model name="testAccessModel" type="PHYSICAL" visible="true"> > <source name="testAccessModel" translator-name="jdbc-simple" connection-jndi-name="java:/AccessDS" /> > </model> > </vdb> > {code} > Log exceprt (full log attached): > {noformat} > ory] (teiid-async-threads - 4) Driver loaded and instance created:sun.jdbc.odbc.JdbcOdbcDriver@49dd4a28 > 08:32:23,935 DEBUG [org.teiid.CONNECTOR] (teiid-async-threads - 4) JDBCMetadataProcessor - Importing tables > 08:32:23,952 DEBUG [org.teiid.CONNECTOR] (teiid-async-threads - 4) JDBCMetadataProcessor - Importing columns > 08:32:23,985 DEBUG [org.teiid.CONNECTOR] (teiid-async-threads - 4) JDBCMetadataProcessor - Importing primary keys > 08:32:23,985 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (teiid-async-threads - 4) AccessDS: returnConnection(2677c1e5, false) [1/20] > 08:32:23,985 WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB testVDB.1 model "testAccessModel" metadata failed to load. Reason:TEIID11010 java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver does not support this function > {noformat} > Driver (standalone.xml attached): > {code:xml} > <datasource jndi-name="java:/AccessDS" pool-name="AccessDS" enabled="true"> > <connection-url>jdbc:odbc:AccessDS</connection-url> > <driver>odbc</driver> > <transaction-isolation>TRANSACTION_NONE</transaction-isolation> > <pool> > <prefill>false</prefill> > <use-strict-min>false</use-strict-min> > <flush-strategy>FailingConnectionOnly</flush-strategy> > </pool> > </datasource> > ... > <drivers> > <driver name="odbc" module="sun.jdk"> > <driver-class>sun.jdbc.odbc.JdbcOdbcDriver</driver-class> > </driver> > </drivers> > {code} -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3168) SQL Server requires N prefix for unicode literals

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3168?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3168. --------------------------------- > SQL Server requires N prefix for unicode literals > ------------------------------------------------- > > Key: TEIID-3168 > URL: https://issues.jboss.org/browse/TEIID-3168 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 6.0.0 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9, 7.7.12 > > > SQL Server requires the use of the N prefix for string literals when there are non-ascii/windows characters present. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3112) Incorrect plural name with parent to child join

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3112?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3112. --------------------------------- > Incorrect plural name with parent to child join > ----------------------------------------------- > > Key: TEIID-3112 > URL: https://issues.jboss.org/browse/TEIID-3112 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > The salesforce logic assumes the plural name can be created with just an 's' at the end, however objects such as Opportunity do not follow that pattern. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3104) ArrayImpl toString not correct

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3104?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3104. --------------------------------- > ArrayImpl toString not correct > ------------------------------ > > Key: TEIID-3104 > URL: https://issues.jboss.org/browse/TEIID-3104 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > The arrayimpl tostring is not correct for multi-dimensional arrays and does not follow the convention of appending a trailing comma for arrays of less than 2 elements. Typically this tostring is not seen as there is the Array expression class, but source sql can contain ArrayImpl values. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3152) result set close after session close reported as an error

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3152?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3152. --------------------------------- > result set close after session close reported as an error > --------------------------------------------------------- > > Key: TEIID-3152 > URL: https://issues.jboss.org/browse/TEIID-3152 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > > An invalid session exception will be recorded as an error rather than a warning. This is due to the exceptionutil converting inappropriately converting the exception into a teiid component exception. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3130) NPE in excel translator if xlsx file is missing

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3130?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3130. --------------------------------- > NPE in excel translator if xlsx file is missing > ----------------------------------------------- > > Key: TEIID-3130 > URL: https://issues.jboss.org/browse/TEIID-3130 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.7 > Environment: OS: fedora20 > arch: x86_64 > java: sun 1.7 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.9 > > Attachments: NPE_missing_excel_file.zip > > > If xlsx file, which is pointed by resource adater & source model (in VDB) is missing, then any query ends with NPE. > Actual result: NullPointerException > Expected result: some better message or exception (e.g. FileNotFoundException or some TeiidException with good mesage) -- This message was sent by Atlassian JIRA (v6.3.1#6329)

9 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues October 2014