Is there any kind of out-of-the-box transaction management support for pure DAO in Spring framework?
Yes, Spring has transaction management (see here).