January 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-2798) Add creation of view when exposing metadata via Object translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2798?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2798. ----------------------------------- Resolution: Rejected Look at the logic that is already in the translator. It is not necessary to create an OBJECTTABLE view - the basic functionality is already built-in. > Add creation of view when exposing metadata via Object translator > ----------------------------------------------------------------- > > Key: TEIID-2798 > URL: https://issues.jboss.org/browse/TEIID-2798 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > > When the metadata is exposed for the java object via the Object translator, a view should also be created using a template similar to: > SELECT > t.{pkKeyField}, o.{colname}, o.{colname} > FROM Order > {ObjectSourceTable} as T, > OBJECTTABLE('x' PASSING T.{ObjectTypeName}Object as x COLUMNS > {colname} {type} 'teiid_row.{colname}', ….) as o > where > {pkKeyField} is the primary key column to the cache > {ObjectSourceTable} is the source table imported above > {ObjectTypeName} is the column added in {ObjectSourceTable} to reference the cache object > {colname} is the name of the columns that have “get” methods, see the {ObjectSourceTable} for columns to use > {type} is the data type for this column -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2797) buffer full requests is not cleaned up properly

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2797?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-2797. ----------------------------------- Resolution: Done Switched the buffer full tracking to just the request ids to further minimize the tracking risk. > buffer full requests is not cleaned up properly > ----------------------------------------------- > > Key: TEIID-2797 > URL: https://issues.jboss.org/browse/TEIID-2797 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.7 > > Attachments: TEIID-2797.patch > > > buffer full plans are held as the full work item, but we are cleaning them up by the request id. This means that the full plans will accumulate over time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2798) Add creation of view when exposing metadata via Object translator

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2798?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-2798: ------------------------------------ hm, confused. If the user has to create a view with OBJECTTABLE to expose the java object via view, it would appear we could create that. Is there an alternative to using the OBJECTTABLE? > Add creation of view when exposing metadata via Object translator > ----------------------------------------------------------------- > > Key: TEIID-2798 > URL: https://issues.jboss.org/browse/TEIID-2798 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > > When the metadata is exposed for the java object via the Object translator, a view should also be created using a template similar to: > SELECT > t.{pkKeyField}, o.{colname}, o.{colname} > FROM Order > {ObjectSourceTable} as T, > OBJECTTABLE('x' PASSING T.{ObjectTypeName}Object as x COLUMNS > {colname} {type} 'teiid_row.{colname}', ….) as o > where > {pkKeyField} is the primary key column to the cache > {ObjectSourceTable} is the source table imported above > {ObjectTypeName} is the column added in {ObjectSourceTable} to reference the cache object > {colname} is the name of the columns that have “get” methods, see the {ObjectSourceTable} for columns to use > {type} is the data type for this column -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2798) Add creation of view when exposing metadata via Object translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2798?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-2798: --------------------------------------- That doesn't seem necessary given that the object translator does already has the get logic. It looks like the metadata routine is already correct. > Add creation of view when exposing metadata via Object translator > ----------------------------------------------------------------- > > Key: TEIID-2798 > URL: https://issues.jboss.org/browse/TEIID-2798 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > > When the metadata is exposed for the java object via the Object translator, a view should also be created using a template similar to: > SELECT > t.{pkKeyField}, o.{colname}, o.{colname} > FROM Order > {ObjectSourceTable} as T, > OBJECTTABLE('x' PASSING T.{ObjectTypeName}Object as x COLUMNS > {colname} {type} 'teiid_row.{colname}', ….) as o > where > {pkKeyField} is the primary key column to the cache > {ObjectSourceTable} is the source table imported above > {ObjectTypeName} is the column added in {ObjectSourceTable} to reference the cache object > {colname} is the name of the columns that have “get” methods, see the {ObjectSourceTable} for columns to use > {type} is the data type for this column -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2797) buffer full requests is not cleaned up properly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2797?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-2797: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1051562|https://bugzilla.redhat.com/show_bug.cgi?id=1051562] from NEW to ASSIGNED > buffer full requests is not cleaned up properly > ----------------------------------------------- > > Key: TEIID-2797 > URL: https://issues.jboss.org/browse/TEIID-2797 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.7 > > Attachments: TEIID-2797.patch > > > buffer full plans are held as the full work item, but we are cleaning them up by the request id. This means that the full plans will accumulate over time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2797) buffer full requests is not cleaned up properly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2797?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2797: ------------------------------------------- Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1051532, https://bugzilla.redhat.com/show_bug.cgi?id=1051562 (was: https://bugzilla.redhat.com/show_bug.cgi?id=1051532) > buffer full requests is not cleaned up properly > ----------------------------------------------- > > Key: TEIID-2797 > URL: https://issues.jboss.org/browse/TEIID-2797 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.7 > > Attachments: TEIID-2797.patch > > > buffer full plans are held as the full work item, but we are cleaning them up by the request id. This means that the full plans will accumulate over time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2798) Add creation of view when exposing metadata via Object translator

by Van Halbert (JIRA)

Van Halbert created TEIID-2798: ---------------------------------- Summary: Add creation of view when exposing metadata via Object translator Key: TEIID-2798 URL: https://issues.jboss.org/browse/TEIID-2798 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Affects Versions: 8.4.1 Reporter: Van Halbert Assignee: Van Halbert When the metadata is exposed for the java object via the Object translator, a view should also be created using a template similar to: SELECT t.{pkKeyField}, o.{colname}, o.{colname} FROM Order {ObjectSourceTable} as T, OBJECTTABLE('x' PASSING T.{ObjectTypeName}Object as x COLUMNS {colname} {type} 'teiid_row.{colname}', ….) as o where {pkKeyField} is the primary key column to the cache {ObjectSourceTable} is the source table imported above {ObjectTypeName} is the column added in {ObjectSourceTable} to reference the cache object {colname} is the name of the columns that have “get” methods, see the {ObjectSourceTable} for columns to use {type} is the data type for this column -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2797) buffer full requests is not cleaned up properly

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-2797?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-2797: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1051532 > buffer full requests is not cleaned up properly > ----------------------------------------------- > > Key: TEIID-2797 > URL: https://issues.jboss.org/browse/TEIID-2797 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.7 > > Attachments: TEIID-2797.patch > > > buffer full plans are held as the full work item, but we are cleaning them up by the request id. This means that the full plans will accumulate over time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2797) buffer full requests is not cleaned up properly

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2797?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-2797: ---------------------------------- Attachment: TEIID-2797.patch Minimal 7.7.x patch > buffer full requests is not cleaned up properly > ----------------------------------------------- > > Key: TEIID-2797 > URL: https://issues.jboss.org/browse/TEIID-2797 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.4 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.7 > > Attachments: TEIID-2797.patch > > > buffer full plans are held as the full work item, but we are cleaning them up by the request id. This means that the full plans will accumulate over time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2797) buffer full requests is not cleaned up properly

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-2797: ------------------------------------- Summary: buffer full requests is not cleaned up properly Key: TEIID-2797 URL: https://issues.jboss.org/browse/TEIID-2797 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.4 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Critical Fix For: 8.7 buffer full plans are held as the full work item, but we are cleaning them up by the request id. This means that the full plans will accumulate over time. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

10 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 January 2014