0 Replies Latest reply on Sep 28, 2011 1:57 AM by Mitja Skuhala

    JBoss 7.0.2 - Missing table: REVINFO

    Mitja Skuhala Newbie

      When i add property to my persitence.xml:

       

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

       

      i get this error:

       

      INFO  [org.hibernate.tool.hbm2ddl.SchemaValidator] (MSC service thread 1-3) HHH00229:Running schema validator

      07:51:42,032 INFO  [org.hibernate.tool.hbm2ddl.SchemaValidator] (MSC service thread 1-3) HHH00102:Fetching database metadata

      07:51:42,032 INFO  [java.sql.DatabaseMetaData] (MSC service thread 1-3) HHH00262:Table not found: REVINFO

      07:51:42,032 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-3) MSC00001: Failed to start service jboss.persistenceunit."sdpear.ear/sdpejb.jar#AS14Database": org.jboss.msc.service.StartException in service jboss.persistenceunit."sdpear.ear/sdpejb.jar#AS14Database": Failed to start service

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

          at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [:1.6.0_20]

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [:1.6.0_20]

          at java.lang.Thread.run(Thread.java:619) [:1.6.0_20]

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

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

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

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

          at org.jboss.as.jpa.service.PersistenceUnitService.createContainerEntityManagerFactory(PersistenceUnitService.java:143)

          at org.jboss.as.jpa.service.PersistenceUnitService.start(PersistenceUnitService.java:77)

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

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

          ... 3 more

      Caused by: org.hibernate.HibernateException: Missing table: REVINFO

          at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1263)

          at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:155)

          at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:446)

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

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

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

          ... 9 more