It seems like it is the bug of HSQL that auto_increment is not supported
very well by jpa.This can be proved that if I change the typoe of id
from integer to String, the tests can be run smoothly.