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

Ads









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
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
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
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
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
can we update table in hibernate with out primary key in table?
can we update table in hibernate with out primary key in table?  can we update table in hibernate with out primary key in table
Maven dependency for org.hibernate - hibernate-envers version 5.3.21.Final is released. Learn to use hibernate-envers version 5.3.21.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.21.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.4.27.SP1 is released. Learn to use hibernate-envers version 5.4.27.SP1 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.4.27.SP1. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.4.28.Final is released. Learn to use hibernate-envers version 5.4.28.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.4.28.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.4.29.Final is released. Learn to use hibernate-envers version 5.4.29.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.4.29.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.4.30.Final is released. Learn to use hibernate-envers version 5.4.30.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.4.30.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.4.31.Final is released. Learn to use hibernate-envers version 5.4.31.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.4.31.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.4.32.Final is released. Learn to use hibernate-envers version 5.4.32.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.4.32.Final. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.5.0.Alpha1 is released. Learn to use hibernate-envers version 5.5.0.Alpha1 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.0.Alpha1. Developer can use this version ( org.hibernate - hibernate-envers
Maven dependency for org.hibernate - hibernate-envers version 5.5.0.Beta1 is released. Learn to use hibernate-envers version 5.5.0.Beta1 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.0.Beta1. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.5.0.CR1 is released. Learn to use hibernate-envers version 5.5.0.CR1 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.0.CR1. Developer can use this version ( org.hibernate - hibernate-envers version
Maven dependency for org.hibernate - hibernate-envers version 5.5.0.Final is released. Learn to use hibernate-envers version 5.5.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 5.5.0.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
Maven dependency for org.hibernate - hibernate-envers version 5.5.3.Final is released. Learn to use hibernate-envers version 5.5.3.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.3.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 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 5.0.10.Final is released. Learn to use hibernate-envers version 5.0.10.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.0.10.Final. Developer can use this version ( org.hibernate - hibernate-envers
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 5.0.3.Final is released. Learn to use hibernate-envers version 5.0.3.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.0.3.Final. Developer can use this version ( org.hibernate - hibernate-envers version
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 5.2.14.Final is released. Learn to use hibernate-envers version 5.2.14.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.2.14.Final. Developer can use this version ( org.hibernate - hibernate-envers

Ads