[keycloak-user] That did the trick (JPA transaction errors)

[Dean Peterson]

Setting the idle timeout to 1 minute worked.


On Mon, Mar 17, 2014 at 9:19 AM, Stian Thorgersen <stian at redhat.com> wrote:

> You should still be able to use Azure, you just need to configure your
> datasource to do validation, or to timeout idle connections.
>
> Have a look at:
>
> https://docs.jboss.org/author/display/WFLY8/DataSource+configuration
>
> http://www.ironjacamar.org/doc/userguide/1.1/en-US/html_single/index.html#deployingds_descriptor
>
> https://access.redhat.com/site/documentation/en-US/JBoss_Enterprise_Application_Platform/6/html/Administration_and_Configuration_Guide/Example_Microsoft_SQLServer_Datasource1.html
>
> ----- Original Message -----
> > From: "Dean Peterson" <peterson.dean at gmail.com>
> > To: "Stian Thorgersen" <stian at redhat.com>
> > Cc: keycloak-user at lists.jboss.org
> > Sent: Monday, 17 March, 2014 2:02:53 PM
> > Subject: I think I know the cause of my JPA transaction errors
> >
> > 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.
> >
> >
> >
> > >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20140317/f6aa6fc8/attachment.html