This seems like a surprisingly obvious bug, so I figured I’d better ask what I’m doing wrong.

 

I have some code that writes records to a MySQL DB.  The PK is a simple INT, and the field is the only one the record locks on.  Everything works fine in a single thread… but when I start a second thread writing to the table, sooner or later one thread gets a “duplicate entry ‘187451’ for key 1.”

 

Do I need to do something special for MySQL to get PK generation working correctly?

 

 

 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to