search

bwajtr / java-persistence-frameworks-comparison

Comparison of non-JPA SQL mapping frameworks for Java (Jooq, Spring JDBCTemplate, MyBatis, EBean, JDBI, Speedment, sql2o)
MIT License
264 stars 35 forks source link

sql2o implementation #7

Open bwajtr opened 7 years ago

bwajtr commented 7 years ago

See http://www.sql2o.org/

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

bwajtr commented 7 years ago

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.

sajjadG commented 6 years ago

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?

bwajtr commented 6 years ago

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...