March 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3331) Problem with dynamic vdb column metadata - for salesforce source w/import property

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3331?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3331. --------------------------------- > Problem with dynamic vdb column metadata - for salesforce source w/import property > ---------------------------------------------------------------------------------- > > Key: TEIID-3331 > URL: https://issues.jboss.org/browse/TEIID-3331 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.7 > Reporter: Mark Drilling > Assignee: Ramesh Reddy > Labels: CR2 > Fix For: 8.10 > > Attachments: SFVdb-vdb.xml > > > There seems to be a problem with the column metadata for dynamic vdb with salesforce source. Here is my scenario. > 1) Deploy dynamic vdb w/SF source (attached sample). The VDB sets the 'importer.ModelAuditFields' property to 'true'. > 2) expose the vdb as a jdbc source, then connect to it. > 3) get the column metadata for a table using > connection.getMetaData().getColumns(null, null, fullTableName, null) > When the vdb has 'importer.ModelAuditFields' = true, some of the columns are missing. Here is a comparison for one of the SF tables > AccountFeed, (importer.modelAuditFields=false) > -------------- > Id, ParentId, Type, IsDeleted, CommentCount, LikeCount > AccountFeed, (importer.modelAuditFields=true) > -------------- > Id, ParentId, Type, CreatedById, CreatedDate, IsDeleted > with modelAuditFields=true, the audit fields (CreatedById, CreatedDate) are added, but CommentCount and LikeCount are missing. It seems to clip to the same number of cols as the modelAuditFields=false case. > Second issue (minor) > ----------------- > The display name for the property is slightly wrong. > line 75 of SalesForceExecutionFactory is 'Audit Model Fields' - it should be 'Model Audit Fields'. > line 362 of SalesForceMetadataProcessor - same thing. also suggest changing the description to something like 'Determines if the salesforce audit fields are modeled' -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3136) Possible threading issues with index metadata loading

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3136?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3136. --------------------------------- > Possible threading issues with index metadata loading > ----------------------------------------------------- > > Key: TEIID-3136 > URL: https://issues.jboss.org/browse/TEIID-3136 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.1, 8.4.4, 8.9 > > > Index metadata can be processed by several threads such that the modifications may not be seen appropriately by other threads. This could include the materialization table not being set appropriately and model not found errors. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3339) Adding the multisource column does not work with variadic procedures

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3339?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3339. --------------------------------- > Adding the multisource column does not work with variadic procedures > -------------------------------------------------------------------- > > Key: TEIID-3339 > URL: https://issues.jboss.org/browse/TEIID-3339 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.7 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > Adding the multi-source column as the last parameter to a variadic procedure results in a validation exception. Options to resolve this include adding the parameter as the second to last, not allowing the procedure to have a multi-source parameter, or choosing a different paradigm - such as call procname_source... -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3333) Dynamic VDB deployment - JDBCMetadataProcessor NPE

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3333?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3333. --------------------------------- > Dynamic VDB deployment - JDBCMetadataProcessor NPE > -------------------------------------------------- > > Key: TEIID-3333 > URL: https://issues.jboss.org/browse/TEIID-3333 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Affects Versions: 8.7 > Reporter: Mark Drilling > Assignee: Steven Hawkins > Fix For: 8.10 > > Attachments: bad-vdb.xml > > > I am getting NPE in JDBCMetadataProcessor for the attached dynamic VDB deployment in teiid 8.7 (DV61). This VDB uses the DashboardDS H2 source that comes installed with DV61. > The NPE happens with this specific import property > <property name="importer.TableNamePattern" value="DASHB_A%"/> > The table name pattern is valid - there is a table named DASHB_ALLOWED_PANEL. > If you change the pattern to DASHB_D%, the deployment is successful. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3340) JDBC direct query execution binding is incorrect

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3340?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3340. --------------------------------- > JDBC direct query execution binding is incorrect > ------------------------------------------------ > > Key: TEIID-3340 > URL: https://issues.jboss.org/browse/TEIID-3340 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 8.2 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.10 > > > The binding logic is passing the literal and the 0 based index, when it should be passing the literal value and the 1 based index. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3365) Update settings.xml to reflect JBoss maven repository changes

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3365?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3365. --------------------------------- > Update settings.xml to reflect JBoss maven repository changes > -------------------------------------------------------------- > > Key: TEIID-3365 > URL: https://issues.jboss.org/browse/TEIID-3365 > Project: Teiid > Issue Type: Task > Affects Versions: 8.10 > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Fix For: 8.10, 8.11 > > > Details are defined here https://access.redhat.com/maven-repository > For this technology preview, there are a set of Maven repositories. You can choose between the general availability (GA) repository and the early-access repository (Alpha and Beta builds). > General availability repository: https://maven.repository.redhat.com/techpreview/all/ > Early-access repository: https://maven.repository.redhat.com/earlyaccess/all/ -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2877) Add support for MariaDB as a data source

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2877?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2877. --------------------------------- > Add support for MariaDB as a data source > ---------------------------------------- > > Key: TEIID-2877 > URL: https://issues.jboss.org/browse/TEIID-2877 > Project: Teiid > Issue Type: Feature Request > Components: Misc. Connectors > Reporter: Van Halbert > Fix For: 8.7.1 > > > Red Hat will be making MariaDB its default DBMS in its next major Red Hat Enterprise Linux (RHEL) release. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3281) MongoDB: EmptyStackException when joining tables

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3281?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3281. --------------------------------- > MongoDB: EmptyStackException when joining tables > ------------------------------------------------ > > Key: TEIID-3281 > URL: https://issues.jboss.org/browse/TEIID-3281 > Project: Teiid > Issue Type: Bug > Components: Connector API > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: CR2 > Fix For: 8.10 > > Attachments: mongodb-vdb.xml, server.log > > > Teiid throws java.util.EmptyStackException when joining data from table which has teiid_mongo:MERGE property enabled. > Example: > {code} > insert into customer2 values(1,'Pepa', 'Koukal'); > insert into customer2 values(2,'Jan', 'Tlemil'); > insert into Address values(1,1,'Pepas Street','Pepas City','Pepas State', 'Pepas zipcode'); > insert into Address values(2,2,'Jans Street','Pepa','Jans State', 'Jans zipcode'); > {code} > {code} > select a.*,b.* from customer2 a inner join Address b on a.CustomerId=b.CustomerId order by a.customerID > {code} > {code} > Error: > java.util.EmptyStackException > at java.util.Stack.peek(Stack.java:102) > at java.util.Stack.pop(Stack.java:84) > at org.teiid.translator.mongodb.MongoDBSelectVisitor.visit(MongoDBSelectVisitor.java:993) > at org.teiid.language.SortSpecification.acceptVisitor(SortSpecification.java:53) > at org.teiid.language.visitor.AbstractLanguageVisitor.visitNode(AbstractLanguageVisitor.java:51) > at org.teiid.translator.mongodb.MongoDBSelectVisitor.append(MongoDBSelectVisitor.java:112) > {code} > VDB and log are in the attachment. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-3300) Add SPATIAL_REF_SYS table

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3300?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3300. --------------------------------- > Add SPATIAL_REF_SYS table > ------------------------- > > Key: TEIID-3300 > URL: https://issues.jboss.org/browse/TEIID-3300 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Tom Arnold > Assignee: Steven Hawkins > Labels: spatial > Fix For: 8.10 > > > Implement SPATIAL_REF_SYS table (from the OGC Simple Features spec). This table stores metadata about different coordinate systems and how to tranform between them. See [here|http://en.wikipedia.org/wiki/SRID] and [here|http://www.carocoops.org/resources/doc/postgis/x321.html] for details. > {code} > CREATE TABLE SPATIAL_REF_SYS > ( > SRID INTEGER NOT NULL PRIMARY KEY, > AUTH_NAME CHARACTER VARYING(256), > AUTH_SRID INTEGER, > SRTEXT CHARACTER VARYING(2048) > ) > {code} > https://raw.githubusercontent.com/postgis/postgis/svn-trunk/spatial_ref_s... > This would be used in conjunction with the GeoTools referencing module or Proj4J to transform between coordinate systems in Teiid (ST_Transform function). -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

[JBoss JIRA] (TEIID-2694) Support for Blob Input in Teiid REST services

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2694?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2694. --------------------------------- > Support for Blob Input in Teiid REST services > --------------------------------------------- > > Key: TEIID-2694 > URL: https://issues.jboss.org/browse/TEIID-2694 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.5 > Environment: EAP 6.1 Alpha , Teiid 8.5 > Reporter: Madhu Garimilla > Assignee: Ramesh Reddy > Labels: Final > Fix For: 8.10 > > > We are trying to upload large files as Blobs using Teiid REST service through VDB. Though we are writing the Blob objects to HttpUrlConnection object, it is not received on REST method. As per the conversation in the thread "https://community.jboss.org/thread/232840" Current parameter handling is done through strings and needs be enhanced to support Blob objects. -- This message was sent by Atlassian JIRA (v6.3.11#6341)

11 years

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2015