[jboss-user] [JBoss Seam] - Re: Seam and Hibernate

[raja05]

create table Message (id bigint not null auto_increment, read bit not null,
  | text text not null, title varchar(100) not null, datetime datetime not null, primary key (id)) 

The "read bit not null" is the problem. "read" is a function in mysql and it wont let you create a field with that. Try renaming your model's field name to be something like readMessage and it should work . This should effectively translate your SQL to be 
create table Message (id bigint not null auto_increment, readMessage bit not null,
  | text text not null, title varchar(100) not null, datetime datetime not null, primary key (id)) 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964225#3964225

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964225