Hibernate Envers - REVINFO table doesn't exist

Hibernate Envers - REVINFO table doesn't exist

Hi,

In my project I have to save the data change log. For this we are using the Hibernate Envers, but there is no table REFINFO in my database that's why its giving following error:

Hibernate Envers - REVINFO table doesn't exist

How to resolve this?

Thanks

View Answers

April 11, 2017 at 2:38 PM

Hi,

There are two options: a) Create this table manually in your database. In case of MySQL you can use the following query:

CREATE TABLE `revinfo` (
  `REV` int(11) NOT NULL AUTO_INCREMENT,
  `REVTSTMP` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`REV`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

b) Allow hibernate to create table automatically. For this add following property in the hibernate.cfg.xml file:

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

After adding about property Hibernate will create table automatically.

Hope above information will help you in solving the problem.

Thanks


April 11, 2017 at 2:53 PM

Hi,

Check Hibernate 5 tutorials on our website for more examples and articles.

Thanks


April 11, 2017 at 2:55 PM

Hi, Learn how to create Hibernate 5 Annotation Example.

Check source code at the page Hibernate 5 Annotation Example.

Thanks


April 26, 2017 at 12:37 PM

Hi,

Check the tutorial Hibernate envers custom revinfo table.

Thanks









Related Tutorials/Questions & Answers:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jpa.sequence' doesn't exist
'jpa.sequence' doesn't exist Error Code: 1146 Call: UPDATE SEQUENCE SET SEQ...: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: T able 'jpa.sequence' doesn't exist Error... .sequence' doesn't exist
MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist
MySQL issue: Table 'data_dictionary.CHARACTER_SETS' doesn't exist  MySQL issue: Table 'datadictionary.CHARACTERSETS' doesn't exist
Advertisements
Hibernate envers revtype values
Hibernate envers revtype values  Hi, What are Hibernate envers revtype values? Thanks   Hi, Hibernate envers library automatically keep track of the changes made to the entity. It create a new table with _AUD suffix
Hibernate envers audit example
Hibernate envers audit example  Hi, Hibernate envers is popular for versioning the entity. I am searching for Hibernate envers audit example. Give... data. Thanks   Hi, Hibernate envers provides the AuditReader class
Any specific log4j statements for Hibernate Envers for showing the Envers related errors
Any specific log4j statements for Hibernate Envers for showing the Envers related errors  We are applying Hibernate Envers for existing hibernate project. If there is any specific errors related to hibernate envers those
org.hibernate - hibernate-envers version 5.2.0.Final Maven dependency. How to use hibernate-envers version 5.2.0.Final in pom.xml?
org.hibernate  - Version 5.2.0.Final of hibernate-envers Maven dependency...-envers in pom.xml? How to use hibernate-envers version 5.2.0.Final in pom.xml? Learn... org.hibernate  - Version 5.2.0.Final of hibernate-envers in project by the help
org.hibernate - hibernate-envers version 4.3.10.Final Maven dependency. How to use hibernate-envers version 4.3.10.Final in pom.xml?
org.hibernate  - Version 4.3.10.Final of hibernate-envers Maven...-envers in pom.xml? How to use hibernate-envers version 4.3.10.Final in pom.xml... org.hibernate  - Version 4.3.10.Final of hibernate-envers in project by the help
org.hibernate - hibernate-envers version 4.0.0.CR6 Maven dependency. How to use hibernate-envers version 4.0.0.CR6 in pom.xml?
org.hibernate  - Version 4.0.0.CR6 of hibernate-envers Maven dependency? How to use  org.hibernate  - Version 4.0.0.CR6 of hibernate-envers in pom.xml? How to use hibernate-envers version 4.0.0.CR6 in pom.xml? Learn to use
org.hibernate - hibernate-envers version 5.3.30.Final Maven dependency. How to use hibernate-envers version 5.3.30.Final in pom.xml?
org.hibernate  - Version 5.3.30.Final of hibernate-envers Maven...-envers in pom.xml? How to use hibernate-envers version 5.3.30.Final in pom.xml... org.hibernate  - Version 5.3.30.Final of hibernate-envers in project by the help
org.hibernate - hibernate-envers version 6.2.0.CR3 Maven dependency. How to use hibernate-envers version 6.2.0.CR3 in pom.xml?
org.hibernate  - Version 6.2.0.CR3 of hibernate-envers Maven dependency? How to use  org.hibernate  - Version 6.2.0.CR3 of hibernate-envers in pom.xml? How to use hibernate-envers version 6.2.0.CR3 in pom.xml? Learn to use
org.hibernate - hibernate-envers version 5.3.11.Final Maven dependency. How to use hibernate-envers version 5.3.11.Final in pom.xml?
org.hibernate  - Version 5.3.11.Final of hibernate-envers Maven...-envers in pom.xml? How to use hibernate-envers version 5.3.11.Final in pom.xml... org.hibernate  - Version 5.3.11.Final of hibernate-envers in project by the help
org.hibernate - hibernate-envers version 5.4.23.Final Maven dependency. How to use hibernate-envers version 5.4.23.Final in pom.xml?
org.hibernate  - Version 5.4.23.Final of hibernate-envers Maven...-envers in pom.xml? How to use hibernate-envers version 5.4.23.Final in pom.xml... org.hibernate  - Version 5.4.23.Final of hibernate-envers in project by the help
org.hibernate - hibernate-envers version 4.3.0.CR1 Maven dependency. How to use hibernate-envers version 4.3.0.CR1 in pom.xml?
org.hibernate  - Version 4.3.0.CR1 of hibernate-envers Maven dependency? How to use  org.hibernate  - Version 4.3.0.CR1 of hibernate-envers in pom.xml? How to use hibernate-envers version 4.3.0.CR1 in pom.xml? Learn to use
org.hibernate - hibernate-envers version 4.2.1.Final Maven dependency. How to use hibernate-envers version 4.2.1.Final in pom.xml?
org.hibernate  - Version 4.2.1.Final of hibernate-envers Maven dependency...-envers in pom.xml? How to use hibernate-envers version 4.2.1.Final in pom.xml? Learn... org.hibernate  - Version 4.2.1.Final of hibernate-envers in project by the help
org.hibernate - hibernate-envers version 5.2.13.Final Maven dependency. How to use hibernate-envers version 5.2.13.Final in pom.xml?
org.hibernate  - Version 5.2.13.Final of hibernate-envers Maven...-envers in pom.xml? How to use hibernate-envers version 5.2.13.Final in pom.xml... org.hibernate  - Version 5.2.13.Final of hibernate-envers in project by the help
org.hibernate - hibernate-envers version 5.3.4.Final Maven dependency. How to use hibernate-envers version 5.3.4.Final in pom.xml?
org.hibernate  - Version 5.3.4.Final of hibernate-envers Maven dependency...-envers in pom.xml? How to use hibernate-envers version 5.3.4.Final in pom.xml? Learn... org.hibernate  - Version 5.3.4.Final of hibernate-envers in project by the help
org.hibernate - hibernate-envers version 5.1.6.Final Maven dependency. How to use hibernate-envers version 5.1.6.Final in pom.xml?
org.hibernate  - Version 5.1.6.Final of hibernate-envers Maven dependency...-envers in pom.xml? How to use hibernate-envers version 5.1.6.Final in pom.xml? Learn... org.hibernate  - Version 5.1.6.Final of hibernate-envers in project by the help
Hibernate Temporary Table
Hibernate Temporary Table   How can i create temporary table in Hibernate
How to update table in Hibernate
How to update table in Hibernate  Hi, I have a table in database that has two fields in it. Student Name and ID, can anyone explain me how to update these tables in Hibernate. Thanks.   Update table query in Hibernate
Maven Repository/Dependency: org.hibernate.orm | hibernate-envers
Maven Repository/Dependency of Group ID org.hibernate.orm and Artifact ID hibernate-envers. Latest version of org.hibernate.orm:hibernate-envers dependencies. # Version Release Date
Joining Multiple table in Hibernate
Joining Multiple table in Hibernate  Hi everyone, I'm new to Hibernate (even in JAVA), and I'm having some doubt's about one thing. I created 2... (using System.out.println) the query results. I've been using (just for one table
Maven Repository/Dependency: org.hibernate | hibernate-envers
Maven Repository/Dependency of Group ID org.hibernate and Artifact ID hibernate-envers. Latest version of org.hibernate:hibernate-envers dependencies. # Version Release Date 1
creating table in hibernate
creating table in hibernate  how to create table by the help of hibernate   There are 2 alternatives to create table in hibernate: 1... table in my oracle database by the help of hibernate, so if you would help me
delete row from a table in hibernate
delete row from a table in hibernate  is there method to delete row in a table using hibernate like save(-) to insert row
Maven Repository/Dependency: org.hibernate | hibernate-envers-jakarta
Maven Repository/Dependency of Group ID org.hibernate and Artifact ID hibernate-envers-jakarta. Latest version of org.hibernate:hibernate-envers-jakarta dependencies. # Version Release Date
Version of exist>exist dependency
List of Version of exist>exist dependency
Hibernate table not mapped error - solution
Hibernate table not mapped error - solution  Hi, What is the reason of Hibernate table not mapped error and it can be solved? Thanks   HI... configuration of Entity class in Hibernate. Hibernate is ORM framework in Java which
Maven dependency for org.hibernate - hibernate-envers version 5.6.8.Final is released. Learn to use hibernate-envers version 5.6.8.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.6.8.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 4.3.8.Final is released. Learn to use hibernate-envers version 4.3.8.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 4.3.8.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.6.6.Final is released. Learn to use hibernate-envers version 5.6.6.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.6.6.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.5.9.Final is released. Learn to use hibernate-envers version 5.5.9.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.5.9.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.3.24.Final is released. Learn to use hibernate-envers version 5.3.24.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.3.24.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 4.1.8.Final is released. Learn to use hibernate-envers version 4.1.8.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 4.1.8.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.3.19.Final is released. Learn to use hibernate-envers version 5.3.19.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.3.19.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate.orm - hibernate-envers version 6.1.2.Final is released. Learn to use hibernate-envers version 6.1.2.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate.orm - hibernate-envers project have released the latest version of this library on 03 Aug 2022, the released version of  org.hibernate.orm - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.6.11.Final is released. Learn to use hibernate-envers version 5.6.11.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.6.11.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.6.1.Final is released. Learn to use hibernate-envers version 5.6.1.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.6.1.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.6.0.Beta2 is released. Learn to use hibernate-envers version 5.6.0.Beta2 in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.6.0.Beta2. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.5.7.Final is released. Learn to use hibernate-envers version 5.5.7.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.5.7.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate.orm - hibernate-envers version 6.1.4.Final is released. Learn to use hibernate-envers version 6.1.4.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate.orm - hibernate-envers project have released the latest version of this library on 05 Oct 2022, the released version of  org.hibernate.orm - hibernate-envers
Maven dependency for org.hibernate.orm - hibernate-envers version 6.2.0.CR1 is released. Learn to use hibernate-envers version 6.2.0.CR1 in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate.orm - hibernate-envers project have released the latest version of this library on 23 Dec 2022, the released version of  org.hibernate.orm - hibernate-envers library
Maven dependency for org.hibernate - hibernate-envers version 5.5.6 is released. Learn to use hibernate-envers version 5.5.6 in Maven based Java projects
-envers released The developers of   org.hibernate - hibernate-envers..., the released version of  org.hibernate - hibernate-envers library is 5.5.6. Developer can use this version ( org.hibernate - hibernate-envers version 5.5.6
Maven dependency for org.hibernate - hibernate-envers version 5.3.22.Final is released. Learn to use hibernate-envers version 5.3.22.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.3.22.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate.orm - hibernate-envers version 6.0.0.CR2 is released. Learn to use hibernate-envers version 6.0.0.CR2 in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate.orm - hibernate-envers project have released the latest version of this library on 09 Mar 2022, the released version of  org.hibernate.orm - hibernate-envers library
Maven dependency for org.hibernate.orm - hibernate-envers version 6.0.0.Alpha9 is released. Learn to use hibernate-envers version 6.0.0.Alpha9 in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate.orm - hibernate-envers project have released the latest version of this library on 04 Aug 2021, the released version of  org.hibernate.orm - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 4.2.0.Final is released. Learn to use hibernate-envers version 4.2.0.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 4.2.0.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 4.0.0.Beta4 is released. Learn to use hibernate-envers version 4.0.0.Beta4 in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 4.0.0.Beta4. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 3.6.7.Final is released. Learn to use hibernate-envers version 3.6.7.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 3.6.7.Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 3.5.5-Final is released. Learn to use hibernate-envers version 3.5.5-Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 3.5.5-Final. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.5.2.Final is released. Learn to use hibernate-envers version 5.5.2.Final in Maven based Java projects
of hibernate-envers released The developers of   org.hibernate - hibernate..., the released version of  org.hibernate - hibernate-envers library is 5.5.2.Final. Developer can use this version ( org.hibernate - hibernate-envers version

Ads