[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 Pranav K (JIRA)
[ https://issues.jboss.org/browse/TEIID-3478?page=com.atlassian.jira.plugin... ]
Pranav K commented on TEIID-3478:
---------------------------------
Yes its working fine with 8.11 Beta2, excuse the late response on this. I guess I didn't look at the whole code flow and made changes to fix only my particular run scenario. Thanks.
> 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)
9 years
[JBoss JIRA] (TEIID-3475) Add a separate example module for embedded examples
by Kylin Soong (JIRA)
[ https://issues.jboss.org/browse/TEIID-3475?page=com.atlassian.jira.plugin... ]
Kylin Soong commented on TEIID-3475:
------------------------------------
> such that they can be built in place in the embedded kit? Or are you saying that if someone wants to modify the example source that they'll do a checkout from git of the full Teiid project and go from there?
The source code is under examples/sources, but can not build, the runtime will use the pre-complied code which be packaged in teiid-examples-[version].jar.
> Add a separate example module for embedded examples
> ----------------------------------------------------
>
> Key: TEIID-3475
> URL: https://issues.jboss.org/browse/TEIID-3475
> Project: Teiid
> Issue Type: Feature Request
> Components: Embedded
> Affects Versions: 8.11
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 8.11
>
> Attachments: drools-examples.png
>
>
> Add a separate example module for embedded examples, it will contain a runnable jar, which will load all available examples, it will also contain transaction manager, etc.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years
[JBoss JIRA] (TEIID-3411) LDAP translator and multi-valued arrays
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3411?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3411:
---------------------------------------
Pulled the initial commit from 6_2-8.7.x as the work is not complete with respect to customer needs.
The desired state is to express an intersection table based upon a multi-valued attribute. The proposed DDL for this would include extension metadata to specify the attribute to be expanded into rows as well as an option to extract a part of the value (cn for example rather than a fully qualified name). This is more explicit than the initial check-in for this issue (which was motivated to just give a quick solution - as managing extension metadata can be more difficult than just enabling a translator property).
And they also want support for filtering operations against the multi-valued attribute - which was not supported by the initial commit as all multi-attribute are still returned for each top level entity that matches the filter.
Update support is not expected however, but could be supported if we require the intersection table to only represent the foreign key columns.
> LDAP translator and multi-valued arrays
> ---------------------------------------
>
> Key: TEIID-3411
> URL: https://issues.jboss.org/browse/TEIID-3411
> Project: Teiid
> Issue Type: Feature Request
> Components: LDAP Connector
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> The problem is with how multi-valued attribute from the LDAP response is handled. They don't want to have the data mapped to an array or multivalued-concat and then transformed into another table to get the unique values. There is an issue with the translator as it should handle multivalued attribute, by simply creating multiple rows for each value of the multivalued attribute.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years
[JBoss JIRA] (TEIID-3411) LDAP translator and multi-valued arrays
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3411?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3411:
----------------------------------
Fix Version/s: (was: 8.7.1.6_2)
> LDAP translator and multi-valued arrays
> ---------------------------------------
>
> Key: TEIID-3411
> URL: https://issues.jboss.org/browse/TEIID-3411
> Project: Teiid
> Issue Type: Feature Request
> Components: LDAP Connector
> Reporter: Debbie Steigner
> Assignee: Steven Hawkins
> Fix For: 8.11
>
>
> The problem is with how multi-valued attribute from the LDAP response is handled. They don't want to have the data mapped to an array or multivalued-concat and then transformed into another table to get the unique values. There is an issue with the translator as it should handle multivalued attribute, by simply creating multiple rows for each value of the multivalued attribute.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years
[JBoss JIRA] (TEIID-3475) Add a separate example module for embedded examples
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3475?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3475:
---------------------------------------
> compiled as a teiid maven project is more convenient for import code to a IDE, most developer like use a IDE to modify and test code.
Are you saying that you want to include the example sources as part of a maven project in the examples directory, such that they can be built in place in the embedded kit? Or are you saying that if someone wants to modify the example source that they'll do a checkout from git of the full Teiid project and go from there?
It's probably good to differentiate what we're trying to show with the examples. If it's the code of wiring up embedded and execution, then the code should be simple to see. If it's just to run queries, then something like the app you have makes sense, but the examples aren't currently written in such a way to make that easy and that would be changing the example app into something more like a sql client.
> Add a separate example module for embedded examples
> ----------------------------------------------------
>
> Key: TEIID-3475
> URL: https://issues.jboss.org/browse/TEIID-3475
> Project: Teiid
> Issue Type: Feature Request
> Components: Embedded
> Affects Versions: 8.11
> Reporter: Kylin Soong
> Assignee: Kylin Soong
> Fix For: 8.11
>
> Attachments: drools-examples.png
>
>
> Add a separate example module for embedded examples, it will contain a runnable jar, which will load all available examples, it will also contain transaction manager, etc.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years
[JBoss JIRA] (TEIID-3437) Inconsistencies with row count handling
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-3437?page=com.atlassian.jira.plugin... ]
Johnathon Lee updated TEIID-3437:
---------------------------------
Fix Version/s: 8.7.3
> Inconsistencies with row count handling
> ---------------------------------------
>
> Key: TEIID-3437
> URL: https://issues.jboss.org/browse/TEIID-3437
> Project: Teiid
> Issue Type: Bug
> Components: Misc. Connectors, Query Engine
> Affects Versions: 8.10
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.10.1, 8.11, 8.7.3
>
>
> With TEIID-3271 we addressed returning all of the update counts from a bulk operation such that the direct JDBC logic was correct. However this left the logic inconsistent with the projectintonode (which could result in invalid rowcount variables) and with the accumulo, solr, and simpledb translators.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years
[JBoss JIRA] (TEIID-3451) OData does not inject schema into queries
by Johnathon Lee (JIRA)
[ https://issues.jboss.org/browse/TEIID-3451?page=com.atlassian.jira.plugin... ]
Johnathon Lee updated TEIID-3451:
---------------------------------
Fix Version/s: 8.7.3
> OData does not inject schema into queries
> -----------------------------------------
>
> Key: TEIID-3451
> URL: https://issues.jboss.org/browse/TEIID-3451
> 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, 8.7.3
>
>
> OData service does not inject a fully qualified object names for tables for POSTS, PUTs, and DELETEs:
> 12:50:34,367 DEBUG [org.teiid.COMMAND_LOG] (http-localhost/127.0.0.1:8080-1) START USER COMMAND: startTime=2015-04-22 12:50:34.367 requestID=XxHTbednhDq7.0 txID=null sessionID=XxHTbednhDq7 applicationName=JDBC principal=teiidUser@teiid-security vdbName=ImsOne vdbVersion=2 sql=INSERT INTO Subscription (SUBSCRIPTION_ID, CLIENT_NAME, DEST_CONNECTION_URI, DEST_SCHEMA_NAME, DEST_TABLE_NAME, PROVIDER_URL, TOPIC_NAME) VALUES (?, ?, ?, ?, ?, ?, ?)
> 12:50:34,380 DEBUG [org.teiid.COMMAND_LOG] (http-localhost/127.0.0.1:8080-1) ERROR USER COMMAND: endTime=2015-04-22 12:50:34.379 requestID=XxHTbednhDq7.0 txID=null sessionID=XxHTbednhDq7 principal=teiidUser@teiid-security vdbName=ImsOne vdbVersion=2 finalRowCount=null
> 12:50:34,380 WARN [org.teiid.PROCESSOR] (http-localhost/127.0.0.1:8080-1) TEIID30020 Processing exception for request XxHTbednhDq7.0 'Group specified is ambiguous, resubmit the query by fully qualifying the group name: Subscription'. Originally QueryResolverException ResolverUtil.java:814. Enable more detailed logging to see the entire stacktrace.
> 12:50:34,383 WARN [org.teiid.ODATA] (http-localhost/127.0.0.1:8080-1) TEIID16012 Could not produce a successful OData response. Returning status ServerErrorException with message Group specified is ambiguous, resubmit the query by fully qualifying the group name: Subscription.
> Same insert works fine over JDBC. Offending line from 8.7.0 public github:
> https://github.com/teiid/teiid/blob/8.7.x/odata/src/main/java/org/teiid/o...
> Note that private Table findTable() on line 925 depends upon org.odata4j.core.EdmEntitySet#getName to return the name, but this is not fully qualified
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
9 years