I have not heard of any attempts of writing a Spring transactional manager for sql2o. I don't see why it should not be possible though!
Some of the stuff that will be included in sql2o 2.0, will probably make some types of extensions easier to make. I'm not sure what's required to make a spring transactional manager, so I don't know if that will be influenced.
If you succeed in making a spring transactional manager, would you be interested in sharing the code?
I just came across sql2o as a replacement for our existing Hibernate setup. Am I correct in understanding that there's currently no support for Spring Transaction management (via @Transactional)? If my understanding is correct on that point, is there anything in the 1.5.2 code base that would prevent me from creating my own Spring Transaction Manager implementation for sql2o - or is this required programmatic support something that was alluded to in the 2.0 discussion I read somewhere?While we like the simplicity of sql2o (plain vanilla sql, useful auto-mapping of result sets and the custom mapping functionality), we do make heavy use of the @Transactional annotation in our projects, not only to ensure that transactions are handled correctly, to reduce the boilerplate around handling of them but also for unit testing (so that each test that hits a DB is automatically rolled back after execution).