[keycloak-user] Trying to use JTA transactions for JPA causes errors

[Stian Thorgersen]

Keycloak has been designed to work in multiple environments, not just JavaEE. That's why container managed transactions are not used. JTA transactions are not required either as there's a single database, hence no need for distributed transactions.

Can you provide me with some more information about the errors you are seeing? Including the server log, persistence.xml, etc. It should work perfectly well with resource local transactions.

If you have a real requirement for using JTA a data-source we can certainly look into supporting that.

----- Original Message -----
> From: "Dean Peterson" <peterson.dean at gmail.com>
> To: keycloak-user at lists.jboss.org
> Sent: Thursday, 13 March, 2014 6:40:23 PM
> Subject: [keycloak-user] Trying to use JTA transactions for JPA causes errors
> 
> I get transaction rollback errors frequently. Every time I leave the
> application idle for a few minutes and come back, the system has transaction
> errors. I have to refresh multiple times for the keycloak admun-ui to start
> responding again. I realized my settings were using local database
> transactions and that does not work well. I am using JBOSS and J2EE so I
> definitely want to use the container managed transactions. I switched the
> settings in my management console and changed my persistence.xml to this:
> 
> <persistence xmlns=" http://java.sun.com/xml/ns/persistence "
> xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance "
> xsi:schemaLocation=" http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd "
> version="1.0">
> <persistence-unit name="jpa-keycloak-identity-store" transaction-type="JTA">
> <jta-data-source>java:jboss/datasources/ui_users</jta-data-source>
> <class>org.keycloak.models.jpa.entities.ApplicationEntity</class>
> <class>org.keycloak.models.jpa.entities.CredentialEntity</class>
> <class>org.keycloak.models.jpa.entities.OAuthClientEntity</class>
> <class>org.keycloak.models.jpa.entities.RealmEntity</class>
> <class>org.keycloak.models.jpa.entities.RequiredCredentialEntity</class>
> <class>org.keycloak.models.jpa.entities.ApplicationRoleEntity</class>
> <class>org.keycloak.models.jpa.entities.RealmRoleEntity</class>
> <class>org.keycloak.models.jpa.entities.SocialLinkEntity</class>
> <class>org.keycloak.models.jpa.entities.UserEntity</class>
> <class>org.keycloak.models.jpa.entities.UserRoleMappingEntity</class>
> <class>org.keycloak.models.jpa.entities.ScopeMappingEntity</class>
> 
> <exclude-unlisted-classes>true</exclude-unlisted-classes>
> 
> <properties>
> <property name="hibernate.dialect"
> value="org.hibernate.dialect.SQLServer2008Dialect"/>
> <property name="hibernate.hbm2ddl.auto" value="update"/>
> </properties>
> </persistence-unit>
> </persistence>
> 
> 
> 
> 
> 
> Now when I start the server I get the following error:
> 
> java.lang.NullPointerException
> at
> org.hibernate.engine.transaction.internal.jta.JtaStatusHelper.getStatus(JtaStatusHelper.java:76)
> at
> .
> .
> .
> org.keycloak.models.jpa.JpaKeycloakSessionFactory.createSession(JpaKeycloakSessionFactory.java:21)
> at
> .
> .
> .
> jboss.undertow.deployment.default-server.default-host./auth: Failed to start
> service
> Caused by: java.lang.RuntimeException: Failed to construct public
> org.keycloak.server.KeycloakServerApplication(javax.servlet.ServletContext)
> throws java.io.FileNotFoundException
> 
> Any ideas why this is happening?
> 
> Thanks,
> 
> Dean Peterson
> 
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user