Re:Database Design Mistakes
by sehrope on Saturday July 20, 2013 @09:05PM
(#6077328)
> You still need a round trip to the DB to get an ID
No you don't. Not sure about MySQL but Oracle supports returning generated keys as part of an insertion[1]. An additional round trip is not required as it comes back in the "success" response of the insert itself.
No you don't. Not sure about MySQL but Oracle supports returning generated keys as part of an insertion[1]. An additional round trip is not required as it comes back in the "success" response of the insert itself.
[1]: http://info.michael-simons.eu/2007/10/09/jdbc-get-autogenera...