anyone experience, h2 database reset and all records that you previously entered into db gone when tomcat is restarted?

below is my configuration


<property name="connection.username">sa</property>
<property name="connection.url">
jdbc:h2:~/mydb
</property>
<property name="dialect">
org.hibernate.dialect.H2Dialect
</property>
<property name="connection.password" >pass</property>
<property name="connection.driver_class">
org.h2.Driver
</property>

Hi there. Not sure if this will help but I had the same problem as you for a while. In the end I noticed I had put the following property into the config by mistake:



Pretty stupid mistake, as it drops the entire schema when the sessionFactory gets closed!

Probably thats the problem:

hbm2ddl.auto

All the examples in the internet bring this proporty set. (sometimes this property can be located in your hibernate xml config file)

The value for this property should be always "validate"

Other values re-create the database always you restart the container, or reset all the records. The correct value to keep the data is validate.
Leave this property blank is not recomended (though hibernate will assume that is validade when not supplied) because putting this property in your config file you won't forget its existence and function if you decide to reuse yourconfig file in another project.