[keycloak-user] Idle connections are not closed

[Bill Burke]

You'll have to dive into Wildfly/JBoss EAP datasource configuration 
documentation.  I know there are a multitude of connection pool switches 
you can specify.


On 7/13/17 10:03 AM, Kir Merzlikin wrote:
> Hi all,
>
> I deploy Keycloak server app to Cloud Foundry and use ClearDB service as
> relational database for Keycloak.
>
> ClearDB has a restriction, that it closes all connections, that are idle for
> 90 seconds.
> To not run into the situation, when Keycloak tries to use closed connection,
> I've added following datasource configuration (based on  Pivotal
> recommendations
> <https://discuss.pivotal.io/hc/en-us/articles/230433268-Suggested-Configuration-for-Connection-Pools-using-ClearDb>
> ):
>
>
>
> But even after applying this configuration I see in the ClearDB management
> console that idle connections are closed only after 90 seconds and not after
> 60 seconds (1 minute) as it's specified with "idle-timeout-minutes"
> parameter.
>
> So, have anybody of you faced similar situation? Or maybe you have some
> ideas why these idle connections are not being closed.
>
> Thanks.
>
>
>
>
>
> --
> View this message in context: http://keycloak-user.88327.x6.nabble.com/Idle-connections-are-not-closed-tp3948.html
> Sent from the keycloak-user mailing list archive at Nabble.com.
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user