[JBoss JIRA] (TEIID-5201) Update teiid pg_type schema to match PostgreSQL pg_type in support of NPGsql provider
by Divyesh Vallabh (JIRA)
[ https://issues.jboss.org/browse/TEIID-5201?page=com.atlassian.jira.plugin... ]
Divyesh Vallabh commented on TEIID-5201:
----------------------------------------
I've attached an extract of log that contains the sql its trying to execute. [^information_schema.log]
> Ah, I had only checked on the pg_ tables mentioned in the issue. That would require an additional system schema, so we'll have to give some thought to the ramifications.
I was hoping the pg_ tables would have been sufficient to generate the meta information for tables and views, but it seems the provider uses the information_schema instead. Doing some research it seems there is a way to use PowerBi advance query features to extract the data vs using the wizards.
If you agree I think this issue can still be marked as resolved because these changes does allow for a session to be created and queries be executed against any vdb using the npgsql provider. A separate issue can be created for tracking the information_schema support so meta information can be queried.
> Update teiid pg_type schema to match PostgreSQL pg_type in support of NPGsql provider
> -------------------------------------------------------------------------------------
>
> Key: TEIID-5201
> URL: https://issues.jboss.org/browse/TEIID-5201
> Project: Teiid
> Issue Type: Bug
> Components: ODBC, Query Engine
> Reporter: Divyesh Vallabh
> Assignee: Steven Hawkins
> Attachments: babynametest.zip, information_schema.log
>
>
> When using NpgSQL provider to connect to Teiid the connection fails because the teiid.pg_type table does not contain the column "typreceive"
> Add missing columns from Postgres.pg_type (https://www.postgresql.org/docs/9.2/static/catalog-pg-type.html) to teiid
> Add missing columns from Postgres.pg_user (https://www.postgresql.org/docs/9.2/static/view-pg-user.html) to teiid
> Add missing columns from Postgres.pg_constraint (https://www.postgresql.org/docs/9.2/static/catalog-pg-constraint.html) to teiid
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 2 months
[JBoss JIRA] (TEIID-5219) Doc Update - Security Protocols
by Jan Stastny (JIRA)
[ https://issues.jboss.org/browse/TEIID-5219?page=com.atlassian.jira.plugin... ]
Jan Stastny commented on TEIID-5219:
------------------------------------
I also think, that the names of transports are jdbc + odbc, not teiid +pg as present in:
{quote}
There are two types of remote transports, each with it’s own encryption configuration:
"teiid" - Defaults to only encrypt login traffic, in which none of the other configuration properties are used.
"pg" - Defaults to no SSL
{quote}
> Doc Update - Security Protocols
> -------------------------------
>
> Key: TEIID-5219
> URL: https://issues.jboss.org/browse/TEIID-5219
> Project: Teiid
> Issue Type: Task
> Components: Documentation
> Affects Versions: 10.x
> Reporter: Van Halbert
> Assignee: Van Halbert
> Priority: Minor
>
> Update the security protocol section to include the "odata" protocol, see [Security Protocol Section|https://teiid.gitbooks.io/documents/content/security/Teiid_Server_Transport_Security.html] Also, add examples.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 2 months
[JBoss JIRA] (TEIID-5216) JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-5216?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-5216:
-------------------------------------
I believe unless it is a containment I did all as separate tables if the metadata for them defined in separate entity/complex types, that way I could handle querying for collection and single entity similarly with expand. But what I see is missing is
1) I stopped at creating single navigation per entity
2) The join columns (psedeo) columns were not correctly have been used do a expand.
So far with the cursory look, I got that far, I will look more today.
> JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
> --------------------------------------------------------------------
>
> Key: TEIID-5216
> URL: https://issues.jboss.org/browse/TEIID-5216
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 9.2.1
> Environment: All
> Reporter: Pushkar Kamra
> Assignee: Steven Hawkins
> Fix For: 10.1
>
> Attachments: screenshot-1.png
>
>
> During the time of requesting ODatatype - DateTimeOffset from the from the following service - http://services.odata.org/V4/Northwind/Northwind.svc/
> Query - Select * from Employees.
> Using the above query it is unable to return DateTimeOffset values for it and returns the
> following error -
> java.lang.IllegalArgumentException: No enum constant org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.TimeOffset
> at java.lang.Enum.valueOf(Enum.java:238)
> at org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.valueOf(EdmPrimitiveTypeKind.java:24)
> at org.teiid.olingo.common.ODataTypeManager.parseLiteral(ODataTypeManager.java:332)
> at org.teiid.olingo.common.ODataTypeManager.convertToTeiidRuntimeType(ODataTypeManager.java:184)
> at org.teiid.translator.odata4.BaseQueryExecution.buildRow(BaseQueryExecution.java:244)
> at org.teiid.translator.odata4.ODataQueryExecution.next(ODataQueryExecution.java:122)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:238)
> at sun.reflect.GeneratedMethodAccessor480.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
> at com.sun.proxy.$Proxy398.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> From the initial level analysis and observation is has been observed teiid class - ODataTypeManager in that parselitreals method where ODatatype.Substring(4) is done which is causing the issue which is changing DateTimeOffset to TimeOffset and when it tries to find the Enum constant from the EdmPrimitiveTypeKind list it is unable find the changed name and this seems to be causing the issue in accessing the DateTimeOffset type datas from the containing tables.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 2 months
[JBoss JIRA] (TEIID-5216) JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5216?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-5216:
----------------------------------
Fix Version/s: 10.1
> JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
> --------------------------------------------------------------------
>
> Key: TEIID-5216
> URL: https://issues.jboss.org/browse/TEIID-5216
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 9.2.1
> Environment: All
> Reporter: Pushkar Kamra
> Assignee: Steven Hawkins
> Fix For: 10.1
>
> Attachments: screenshot-1.png
>
>
> During the time of requesting ODatatype - DateTimeOffset from the from the following service - http://services.odata.org/V4/Northwind/Northwind.svc/
> Query - Select * from Employees.
> Using the above query it is unable to return DateTimeOffset values for it and returns the
> following error -
> java.lang.IllegalArgumentException: No enum constant org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.TimeOffset
> at java.lang.Enum.valueOf(Enum.java:238)
> at org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.valueOf(EdmPrimitiveTypeKind.java:24)
> at org.teiid.olingo.common.ODataTypeManager.parseLiteral(ODataTypeManager.java:332)
> at org.teiid.olingo.common.ODataTypeManager.convertToTeiidRuntimeType(ODataTypeManager.java:184)
> at org.teiid.translator.odata4.BaseQueryExecution.buildRow(BaseQueryExecution.java:244)
> at org.teiid.translator.odata4.ODataQueryExecution.next(ODataQueryExecution.java:122)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:238)
> at sun.reflect.GeneratedMethodAccessor480.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
> at com.sun.proxy.$Proxy398.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> From the initial level analysis and observation is has been observed teiid class - ODataTypeManager in that parselitreals method where ODatatype.Substring(4) is done which is causing the issue which is changing DateTimeOffset to TimeOffset and when it tries to find the Enum constant from the EdmPrimitiveTypeKind list it is unable find the changed name and this seems to be causing the issue in accessing the DateTimeOffset type datas from the containing tables.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 2 months
[JBoss JIRA] (TEIID-5216) JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5216?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-5216:
---------------------------------------
[~rareddy] Do you recall why a table is used to represent a 1-1 navigation?
> JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
> --------------------------------------------------------------------
>
> Key: TEIID-5216
> URL: https://issues.jboss.org/browse/TEIID-5216
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 9.2.1
> Environment: All
> Reporter: Pushkar Kamra
> Assignee: Steven Hawkins
> Attachments: screenshot-1.png
>
>
> During the time of requesting ODatatype - DateTimeOffset from the from the following service - http://services.odata.org/V4/Northwind/Northwind.svc/
> Query - Select * from Employees.
> Using the above query it is unable to return DateTimeOffset values for it and returns the
> following error -
> java.lang.IllegalArgumentException: No enum constant org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.TimeOffset
> at java.lang.Enum.valueOf(Enum.java:238)
> at org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.valueOf(EdmPrimitiveTypeKind.java:24)
> at org.teiid.olingo.common.ODataTypeManager.parseLiteral(ODataTypeManager.java:332)
> at org.teiid.olingo.common.ODataTypeManager.convertToTeiidRuntimeType(ODataTypeManager.java:184)
> at org.teiid.translator.odata4.BaseQueryExecution.buildRow(BaseQueryExecution.java:244)
> at org.teiid.translator.odata4.ODataQueryExecution.next(ODataQueryExecution.java:122)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:238)
> at sun.reflect.GeneratedMethodAccessor480.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
> at com.sun.proxy.$Proxy398.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> From the initial level analysis and observation is has been observed teiid class - ODataTypeManager in that parselitreals method where ODatatype.Substring(4) is done which is causing the issue which is changing DateTimeOffset to TimeOffset and when it tries to find the Enum constant from the EdmPrimitiveTypeKind list it is unable find the changed name and this seems to be causing the issue in accessing the DateTimeOffset type datas from the containing tables.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 2 months
[JBoss JIRA] (TEIID-5219) Doc Update - Security Protocols
by Van Halbert (JIRA)
Van Halbert created TEIID-5219:
----------------------------------
Summary: Doc Update - Security Protocols
Key: TEIID-5219
URL: https://issues.jboss.org/browse/TEIID-5219
Project: Teiid
Issue Type: Task
Components: Documentation
Affects Versions: 10.x
Reporter: Van Halbert
Assignee: Steven Hawkins
Priority: Minor
Update the security protocol section to include the "odata" protocol, see [Security Protocol Section|https://teiid.gitbooks.io/documents/content/security/Teiid_Server_Transport_Security.html] Also, add examples.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 2 months
[JBoss JIRA] (TEIID-4380) ODatat 4 deep insert works for only a single expand level
by Maximilián Košiarčik (JIRA)
[ https://issues.jboss.org/browse/TEIID-4380?page=com.atlassian.jira.plugin... ]
Maximilián Košiarčik commented on TEIID-4380:
---------------------------------------------
[~shawkins] To which level should the expand in insert work?
I am trying to insert the following entity:
{code:json}
{ "employee_id":1,
"name": "President",
"manager_id":1,
"Employee_FK0": [
{"employee_id" : 2,
"name": "Vice-President",
"manager_id" : 1,
"Employee_FK0":
[
{"employee_id" : 3,
"name": "Manager",
"manager_id" : 2
}
]
}
]
}
{code}
And it gives me the following error: Employee_FKO can not be mapped as a property or an annotation.
> ODatat 4 deep insert works for only a single expand level
> ---------------------------------------------------------
>
> Key: TEIID-4380
> URL: https://issues.jboss.org/browse/TEIID-4380
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 9.1, 8.12.x-6.4
>
>
> Inserting an entity with a graph more complicated than a single expand won't work as expected - in most cases an exception will be thrown after the inserts are performed / committed.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 2 months
[JBoss JIRA] (TEIID-5216) JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
by Pushkar Kamra (JIRA)
[ https://issues.jboss.org/browse/TEIID-5216?page=com.atlassian.jira.plugin... ]
Pushkar Kamra commented on TEIID-5216:
--------------------------------------
Hello Steven,
Verified the code on the lateral branch as well and issue seems to be persisting in it too.
Attached, the screenshot for reference.
> JBOSS - Teiid 9.2.1 unable to return DateTimeOffset ODatatype values
> --------------------------------------------------------------------
>
> Key: TEIID-5216
> URL: https://issues.jboss.org/browse/TEIID-5216
> Project: Teiid
> Issue Type: Bug
> Components: OData
> Affects Versions: 9.2.1
> Environment: All
> Reporter: Pushkar Kamra
> Assignee: Steven Hawkins
> Attachments: screenshot-1.png
>
>
> During the time of requesting ODatatype - DateTimeOffset from the from the following service - http://services.odata.org/V4/Northwind/Northwind.svc/
> Query - Select * from Employees.
> Using the above query it is unable to return DateTimeOffset values for it and returns the
> following error -
> java.lang.IllegalArgumentException: No enum constant org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.TimeOffset
> at java.lang.Enum.valueOf(Enum.java:238)
> at org.apache.olingo.commons.api.edm.EdmPrimitiveTypeKind.valueOf(EdmPrimitiveTypeKind.java:24)
> at org.teiid.olingo.common.ODataTypeManager.parseLiteral(ODataTypeManager.java:332)
> at org.teiid.olingo.common.ODataTypeManager.convertToTeiidRuntimeType(ODataTypeManager.java:184)
> at org.teiid.translator.odata4.BaseQueryExecution.buildRow(BaseQueryExecution.java:244)
> at org.teiid.translator.odata4.ODataQueryExecution.next(ODataQueryExecution.java:122)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.handleBatch(ConnectorWorkItem.java:435)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.more(ConnectorWorkItem.java:238)
> at sun.reflect.GeneratedMethodAccessor480.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
> at com.sun.proxy.$Proxy398.more(Unknown Source)
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:309)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
> From the initial level analysis and observation is has been observed teiid class - ODataTypeManager in that parselitreals method where ODatatype.Substring(4) is done which is causing the issue which is changing DateTimeOffset to TimeOffset and when it tries to find the Enum constant from the EdmPrimitiveTypeKind list it is unable find the changed name and this seems to be causing the issue in accessing the DateTimeOffset type datas from the containing tables.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
8 years, 2 months