May 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3478) A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3478?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3478. ----------------------------------- Resolution: Duplicate Issue Resolving as a duplicate, but I also updated the code to make the intention of the criteria handling more clear. Also added missing tests for includes/excludes. > A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause. > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-3478 > URL: https://issues.jboss.org/browse/TEIID-3478 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Pranav K > Assignee: Steven Hawkins > > A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause. (See steps to reproduce) > Log: > Caused by: javax.resource.ResourceException: [MalformedQueryFault [ApiQueryFault [ApiFault exceptionCode='MALFORMED_QUERY' > exceptionMessage=' > FROM Case WHERE Case.AccountId != NULLAccount.Name = 'LYCEE AGRICOLE > ^ > ERROR at Row:1:Column:93 > Bind variables only allowed in Apex code' > ] > row='1' > column='93' > ] > ] > > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:177) ~[connector-salesforce-8.10.0.Final-lib.jar:8.10.0.Final] > at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:138) ~[translator-salesforce-8.10.0.Final.jar:8.10.0.Final] > ... 18 common frames omitted > Caused by: com.sforce.soap.partner.fault.MalformedQueryFault: null > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_60-ea] > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_60-ea] > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_60-ea] > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_60-ea] > at java.lang.Class.newInstance(Class.java:374) ~[na:1.7.0_60-ea] > at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:229) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:203) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:149) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98) ~[force-wsc-22.0.0.jar:na] > at com.sforce.soap.partner.PartnerConnection.query(PartnerConnection.java:1335) ~[force-partner-api-22.0.0.jar:na] > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:172) ~[connector-salesforce-8.10.0.Final-lib.jar:8.10.0.Final] -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3436) Add array type support to the odata translator

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3436?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3436: --------------------------------------- Is this now addressed by the TEIID-3471 change? > Add array type support to the odata translator > ---------------------------------------------- > > Key: TEIID-3436 > URL: https://issues.jboss.org/browse/TEIID-3436 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Reporter: Steven Hawkins > > Arrays of basic types in odata responses should be convertible into a runtime array type. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3480) External Materialization status

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-3480: ----------------------------------- Summary: External Materialization status Key: TEIID-3480 URL: https://issues.jboss.org/browse/TEIID-3480 Project: Teiid Issue Type: Enhancement Components: Server Affects Versions: 8.4 Reporter: Ramesh Reddy Assignee: Steven Hawkins When external materialization is configured with "STATUS" table, then Teiid should expose those stats over CLI and in the web-console. Currently the internal materialization does show status, need to expand to the external matviews. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3471) unable to consume odata service deployed in teiid

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3471?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3471: ------------------------------------- 1) Added support for reading the array based metadata for primitive types 2) Fixed Accept header while reading a metadata from service deployed in another instance of Teiid. 3) Needed upgrade the OReva version to 0.8.2 The problem with RestEasy is still an issue, as precludes us from working nice with any other OData clients libraries. I think not think about it until just now, but I should have updated the OReva library to remove the "charset=utf-8" string from the definition of accepts header for service. I will work on release 0.8.3 with this fix. > unable to consume odata service deployed in teiid > ------------------------------------------------- > > Key: TEIID-3471 > URL: https://issues.jboss.org/browse/TEIID-3471 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Mark Drilling > Assignee: Ramesh Reddy > Attachments: deployment-exception.txt, MyVDB-vdb.xml, standalone-snippet.xml > > > I am unable to consume odata service created in teiid. > Steps to reproduce and files are attached. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3473) Selecting RAW(16) column via OData errors

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3473?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3473: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1220909|https://bugzilla.redhat.com/show_bug.cgi?id=1220909] from NEW to MODIFIED > Selecting RAW(16) column via OData errors > ----------------------------------------- > > Key: TEIID-3473 > URL: https://issues.jboss.org/browse/TEIID-3473 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.7.1.6_2, 8.11 > > > When selecting a RAW(16) column via OData, a runtime error is thrown w/ the following message: > http://superdrake:8080/odata/Medbus/reqtracking.query?$format=json > { > "error": { > "code" : "ServerErrorException", > "message": { > "lang": "en-US", > "value": "[B cannot be cast to org.teiid.core.types.BinaryType" > } > } > } -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3478) A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause.

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3478?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3478: --------------------------------------- Can you confirm if this is resolved for you with 8.11 Beta2? > A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause. > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-3478 > URL: https://issues.jboss.org/browse/TEIID-3478 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Reporter: Pranav K > Assignee: Steven Hawkins > > A malformed query is generated by Salesforce translator when a view model made over Salesforce tables, which have primarykey-foreignkey relationship, is queried with a where clause. (See steps to reproduce) > Log: > Caused by: javax.resource.ResourceException: [MalformedQueryFault [ApiQueryFault [ApiFault exceptionCode='MALFORMED_QUERY' > exceptionMessage=' > FROM Case WHERE Case.AccountId != NULLAccount.Name = 'LYCEE AGRICOLE > ^ > ERROR at Row:1:Column:93 > Bind variables only allowed in Apex code' > ] > row='1' > column='93' > ] > ] > > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:177) ~[connector-salesforce-8.10.0.Final-lib.jar:8.10.0.Final] > at org.teiid.translator.salesforce.execution.QueryExecutionImpl.execute(QueryExecutionImpl.java:138) ~[translator-salesforce-8.10.0.Final.jar:8.10.0.Final] > ... 18 common frames omitted > Caused by: com.sforce.soap.partner.fault.MalformedQueryFault: null > at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_60-ea] > at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_60-ea] > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_60-ea] > at java.lang.reflect.Constructor.newInstance(Constructor.java:526) ~[na:1.7.0_60-ea] > at java.lang.Class.newInstance(Class.java:374) ~[na:1.7.0_60-ea] > at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:229) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:203) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:149) ~[force-wsc-22.0.0.jar:na] > at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98) ~[force-wsc-22.0.0.jar:na] > at com.sforce.soap.partner.PartnerConnection.query(PartnerConnection.java:1335) ~[force-partner-api-22.0.0.jar:na] > at org.teiid.resource.adapter.salesforce.SalesforceConnectionImpl.query(SalesforceConnectionImpl.java:172) ~[connector-salesforce-8.10.0.Final-lib.jar:8.10.0.Final] -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3206) EAP 6.3 - JDBC Datasources Test Connection

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3206?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3206. ----------------------------------- Resolution: Done Marking as resolved with the switch to EAP 6.4 > EAP 6.3 - JDBC Datasources Test Connection > ------------------------------------------ > > Key: TEIID-3206 > URL: https://issues.jboss.org/browse/TEIID-3206 > Project: Teiid > Issue Type: Bug > Components: Build/Kits > Affects Versions: 8.9, 8.10 > Reporter: Tom Arnold > Assignee: Steven Hawkins > > Using `Test Connection` for JDBC Datasources seems to be broken in the standalone server built from 8.9.x and master. This is an issue with EAP 6.3 Alpha1. > This is reproducible with the built-in ExampleDS H2 database. Run the `install.sh`, unzip, add a management user (bin/add-user.sh), start the server, and then login to the admin console (localhost:9990). Then go to Profile -> Connector -> Data Sources -> ExampleDS -> Connection -> Test Connection. It will fail with this error: "JBAS010440: failed to invoke operation: JBAS010447: Connection is not valid. This also happens with Oracle and PostgreSQL datasources. > The datasources seem to work despite this, but it would be good to understand the root cause and get it fixed if possible. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3471) unable to consume odata service deployed in teiid

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3471?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-3471: ------------------------------------- Yes, Looking at changes to OReva for possible fix. > unable to consume odata service deployed in teiid > ------------------------------------------------- > > Key: TEIID-3471 > URL: https://issues.jboss.org/browse/TEIID-3471 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Mark Drilling > Assignee: Ramesh Reddy > Attachments: deployment-exception.txt, MyVDB-vdb.xml, standalone-snippet.xml > > > I am unable to consume odata service created in teiid. > Steps to reproduce and files are attached. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3471) unable to consume odata service deployed in teiid

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3471?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3471: --------------------------------------- Do you want to do anything for odata4j? > unable to consume odata service deployed in teiid > ------------------------------------------------- > > Key: TEIID-3471 > URL: https://issues.jboss.org/browse/TEIID-3471 > Project: Teiid > Issue Type: Bug > Components: OData > Affects Versions: 8.7 > Reporter: Mark Drilling > Assignee: Ramesh Reddy > Attachments: deployment-exception.txt, MyVDB-vdb.xml, standalone-snippet.xml > > > I am unable to consume odata service created in teiid. > Steps to reproduce and files are attached. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3479) Typo in SecurityHelper method neogitiateGssLogin

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3479?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3479. ----------------------------------- Fix Version/s: 8.11 Resolution: Done Fixed the typo, thanks Jamie. > Typo in SecurityHelper method neogitiateGssLogin > ------------------------------------------------ > > Key: TEIID-3479 > URL: https://issues.jboss.org/browse/TEIID-3479 > Project: Teiid > Issue Type: Bug > Components: Embedded > Affects Versions: 8.11 > Reporter: Jaime Meritt > Assignee: Steven Hawkins > Priority: Trivial > Fix For: 8.11 > > > There is a typo in the new method neogitiateGssLogin in the SecurityHelper interface. Definitely a nit but good to fix before GA and it proliferates -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 11 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues May 2015