Hibernate Community • View topic - "indentity"/"native" id generator doesn'

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

"indentity"/"native" id generator doesn'

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

xding

Post subject: "indentity"/"native" id generator doesn'

Posted: Wed Jul 21, 2004 1:28 am

Newbie

Joined: Mon Jul 19, 2004 11:52 pm
Posts: 2

Hi,

It seems that when id "native" or "identity" generator for mysql dilect will generate insert statements like:

insert into testtable (id, col1, col2) values (default, ?, ?).

I tried this insert statements with mysql innodb tables and get "cannot insert" error, duplicate entry.

I could not find the document of the behavior for this "default" pseudo-column in mysql. Have anybody else encountered the similar problem and how did you solve it?

Thanks.

Xiaoming Ding

Top

gavin

Post subject:

Posted: Wed Jul 21, 2004 1:34 am

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

It definitely helps to set Hibernate to use MySQLDialect instead of DB2Dialect when running on MySQL.

Top

xding

Post subject: Thanks

Posted: Wed Jul 21, 2004 4:51 pm

Newbie

Joined: Mon Jul 19, 2004 11:52 pm
Posts: 2

Thanks. It is my mistake -- I checked everything else except a second look at the dialect.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum