you should get the desired results.
I believe the show_sql hibernate configuration option merely causes it to System.out.println(...) the SQL which makes it impossible to redirect it to a log file without system-wide side-effects....