Archive for category HIBERNATE

JPA and Hibernate Cascade Types

A beginner’s guide to JPA and Hibernate Cascade Types

Advertisements

Leave a comment

@SequenceGenerator allocationSize ‘duplicate key error’ issue

 

This problem solved in hibernate 5.x.x

http://stackoverflow.com/questions/30981392/sequencegenerator-allocationsize-duplicate-key-error-issue

 

Leave a comment

How to reset postgres’ primary key sequence when it falls out of sync?

How to reset postgres’ primary key sequence when it falls out of sync?

-- Login to psql and run the following
-- What is the result?
SELECT MAX(id) FROM your_table;

-- Then run...
-- This should be higher than the last result.
SELECT nextval('your_table_id_seq');

-- If it's not higher... run this set the sequence last to your highest pid it. 
-- (wise to run a quick pg_dump first...)
SELECT setval('your_table_id_seq', (SELECT MAX(id) FROM your_table));
-- if your tables might have no rows
-- false means the set value will be returned by the next nextval() call    
SELECT setval('your_table_id_seq', COALESCE((SELECT MAX(id)+1 FROM your_table), 1), false);

Leave a comment