Unlike MySQL and other SQL dialects, apache derby doesn’t support the AUTO_INCREMENT keyword. To create an auto incremented filed in derby, you can use The value of id is now incremented automagically on every insert. You don’t have to specify it manually in the insert command For instruction on how to create auto incremented fields in other SQL dialects, have… Read more »