Repository files navigation

This demo is fashioned off of the Cockroach DB demos here:https://www.cockroachlabs.com/docs/v19.2/build-a-java-app-with-cockroachdb.html

The demo shows how to useMyBatis to interact withCockroachDB. The demo is a Spring Boot applicationand uses theMyBatis Spring Integration to make things easy to configure.

1. Install cockroach:brew install cockroachdb/tap/cockroach

2. Start a Cockroach cluster:cockroach start --insecure

   You could also run CockroachDB constantly in the background withbrew services start cockroachdb/tap/cockroach

3. Connect to cockroach shell:cockroach sql --insecure

   If you are running CockroachDB from the command line, you will need to do this in a separate terminal session.

4. Run SQL commands to create the user and database...

   CREATEUSERIF NOT EXISTS maxroach;CREATEDATABASEbank;GRANT ALLON DATABASE bank TO maxroach;\q

5. The application is configured to connect to CockroachDB running locally at the default port (26257). If you have CockroachDB running elsewhere, modifythe values insrc/main/resources/application.yml appropriately.

6. Run the application:./gradlew bootRun - you should see the Spring app start, then several messages about database updates. Note that this requiresCockroachDB to be running and available as configured insrc/main/resources/application.yml

7. You can also run the integration tests with./gradlew test. This will start CockroachDB in a Docker container and run the tests against that instance.This requires you to have Docker installed, but you do not need to install CockroachDB manually.