Hi All,
when i use my application for hsqldb it workes fine using Hibernate.
but when i change the dialect to mysql one of its table creating problem others are working fine with it.
it throws the following error while creating that table
Code:
create table USER_VOICEMESSAGE (VOICEMESSAGEID bigint not null auto_increment, PHONEADDRESS varchar(50) not null, FILENAME varchar(50) not null unique, READ bit, ADDED_ON datetime not null, USERID bigint, primary key (VOICEMESSAGEID))
-> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'READ bit, ADDED_ON datetime not null, USERID bigint, primary key (VOICEMESSAGEID' at line 1
i am using mysql-server-5.0.51a, and it is throwing this error on
BOOLEAN value
let me know if you need more details.
Regards,
Sachin Parnami
Login
FAQ
Search
