Apparently, I forgot to mention one of my favorite open source projects on this blog, so here goes.
Want to migrate an existing java application to Amazon SimpleDB or just make working with SimpleDB as simple as possible? Check out the SimpleJPA project at http://code.google.com/p/simplejpa/. It's quite full featured at this point and works great. We are using it in production code now.