Hi,

When i tried following schema to create "messages" table to execute book hello world example, got error.

Schema i used is
CREATE TABLE ANNOATE.MESSAGES(
MESSAGE_ID BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
MESSAGE_TEXT CHAR(30),
PRIMARY KEY(MESSAGE_ID),
CONSTRAINT NEXT_MESSAGE_ID FOREIGN KEY (MESSAGE_ID)
REFERENCES ANNOATE.MESSAGES(MESSAGE_ID)
)TYPE=InnoDB;

ANNOTATE is database name in MySQL.
Please correct if there i snay mistake in above schema.
Thanks

I'm new to Hibernate, but your database name is "ANNOTATE" and you're trying to "CREATE TABLE ANNOATE.MESSAGES"?

Typo?