<div dir="ltr">Setting the idle timeout to 1 minute worked. <br><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Mar 17, 2014 at 9:19 AM, Stian Thorgersen <span dir="ltr"><<a href="mailto:stian@redhat.com" target="_blank">stian@redhat.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">You should still be able to use Azure, you just need to configure your datasource to do validation, or to timeout idle connections.<br>
<br>
Have a look at:<br>
<br>
<a href="https://docs.jboss.org/author/display/WFLY8/DataSource+configuration" target="_blank">https://docs.jboss.org/author/display/WFLY8/DataSource+configuration</a><br>
<a href="http://www.ironjacamar.org/doc/userguide/1.1/en-US/html_single/index.html#deployingds_descriptor" target="_blank">http://www.ironjacamar.org/doc/userguide/1.1/en-US/html_single/index.html#deployingds_descriptor</a><br>
<a href="https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/6/html/Administration_and_Configuration_Guide/Example_Microsoft_SQLServer_Datasource1.html" target="_blank">https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/6/html/Administration_and_Configuration_Guide/Example_Microsoft_SQLServer_Datasource1.html</a><br>
<div class="HOEnZb"><div class="h5"><br>
----- Original Message -----<br>
> From: "Dean Peterson" <<a href="mailto:peterson.dean@gmail.com">peterson.dean@gmail.com</a>><br>
> To: "Stian Thorgersen" <<a href="mailto:stian@redhat.com">stian@redhat.com</a>><br>
> Cc: <a href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a><br>
> Sent: Monday, 17 March, 2014 2:02:53 PM<br>
> Subject: I think I know the cause of my JPA transaction errors<br>
><br>
> I have mentioned it before but I am trying to get things to work using an<br>
> Azure MS-SQL database. Yes, I remember being told you will not support<br>
> that. Just in case it will spark some ideas I want to mention that I found<br>
> Azure closes database connections after one minute and end users have no<br>
> control over that:<br>
> <a href="http://blogs.msdn.com/b/avkashchauhan/archive/2011/11/12/windows-azure-load-balancer-timeout-details.aspx" target="_blank">http://blogs.msdn.com/b/avkashchauhan/archive/2011/11/12/windows-azure-load-balancer-timeout-details.aspx</a><br>
><br>
> This is the behavior I am seeing. I log in, let the application sit until<br>
> I am automatically logged out and I always get this timeout error (sql<br>
> error: 0, SQLState: 08S01) when the JpaKeycloakSession.close() method is<br>
> called. I will probably have to switch to a local database.<br>
><br>
><br>
><br>
> ><br>
><br>
</div></div></blockquote></div><br></div></div>