[keycloak-user] I think I know the cause of my JPA transaction errors

[Bill Burke]

You can set an idle timeout for pooled connections:

http://www.ironjacamar.org/doc/userguide/1.1/en-US/html_single/index.html#ds12

On 3/17/2014 10:02 AM, Dean Peterson wrote:
> I have mentioned it before but I am trying to get things to work using
> an Azure MS-SQL database.  Yes, I remember being told you will not
> support that.  Just in case it will spark some ideas I want to mention
> that I found Azure closes database connections after one minute and end
> users have no control over that:
> http://blogs.msdn.com/b/avkashchauhan/archive/2011/11/12/windows-azure-load-balancer-timeout-details.aspx
>
> This is the behavior I am seeing.  I log in, let the application sit
> until I am automatically logged out and I always get this timeout error
> (sql error: 0, SQLState: 08S01) when the JpaKeycloakSession.close()
> method is called.  I will probably have to switch to a local database.
>
>
>
>
>
>
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>

-- 
Bill Burke
JBoss, a division of Red Hat
http://bill.burkecentral.com