Hibernate Schema Update Problems
Saturday, July 5th, 2008I’ve been using Hibernate for relational persistence for a while now, and I have to say it’s been working out pretty well.
That was, until I went to do a SchemaUpdate.
The moment I did an alternation of a table, or created a new entity, things went sour, and I was unable to read my old data. Was it me, or was it Hibernate?
could not initialize a collection
PSQLException: ERROR: permission denied for relation newtablejustadded
It was me.
Turns out Hibernate’s update was working just fine. There was no magic versioning or class hashing going on, detecting the change to the database.
The problem was the ACL was blank for the newly created entity table (I was using Postgres).
By issuing this command, all was fine again:
GRANT INSERT, SELECT, UPDATE, DELETE, REFERENCES ON newtable TO GROUP agroupIwasusing;
Since it took a while to figure out what was going on, I thought I’d post this to help others that follow a similar, yet frustrating, path.