April 2019 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5618) clientHostName always reported as localhost via JDBC connection

by Andrej Smigala (Jira)

[ https://issues.jboss.org/browse/TEIID-5618?page=com.atlassian.jira.plugin... ] Andrej Smigala updated TEIID-5618: ---------------------------------- Attachment: (was: screenshot-1.png) > clientHostName always reported as localhost via JDBC connection > --------------------------------------------------------------- > > Key: TEIID-5618 > URL: https://issues.jboss.org/browse/TEIID-5618 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.16.6_4 > Reporter: Deborah Steigner > Assignee: Steven Hawkins > Priority: Major > Fix For: 8.12.17.6_4, 12.1 > > > VDB session information in the Management Console and logs shows localhost for Client Host Name with a JDBC connection. > Client Host Name: localhost > Client Hardware Address: 4CBB58502284 > IP Address: > Security Domain: teiid-security > In the server.log with org.teiid set to TRACE it displays below for session: > DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful, created session: sessionid=DW9hzUw5P1ob; userName=teiidUser@teiid-security; vdbName=deb_pg; vdbVersion=2; createdTime=Thu Jan 17 08:15:44 CST 2019; applicationName=JDBC; clientHostName=localhost; clientHardwareAddress=4CBB58502284; IPAddress=192.168.x.x; securityDomain=teiid-security; lastPingTime=Thu Jan 17 08:15:44 CST 2019 -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5618) clientHostName always reported as localhost via JDBC connection

by Andrej Smigala (Jira)

[ https://issues.jboss.org/browse/TEIID-5618?page=com.atlassian.jira.plugin... ] Andrej Smigala updated TEIID-5618: ---------------------------------- Attachment: screenshot-1.png > clientHostName always reported as localhost via JDBC connection > --------------------------------------------------------------- > > Key: TEIID-5618 > URL: https://issues.jboss.org/browse/TEIID-5618 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.16.6_4 > Reporter: Deborah Steigner > Assignee: Steven Hawkins > Priority: Major > Fix For: 8.12.17.6_4, 12.1 > > Attachments: screenshot-1.png > > > VDB session information in the Management Console and logs shows localhost for Client Host Name with a JDBC connection. > Client Host Name: localhost > Client Hardware Address: 4CBB58502284 > IP Address: > Security Domain: teiid-security > In the server.log with org.teiid set to TRACE it displays below for session: > DEBUG [org.teiid.SECURITY] (New I/O worker #2) Logon successful, created session: sessionid=DW9hzUw5P1ob; userName=teiidUser@teiid-security; vdbName=deb_pg; vdbVersion=2; createdTime=Thu Jan 17 08:15:44 CST 2019; applicationName=JDBC; clientHostName=localhost; clientHardwareAddress=4CBB58502284; IPAddress=192.168.x.x; securityDomain=teiid-security; lastPingTime=Thu Jan 17 08:15:44 CST 2019 -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5727) Add bound functions and procedures to Teiid

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5727?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-5727: ------------------------------------- Assignee: (was: Steven Hawkins) > Add bound functions and procedures to Teiid > ------------------------------------------- > > Key: TEIID-5727 > URL: https://issues.jboss.org/browse/TEIID-5727 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Priority: Optional > Fix For: Open To Community > > > As far as I understood virtual procedures and functions are unbound only in the current implementation in Teiid. Would be nice if there would be a option to have bound (to entities and entity sets) procedures and functions as well. > This would allow for some more syntactic sugar and would allow for a closer integration with libraries such as SAPUI5. See here for an example > https://sapui5.netweaver.ondemand.com/sdk/#/topic/b54f7895b7594c61a83fa72... -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5727) Add bound functions and procedures to Teiid

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5727?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-5727: ---------------------------------- Fix Version/s: Open To Community > Add bound functions and procedures to Teiid > ------------------------------------------- > > Key: TEIID-5727 > URL: https://issues.jboss.org/browse/TEIID-5727 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Optional > Fix For: Open To Community > > > As far as I understood virtual procedures and functions are unbound only in the current implementation in Teiid. Would be nice if there would be a option to have bound (to entities and entity sets) procedures and functions as well. > This would allow for some more syntactic sugar and would allow for a closer integration with libraries such as SAPUI5. See here for an example > https://sapui5.netweaver.ondemand.com/sdk/#/topic/b54f7895b7594c61a83fa72... -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5725: --------------------------------------- > And one further question, do I need to drop the temporary table after I am finished? An implicitly created # temp table is a Teiid local temporary table. Teiid local temporary tables will be dropped when their containing procedure block completes, or when the session ends if they are created at the top level. > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5725: --------------------------------------- Well supporting VS Code would be very helpful indeed. However, I assume once the support is there, I will have learned the syntax :) > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Steven Hawkins (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5725: --------------------------------------- > I do not like this trail and error principle. Teiid Designer was the path for helping with editing. Ideally we'll explore VS Code for VDB authoring in the near term. > Is the SQL syntax implemented in TEIID something custom? The procedure language was developed many years ago loosely based upon pl/sql, and also influenced by SQL Server (select into, option clause, etc.). > I have red in the docs it would adhere to sql-92 syntax The DML part follows SQL 92 and later closely. Newer elements of the procedure language followed the spec more closely, but ultimately it's custom. > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John edited comment on TEIID-5725 at 4/23/19 4:32 PM: ---------------------------------------------------------------- Thanks a lot Steven, I am currently reading through the SQL documentation and try to get different things working. However, whatever I am trying my syntax always seems to be wrong. I do not like this trail and error principle. Is the SQL syntax implemented in TEIID something custom? Or does it adhere to a standard, I have red in the docs it would adhere to sql-92 syntax. Is this really the case? In that case I have to find different tutorials :) And one further question, do I need to drop the temporary table after I am finished? was (Author: cjohn001): Thanks a lot Steven, I am currently reading through the SQL documentation and try to get different things working. However, whatever I am trying my syntax always seems to be wrong. I do not like this trail and error principle. Is the SQL syntax implemented in TEIID something custom? Or does it adhere to a standard, I have red in the docs it would adhere to sql-92 syntax. Is this really the case? In that case I have to find different tutorials :) > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John commented on TEIID-5725: --------------------------------------- Thanks a lot Steven, I am currently reading through the SQL documentation and try to get different things working. However, whatever I am trying my syntax always seems to be wrong. I do not like this trail and error principle. Is the SQL syntax implemented in TEIID something custom? Or does it adhere to a standard, I have red in the docks it would adhere to sql-92 syntax. Is this really the case? In that case I have to find different tutorials :) > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5725) Please improve documentation on definition of stored procedures, virtual functions and virtual procedures

by Christoph John (Jira)

[ https://issues.jboss.org/browse/TEIID-5725?page=com.atlassian.jira.plugin... ] Christoph John edited comment on TEIID-5725 at 4/23/19 4:24 PM: ---------------------------------------------------------------- Thanks a lot Steven, I am currently reading through the SQL documentation and try to get different things working. However, whatever I am trying my syntax always seems to be wrong. I do not like this trail and error principle. Is the SQL syntax implemented in TEIID something custom? Or does it adhere to a standard, I have red in the docs it would adhere to sql-92 syntax. Is this really the case? In that case I have to find different tutorials :) was (Author: cjohn001): Thanks a lot Steven, I am currently reading through the SQL documentation and try to get different things working. However, whatever I am trying my syntax always seems to be wrong. I do not like this trail and error principle. Is the SQL syntax implemented in TEIID something custom? Or does it adhere to a standard, I have red in the docks it would adhere to sql-92 syntax. Is this really the case? In that case I have to find different tutorials :) > Please improve documentation on definition of stored procedures, virtual functions and virtual procedures > --------------------------------------------------------------------------------------------------------- > > Key: TEIID-5725 > URL: https://issues.jboss.org/browse/TEIID-5725 > Project: Teiid > Issue Type: Enhancement > Reporter: Christoph John > Assignee: Steven Hawkins > Priority: Critical > > I refer to the discussion with Ramesh in > https://developer.jboss.org/message/989048#989048 and would like to ask for a more detailed explanation on how to write virtual procedures and functions. > -Especially, how are OUT and INOUT params set and how can they be obtained via odata. > - How is the return value of a virtual function set? > - How are collections and arrays of collections returned? -- This message was sent by Atlassian Jira (v7.12.1#712002)

5 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues April 2019