java-persistence-frameworks-comparison icon indicating copy to clipboard operation
java-persistence-frameworks-comparison copied to clipboard

sql2o implementation

Open bwajtr opened this issue 8 years ago • 3 comments

See http://www.sql2o.org/

There is integration with Spring too: http://www.sql2o.org/docs/spring/

bwajtr avatar Nov 29 '16 16:11 bwajtr

I took a look at sql2o and considered it for implementation, but for now sql2o does not support external transaction management -> namely it does not integrate with Spring transactions management. That's a huge no go for me so I won't even try to implement all the scenarios...

There is a quite old pull request with support for Spring transactions (https://github.com/aaberg/sql2o/pull/153) so I propose to reconsider sql2o once this pull request is accepted.

bwajtr avatar Dec 01 '16 17:12 bwajtr

Hi @bwajtr I was looking for the best option to use instead of ORM and I found your project. awesome. Your comparisons helped me a lot. Thanks.

I checked https://github.com/aaberg/sql2o/pull/153 and they've closed the PR with this comment (by @xiexed):

I think that after merging of #264 there is no sense in this pull request anymore. If someone wants to use Spring transactions management - it 's a question of one class with few lines of code. But I don't think that there is much sense to ship such Spring related class with Sql2o.

I wonder if this change to sql2o resolves this issue and make it ready to added to your comparison?

sajjadG avatar Nov 05 '17 21:11 sajjadG

Hi @sajjadG, thanks for pointing this out. I'll definitely take a look at sql2o again and implement it. I did the comparisons about a year ago so I think it's time to actually upgrade&review all of the implementations...

bwajtr avatar Nov 06 '17 17:11 bwajtr