[teiid-issues] [JBoss JIRA] (TEIID-5962) Teiid locks many threads when Salesforce is disconnected

[Ramesh Reddy (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14133381#comment-14133381 ] 

Ramesh Reddy commented on TEIID-5962:
-------------------------------------

There are two properties defined in this 
https://github.com/teiid/teiid-spring-boot/blob/master/data/salesforce/src/main/java/org/teiid/spring/data/salesforce/SalesforceConfiguration.java#L24-L25

> How to set this properties in teiid spring boot application? May be bean config or properties?

in the `application.properties` as shown in this example https://github.com/teiid/teiid-spring-boot/blob/master/samples/salesforce/src/main/resources/application.properties you can set

{code}
spring.teiid.data.salesforce.requestTimeout=5000
spring.teiid.data.salesforce.connectTimeout=5000
{code}

requestTimeout is per request after the connection is made, connectTimeout is during the connection. BTW, note here that underneath we use Salesforce libraries, so the logic to enforce is done inside it. Let us know if that works?

> Teiid locks many threads when Salesforce is disconnected
> --------------------------------------------------------
>
>                 Key: TEIID-5962
>                 URL: https://issues.redhat.com/browse/TEIID-5962
>             Project: Teiid
>          Issue Type: Bug
>          Components: Salesforce Connector
>    Affects Versions: 12.3.1
>            Reporter: Renat Eskenin
>            Assignee: Steven Hawkins
>            Priority: Major
>         Attachments: Снимок экрана от 2020-05-31 11-09-10.png
>
>
> We had two incidents in our experimental service with teiid spring boot app. When Salesforce is down to 20min and service with teiid trying to call SQL from Salesforce we have many threads in tomcat server (in spring boot app). Then when 200 threads is activated service do not reply to requests because is "max threads" in tomcat of service.
> Why teiid do not send response as "Salesforce is down - error" or connection timeout?
> Micro schema:
> HTTP Requests to REST api -> Teiid spring boot app -> {broken 20min}Salesforce



--
This message was sent by Atlassian Jira
(v7.13.8#713008)