1 Reply Latest reply on Nov 24, 2014 2:57 PM by Андрей Апанасик

    Could not register synchronization for container transaction

    Андрей Апанасик Newbie

      Hello, i'm trying to make restfull service in WIldFly 8.2. I wanted to work with db using hibernate.

       

      1) I created datasource in config file of wildfly.

      2) I checked coonection in admin console. It works.

      3) persistence.xml:

       

      <?xml version="1.0" encoding="UTF-8"?>
      <persistence version="2.0"
          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_2_0.xsd">
          <persistence-unit name="HSDB" transaction-type="JTA">
              <jta-data-source>java:jboss/datasources/PostgreDataSource</jta-data-source>
              <properties>
                  <property name="hibernate.hbm2ddl.auto" value="update" />
      
                  <property name="hibernate.show_sql" value="true" />
                    <property name="format_sql" value="true" />
      
              </properties>
          </persistence-unit>
      </persistence>
      
      
      
      

      4) User.java:

       

      @Entity
      @Table(name = "User", schema="public" )
      public class User {
          private int mId;
          private String mText;
      
          /**
           * @return the pid
           */
          @Id
          @GeneratedValue
          @Column(name = "id")
          public int getId() {
              return mId;
          }
      
          /**
           * @param pid
           *            the pid to set
           */
          public void setText(String text) {
              this.mText = text;
          }
      
          /**
           * @return the pid
           */
          @Column(name = "text")
          public String getText() {
              return mText;
          }
      
          /**
           * @param pid
           *            the pid to set
           */
          public void setId(int pid) {
              this.mId = pid;
          }
      
          @Override
          public String toString() {
              return String.format(
                      "id=%d\nid =%s",
                      this.mId);
          }
      
      }
      
      
      
      

      5) rs file:

      @Path("/")
      public class HelloWorld {
      
      @PersistenceUnit(unitName = "HSDB")
          private EntityManagerFactory mEntityManagerFactory;
      ...
      
         @GET
          @Path("/")
          @Produces(MediaType.APPLICATION_XML)
          @Consumes(MediaType.APPLICATION_XML)
          public String getHelloWorldXML() {
      //        EntityManagerFactory emf = Persistence.createEntityManagerFactory("HSDB"); //returns null
      //        EntityManager em = emf.createEntityManager(); //null pointer exception on this line. emf is null
              EntityManager em = mEntityManagerFactory.createEntityManager();
              String id = "_def_";
              Session session = (Session) em.getDelegate();
              Transaction tx = null;
              User person = null;
          
              try {
                  tx = session.beginTransaction();  //<-- problem is here
                  person = (User) session.get(User.class, 7);
                  id = String.valueOf(person.getId());
              } catch (HibernateException e) {
                  if (tx != null)
                      tx.rollback();
                  e.printStackTrace();
              } finally {
                  tx.commit();
                  session.close();
              }
              return "<xml><result>" + helloService.createHelloMessage("World")  + id + "</result></xml>";
          
          
          }
      }
      
      
      
      

       

      When i deploy project to wildfly i see in console hibernate logs:

      19:39:57,618 INFO  [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 147) HHH000204: Processing PersistenceUnitInfo [
          name: HSDB
          ...]
      19:39:57,623 INFO  [org.jboss.weld.deployer] (MSC service thread 1-1) JBAS016002: Processing weld deployment heartstone-server.war
      19:39:57,640 INFO  [org.jboss.weld.deployer] (MSC service thread 1-13) JBAS016005: Starting Services for CDI deployment: heartstone-server.war
      19:39:57,642 INFO  [org.jboss.weld.deployer] (MSC service thread 1-3) JBAS016008: Starting weld service for deployment heartstone-server.war
      19:39:57,645 INFO  [org.jboss.as.jpa] (ServerService Thread Pool -- 147) JBAS011409: Starting Persistence Unit (phase 2 of 2) Service 'heartstone-server.war#HSDB'
      19:39:57,649 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 147) HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL9Dialect
      19:39:57,650 INFO  [org.hibernate.engine.jdbc.internal.LobCreatorBuilder] (ServerService Thread Pool -- 147) HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
      19:39:57,651 INFO  [org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory] (ServerService Thread Pool -- 147) HHH000397: Using ASTQueryTranslatorFactory
      19:39:57,657 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 147) HHH000228: Running hbm2ddl schema update
      19:39:57,658 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 147) HHH000102: Fetching database metadata
      19:39:57,659 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 147) HHH000396: Updating schema
      19:39:57,673 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 147) HHH000261: Table found: public.user
      19:39:57,673 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 147) HHH000037: Columns: [id, text]
      19:39:57,673 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 147) HHH000108: Foreign keys: []
      19:39:57,673 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 147) HHH000126: Indexes: [user_pkey]
      19:39:57,674 INFO  [org.hibernate.tool.hbm2ddl.SchemaUpdate] (ServerService Thread Pool -- 147) HHH000232: Schema update complete
      
      

       

      So connection with data base is fine. But when i try to use it in code i got this error:

      19:43:38,472 ERROR [stderr] (default task-35) org.hibernate.TransactionException: Could not register synchronization for container transaction
      
      19:43:38,472 ERROR [stderr] (default task-35)     at org.hibernate.engine.transaction.internal.jta.CMTTransaction.afterTransactionBegin(CMTTransaction.java:72)
      
      19:43:38,472 ERROR [stderr] (default task-35)     at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:166)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1435)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at ru.suvitruf.hs.server.HelloWorld.getHelloWorldXML(HelloWorld.java:86)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at ru.suvitruf.hs.server.HelloWorld$Proxy$_$$_WeldClientProxy.getHelloWorldXML(Unknown Source)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at java.lang.reflect.Method.invoke(Unknown Source)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:137)
      
      19:43:38,473 ERROR [stderr] (default task-35)     at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:296)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:250)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:237)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:179)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:220)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85)
      
      19:43:38,474 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:61)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:56)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:45)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:63)
      
      19:43:38,475 ERROR [stderr] (default task-35)     at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:70)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:261)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:247)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:76)
      
      19:43:38,476 ERROR [stderr] (default task-35)     at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:166)
      
      19:43:38,477 ERROR [stderr] (default task-35)     at io.undertow.server.Connectors.executeRootHandler(Connectors.java:197)
      
      19:43:38,477 ERROR [stderr] (default task-35)     at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:759)
      
      19:43:38,477 ERROR [stderr] (default task-35)     at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      
      19:43:38,477 ERROR [stderr] (default task-35)     at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      
      19:43:38,477 ERROR [stderr] (default task-35)     at java.lang.Thread.run(Unknown Source)