Using annotations, here is the snapshot Java:

@Id
@GenericGenerator(name="test", strategy = "seqhilo")
@GeneratedValue(generator="test")
private Long id;

When I run the program, I got:

SEVERE: Servlet.service() for servlet default threw exception
java.sql.SQLException: Field 'id' doesn't have a default value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)

I am using hibernate.hbm2ddl.auto in applicationContext.xml and I hope hibernate can take care of adding "auto-increment" attribute into the database table if needed. How should I configure xml and/or Java?

Thanks!

I don't think auto increment would be right thing for you anyways. This is a mapping for a sequence identity. You might get a better result if you use an identity generator.




Farzad-