[JBoss JIRA] (TEIID-5073) Building Salesforce adapter/translator pair issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5073?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-5073.
-----------------------------------
Resolution: Done
Added a new connectivity pair using the force 41 jars, but left the default as accessing the 40 api. The docs referring to building your own have been updated to removed that language. It seems that there are changes in nearly every revision that need to be accounted for. In this case additional dependencies were needed in the force 41 module.
> Building Salesforce adapter/translator pair issues
> --------------------------------------------------
>
> Key: TEIID-5073
> URL: https://issues.jboss.org/browse/TEIID-5073
> Project: Teiid
> Issue Type: Component Upgrade
> Components: Salesforce Connector
> Affects Versions: 9.2.3
> Environment: wildfly 10.0.0.Final and teiid-9.2.3
> Reporter: Thomas Esche
> Assignee: Steven Hawkins
> Labels: API, Salesforce
> Fix For: 10.0
>
> Original Estimate: 2 days
> Remaining Estimate: 2 days
>
> I tried to follow the instructions on https://github.com/teiid/salesforce to build a newer adapter/translator pair but I was not even able to build the provided v34 pair.
> The "mvn clean install" produce the following error:
> [INFO] ------------------------------------------------------------------------
> [INFO] Building Salesforce Resource Adapter API 34 1.0-SNAPSHOT
> [INFO] ------------------------------------------------------------------------
> Downloading: https://repository.jboss.org/nexus/content/repositories/thirdparty-upload...
> [INFO] ------------------------------------------------------------------------
> [INFO] Reactor Summary:
> [INFO]
> [INFO] Salesforce API 34 .................................. SUCCESS [ 1.091 s]
> [INFO] Salesforce Translator 34 ........................... SUCCESS [ 2.105 s]
> [INFO] Salesforce Resource Adapter API 34 ................. FAILURE [ 1.596 s]
> [INFO] ------------------------------------------------------------------------
> [INFO] BUILD FAILURE
> [INFO] ------------------------------------------------------------------------
> [INFO] Total time: 5.490 s
> [INFO] Finished at: 2017-09-20T11:13:59+02:00
> [INFO] Final Memory: 35M/425M
> [INFO] ------------------------------------------------------------------------
> [ERROR] Failed to execute goal on project connector-salesforce-34: Could not resolve dependencies for project org.jboss.teiid.connectors.salesforce-34:connector-salesforce-34:jar:1.0-SNAPSHOT: Could not find artifact org.jboss.teiid.connectors:connector-salesforce:rar:9.0.0.Final in thirdparty-uploads (https://repository.jboss.org/nexus/content/repositories/thirdparty-uploads/) -> [Help 1]
> After removing the dependencies block in the ...\connector-salesforce-34\pom.xml maven works, but it seems to create an invalid adapter.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 3 months
[JBoss JIRA] (TEIID-5083) Remove deprecated Salesforce API 22 access
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5083?page=com.atlassian.jira.plugin... ]
Steven Hawkins reassigned TEIID-5083:
-------------------------------------
Description: The deprecation notices were already added. The plan is to point the salesforce names to the 34 access instead. (was: The salesforce 22 access is quite out of date. Especially with the possible introduction of a newer version, we should deprecate the old.)
Fix Version/s: 11.0
(was: 10.0)
Summary: Remove deprecated Salesforce API 22 access (was: Deprecate the Salesforce API 22 access)
Assignee: (was: Steven Hawkins)
> Remove deprecated Salesforce API 22 access
> ------------------------------------------
>
> Key: TEIID-5083
> URL: https://issues.jboss.org/browse/TEIID-5083
> Project: Teiid
> Issue Type: Task
> Components: Salesforce Connector
> Reporter: Steven Hawkins
> Fix For: 11.0
>
>
> The deprecation notices were already added. The plan is to point the salesforce names to the 34 access instead.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 3 months
[JBoss JIRA] (TEIID-5073) Building Salesforce adapter/translator pair issues
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-5073?page=com.atlassian.jira.plugin... ]
Work on TEIID-5073 started by Steven Hawkins.
---------------------------------------------
> Building Salesforce adapter/translator pair issues
> --------------------------------------------------
>
> Key: TEIID-5073
> URL: https://issues.jboss.org/browse/TEIID-5073
> Project: Teiid
> Issue Type: Component Upgrade
> Components: Salesforce Connector
> Affects Versions: 9.2.3
> Environment: wildfly 10.0.0.Final and teiid-9.2.3
> Reporter: Thomas Esche
> Assignee: Steven Hawkins
> Labels: API, Salesforce
> Fix For: 10.0
>
> Original Estimate: 2 days
> Remaining Estimate: 2 days
>
> I tried to follow the instructions on https://github.com/teiid/salesforce to build a newer adapter/translator pair but I was not even able to build the provided v34 pair.
> The "mvn clean install" produce the following error:
> [INFO] ------------------------------------------------------------------------
> [INFO] Building Salesforce Resource Adapter API 34 1.0-SNAPSHOT
> [INFO] ------------------------------------------------------------------------
> Downloading: https://repository.jboss.org/nexus/content/repositories/thirdparty-upload...
> [INFO] ------------------------------------------------------------------------
> [INFO] Reactor Summary:
> [INFO]
> [INFO] Salesforce API 34 .................................. SUCCESS [ 1.091 s]
> [INFO] Salesforce Translator 34 ........................... SUCCESS [ 2.105 s]
> [INFO] Salesforce Resource Adapter API 34 ................. FAILURE [ 1.596 s]
> [INFO] ------------------------------------------------------------------------
> [INFO] BUILD FAILURE
> [INFO] ------------------------------------------------------------------------
> [INFO] Total time: 5.490 s
> [INFO] Finished at: 2017-09-20T11:13:59+02:00
> [INFO] Final Memory: 35M/425M
> [INFO] ------------------------------------------------------------------------
> [ERROR] Failed to execute goal on project connector-salesforce-34: Could not resolve dependencies for project org.jboss.teiid.connectors.salesforce-34:connector-salesforce-34:jar:1.0-SNAPSHOT: Could not find artifact org.jboss.teiid.connectors:connector-salesforce:rar:9.0.0.Final in thirdparty-uploads (https://repository.jboss.org/nexus/content/repositories/thirdparty-uploads/) -> [Help 1]
> After removing the dependencies block in the ...\connector-salesforce-34\pom.xml maven works, but it seems to create an invalid adapter.
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 3 months
[JBoss JIRA] (TEIID-4517) Add support for deleting child objects
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-4517?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-4517.
-----------------------------------
Resolution: Out of Date
> Add support for deleting child objects
> --------------------------------------
>
> Key: TEIID-4517
> URL: https://issues.jboss.org/browse/TEIID-4517
> Project: Teiid
> Issue Type: Feature Request
> Components: JDG Connector
> Affects Versions: 8.12.7.6_3, 9.2
> Reporter: Jan Stastny
> Assignee: Van Halbert
>
> Infinispan cache dsl translator currently doesn't support deleting child objects when using complex POJO classes.
> Example of complex POJO:
> {code:plain}
> package org.jboss.qe.jdg.remote.protobuf.complex;
> /* @Indexed */
> message Person {
>
> /* @IndexedField(index=true, store=false) */
> required int32 id = 1;
>
> /* @IndexedField */
> required string name = 2;
>
> /* @IndexedField */
> optional string email = 3;
>
> /* @IndexedField(index=true, store=false) */
> repeated PhoneNumber phones = 4;
> /* @Indexed */
> message Address {
>
> /* @IndexedField */
> required string Address = 1;
>
> /* @IndexedField(index=true, store=false) */
> required string City = 2;
>
> /* @IndexedField(index=true, store=false) */
> required string State = 3;
> }
> /* @IndexedField(index=true, store=false) */
> optional Address address = 5;
> }
>
> /* @Indexed */
> message PhoneNumber {
>
> /* @IndexedField */
> required string number = 1;
> }
> {code}
> Mapped metadata:
> {code:sql}
> CREATE FOREIGN TABLE Address (
> Address string NOT NULL PRIMARY KEY OPTIONS (NAMEINSOURCE 'address.Address', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> City string NOT NULL OPTIONS (NAMEINSOURCE 'address.City', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> State string NOT NULL OPTIONS (NAMEINSOURCE 'address.State', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> id integer NOT NULL OPTIONS (NAMEINSOURCE 'id', SELECTABLE FALSE, SEARCHABLE 'Searchable', NATIVE_TYPE 'int'),
> CONSTRAINT FK_PERSON FOREIGN KEY(id) REFERENCES Person (id) OPTIONS (NAMEINSOURCE 'address')
> ) OPTIONS (UPDATABLE TRUE);
>
> CREATE FOREIGN TABLE Person (
> id integer NOT NULL OPTIONS (NAMEINSOURCE 'id', SEARCHABLE 'Searchable', NATIVE_TYPE 'int'),
> name string NOT NULL OPTIONS (NAMEINSOURCE 'name', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> email string OPTIONS (NAMEINSOURCE 'email', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> CONSTRAINT PK_ID PRIMARY KEY(id)
> ) OPTIONS (UPDATABLE TRUE);
>
> CREATE FOREIGN TABLE PhoneNumber (
> number string NOT NULL PRIMARY KEY OPTIONS (NAMEINSOURCE 'phones.number', SEARCHABLE 'Searchable', NATIVE_TYPE 'java.lang.String'),
> id integer NOT NULL OPTIONS (NAMEINSOURCE 'id', SELECTABLE FALSE, SEARCHABLE 'Searchable', NATIVE_TYPE 'int'),
> CONSTRAINT FK_PERSON FOREIGN KEY(id) REFERENCES Person (id) OPTIONS (NAMEINSOURCE 'phones')
> ) OPTIONS (UPDATABLE TRUE);
> {code}
> Expected usage:
> {code:sql}
> DELETE FROM PhoneNumber WHERE id=3
> {code}
--
This message was sent by Atlassian JIRA
(v7.2.3#72005)
8 years, 3 months