[JBoss JIRA] (TEIIDDES-2579) Salesforce custom URL not getting pushed to DV runtime upon PREVIEW
by Mark Drilling (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2579?page=com.atlassian.jira.plu... ]
Mark Drilling resolved TEIIDDES-2579.
-------------------------------------
Resolution: Done
There is an inconsistency between the standard Designer Salesforce connection profile (uses a lowercase 'url' key) and the Teiid server Datasource (expects an uppercase 'URL' key).
Fix submitted for SalesForceConnectionInfoProvider - it now handles either uppercase or lowercase. Retested Ok - the URL property is …
[View More]now written to the SF ResourceAdapter.
https://github.com/Teiid-Designer/teiid-designer/pull/481
> Salesforce custom URL not getting pushed to DV runtime upon PREVIEW
> -------------------------------------------------------------------
>
> Key: TEIIDDES-2579
> URL: https://issues.jboss.org/browse/TEIIDDES-2579
> Project: Teiid Designer
> Issue Type: Bug
> Components: Data Preview
> Affects Versions: 9.0.1
> Reporter: Debbie Steigner
> Assignee: Mark Drilling
> Fix For: 9.0.4, 9.3
>
>
> The Teiid Designer in JBDS 8.x lets you create a connection to Salesforce and provides an option to define a custom URL if its different from the default one.
> After the metadata for one or more tables have been imported, if one chooses to do a 'Preview Data' on one of the tables imported. There are issues as the Preview version of the resource adapter is missing the following URL config property and attempts to connect to the default/implicit SF URL.
> <config-property type="java.lang.String" name="URL"></config-property>
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[View Less]
9 years, 4 months
[JBoss JIRA] (TEIIDDES-2630) Procedure Writing in Teiid
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2630?page=com.atlassian.jira.plu... ]
Steven Hawkins commented on TEIIDDES-2630:
------------------------------------------
Out parameters are handled via assignments. The select at the end would work for a result set, but not for out parameters.
> Procedure Writing in Teiid
> --------------------------
>
> Key: TEIIDDES-2630
> URL: https://issues.jboss.org/browse/TEIIDDES-2630
> …
[View More]Project: Teiid Designer
> Issue Type: Bug
> Reporter: Jayesh Garg
> Priority: Critical
>
> I created a Procedure using Cassandra as the Datasource. The procedure has 1 input and 2 outputs. I use the input to run a query which retrieves me a unique identifier which is the input for the 2nd table. When I fire another query on the 2nd table, data is retrieved but I am unable to assign it to my OUT parameters.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[View Less]
9 years, 4 months
[JBoss JIRA] (TEIIDDES-2630) Procedure Writing in Teiid
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2630?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2630:
----------------------------------------
[~shawkins] Steve, can you verify that Jayesh's procedure and virtual procedure are defined correctly to achieve his desired behavior?
> Procedure Writing in Teiid
> --------------------------
>
> Key: TEIIDDES-2630
> URL: https://issues.jboss.org/browse/TEIIDDES-2630
> …
[View More] Project: Teiid Designer
> Issue Type: Bug
> Reporter: Jayesh Garg
> Priority: Critical
>
> I created a Procedure using Cassandra as the Datasource. The procedure has 1 input and 2 outputs. I use the input to run a query which retrieves me a unique identifier which is the input for the 2nd table. When I fire another query on the 2nd table, data is retrieved but I am unable to assign it to my OUT parameters.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[View Less]
9 years, 4 months
[JBoss JIRA] (TEIIDDES-2629) Updating data source import resets translator to jdbc-simple for Netezza
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2629?page=com.atlassian.jira.plu... ]
Barry LaFond commented on TEIIDDES-2629:
----------------------------------------
[~bpiepers] I'm assuming that you initially imported your Netezza schema/model using DataTools *Generic JDBC* connection profile? Then set the translator by hand in the model. On re-import Designer is currently re-setting the connection info (i.e. translator name). That's a 1 line fix.
1) We can assume that any *update* to a …
[View More]model should NOT change the connection info at all
2) We could provide a check-box to override this and re-inject the connection info if the user desires.
Personally, I think option 1) should be enough?
> Updating data source import resets translator to jdbc-simple for Netezza
> ------------------------------------------------------------------------
>
> Key: TEIIDDES-2629
> URL: https://issues.jboss.org/browse/TEIIDDES-2629
> Project: Teiid Designer
> Issue Type: Bug
> Components: Import/Export
> Affects Versions: 8.3.4
> Reporter: Bas Piepers
> Priority: Minor
> Fix For: 9.2
>
> Attachments: screenshot-1.png, screenshot-2.png, screenshot-3.png, screenshot-4.png, screenshot-5.png
>
>
> If you update an existing source model while the translator is set to "Netezza", Teiid Designer resets the translator to "jdbc-simple". You have to manually set the translator back to "Netezza".
> See "Steps to reproduce" to get a better view of what happens.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
[View Less]
9 years, 4 months