0 Replies Latest reply on Aug 21, 2013 3:52 AM by Alex Alex

    JBoss AS 6 H2 DB Unable to build Entity Manager

    Alex Alex Newbie

      HI,

      I cannot configure JBoss connect to H2 DB via JPA.

       

      My persistence.xml is:

       

      <?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="HeadzupPersistenceConnection"

              transaction-type="JTA">

              <provider>org.hibernate.ejb.HibernatePersistence</provider>

                       

                        <jta-data-source>java:jboss/datasources/HeadzupDS</jta-data-source>

                                              <class>com.uppspace.dbspacerh.IP</class>

       

       

              <properties>

                  <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect" />

                  <property name="hibernate.max_fetch_depth" value="3" />

                  <property name="hibernate.hbm2ddl.auto" value="update" />

                  <property name="hibernate.show_sql" value="true" />

              </properties>

          </persistence-unit>

      </persistence>

       

       

      Standalone.xml is:

       



          

      <datasource jndi-name="java:jboss/datasources/HeadzupDS"

          pool-name="ExampleDS" enabled="true" use-java-context="true">

          <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>

          <driver>h2</driver>

          <security>

              <user-name>sa</user-name>

              <password>sa</password>

          </security>

      </datasource>

       

       

      <drivers>

          <driver name="h2" module="com.h2database.h2">

              <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

          </driver>

      </drivers>

       

       

      The error is:

       

      10:43:28,744 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-5) MSC00001: Failed to start service jboss.persistenceunit."HeadzupEAR.ear#HeadzupPersistenceConnection": org.jboss.msc.service.StartException in service jboss.persistenceunit."HeadzupEAR.ear#HeadzupPersistenceConnection": Failed to start service

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1767) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_03]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_03]

                at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_03]

      Caused by: javax.persistence.PersistenceException: [PersistenceUnit: HeadzupPersistenceConnection] Unable to build EntityManagerFactory

                at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914)

                at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:889)

                at org.hibernate.ejb.HibernatePersistence.createContainerEntityManagerFactory(HibernatePersistence.java:73)

                at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.createContainerEntityManagerFactory(PersistenceUnitServiceImpl.java:162)

                at org.jboss.as.jpa.service.PersistenceUnitServiceImpl.start(PersistenceUnitServiceImpl.java:85)

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]

                ... 3 more

      Caused by: org.hibernate.AnnotationException: No identifier specified for entity: com.uppspace.dbspacerh.IP

                at org.hibernate.cfg.InheritanceState.determineDefaultAccessType(InheritanceState.java:276)

                at org.hibernate.cfg.InheritanceState.getElementsToProcess(InheritanceState.java:224)

                at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:663)

                at org.hibernate.cfg.Configuration$MetadataSourceQueue.processAnnotatedClassesQueue(Configuration.java:3406)

                at org.hibernate.cfg.Configuration$MetadataSourceQueue.processMetadata(Configuration.java:3360)

                at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1334)

                at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1724)

                at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:84)

                at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:904)

                ... 9 more

       

       

      10:43:28,803 INFO  [org.jboss.as] (MSC service thread 1-5) JBAS015951: Admin console listening on http://127.0.0.1:9990

      10:43:28,805 ERROR [org.jboss.as] (MSC service thread 1-5) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 6272ms - Started 236 of 322 services (1 services failed or missing dependencies, 83 services are passive or on-demand)