Mailing Lists: Apple Mailing Lists

Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

mySQL, Java & rollback behavior



I'm able to rollback unwanted edits to a mySQL table with Java but I notice that the primary key ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY) does increment although the rollback is successful.

In other words, if the PRIMARY KEY is 100 and user rollsback on three records then the next insert will generate 104 rather than a nice and neat 101. I wanted to know if this behavior can be handled or do us developers just "live with it".

______________________________
ENV_DETAILS
______________________________
mySQL: 5.0.51a
java: 1.5.0_13
JDBC: com.mysql.jdbc.Driver
______________________________


Thanks guys.


-- 
Kevin Muldoon, Owner
TrueBlueDot - Fine Art Printing
New Haven, CT 06511
www.truebluedot.com
"Our pigment meets your imagination"



 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Java-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/java-dev/email@hidden

This email sent to email@hidden



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.