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

[Dean Peterson]

This is in relation to my last submission.  It seems the following line in
JpaModelProvider.java is not compatible with container managed JTA
transactions?

line: 26   EntityManagerFactory emf =
Persistence.createEntityManagerFactory("jpa-keycloak-identity-store",
getHibernateProperties());

---------- Forwarded message ----------
From: Dean Peterson <peterson.dean at gmail.com>
Date: Thu, Mar 13, 2014 at 1:40 PM
Subject: Trying to use JTA transactions for JPA causes errors
To: keycloak-user at lists.jboss.org


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20140313/6c567901/attachment.html