Docs: [Docs] Spring Tutorial

[jseldess]

Background: https://airtable.com/tblD3oZPLJgGhCmch/viw1DKmbKhg2MIECH/recXk26BY2iuKJ6Yz

Description: We now have an improved getting started guide for using Spring.

CockroachDB will provide more support for Spring in 20.1. Currently, there is no tutorial for getting started with Spring via either Hibernate, jOOQ, or MyBatis.

Team: Andrew Woods, Rafi Shamim, Eric Harmeling

Github Tracking Issue:

[awoods187]

We should have an option to use either Hibernate, jOOQ, or Mybatis as the three supported Spring frameworks.

Relates to https://github.com/cockroachdb/appdev-issues/issues/7

[awoods187]

@kai-niemi would you be willing to provide some Spring code examples for @rmloveland to document?
cc @ericharmeling and @timveil

[rmloveland]

Related:

• https://github.com/cockroachdb/cockroach/issues/41135 (Issue with information about Spring retries)
• https://github.com/cockroachlabs/roachbank (Example application)

[jseldess]

@ericharmeling, @awoods187, @rafiss, this is no longer officially on the 20.1 roadmap according to Airtable. Is it happening for 20.1 or pushed to later?

[awoods187]

No i just removed it from airtable per Nate's guidance on what's in airtable. We are definitely doing this for 20.1.

[jseldess]

OK, please help @ericharmeling have as clear a sense of the timeline on the remaining orm/third-party support improvements for 20.1 so he can plan his time out. I know you're already talking, so hopefully this is already clear.

[jseldess]

Two mini spring boot projects from @kai-niemi:

• https://github.com/cockroachlabs/roach-demo-txn
• https://github.com/cockroachlabs/roach-demo-helloworld

the helloworld could be what your'e looking for in terms of small-and-simple-yet-useful-spring-boot example. Less than 400 lines at least.. I can reduce it even more but then the question is what's interesting to showcase.

[kai-niemi]

Now also with jooq:

• https://github.com/cockroachlabs/roach-demo-helloworld-jooq

[kai-niemi]

Collapsed the hello worlds to https://github.com/cockroachlabs/roach-demo-data which supercedes the previous ones.

Spring boot's in total:

• https://github.com/cockroachlabs/roach-demo-data
• https://github.com/cockroachlabs/roach-demo-txn
• https://github.com/cockroachlabs/roachbank

also have another pet-project coming along that goes all-in on JPA. It models a webshop with product category hierarchies using a nested set model, custom jsonb types and stuff.

[ericharmeling]

I'm going to close this issue, as we've now published two end-to-end tutorials for Spring developers, based on Kai's roach-data apps:

• Build a Spring App with CockroachDB and JDBC
• Build a Spring App with CockroachDB and JPA