The problem was resolved. It was a silly and a stupid mistake. The Id field in my Entity class was of type String and it also has the @GeneratedValue annotation. So it is quite obvious that we can't auto increment a field with String datatype. It can only be done on the int field.
Glad you got it figured out! I did not even look that close at your mappings since the error complained of a table not existing.. I am sure the cause of that was further up your stack trace in the table generation output