When I run the auction tutorial, it seems to overwrite the objects in the database instead of creating new ones.

I don't understand why when I run it a 2nd time why don't I get new accounts created? Instead it just ovewrites the existing accounts.

I changed:

.setProperty(Environment.HBM2DDL_AUTO, "validate");

from create to validate to see if that was it but that gives me:

Could not synchronize database state with session

Caused by: java.sql.BatchUpdateException: failed batch
at org.hsqldb.jdbc.jdbcStatement.executeBatch(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeBatch(Unknown Source)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)

Did you try update? Definitely, create is not what you want. try update.

.setProperty(Environment.HBM2DDL_AUTO, "update");

_____________________________________________
Please do RATE if this post was helpful