Just stumbled across the Java "Play" framework: http://www.playframework.org/. They say it's a kind of "Ruby on Rails" for Java.
I've always been against object-relational mappers, but I guess this is extensible with "real SQL" queries...
Cheers! Frank