Spring Boot Tutorial

Login example with JDBC HTTP SESSION and Spring Security on Google App Engine (GAE)

Prerequisites:

• Java 8
• Maven 3.5.x
• Spring Boot 1.5.9
• GAE Standard
• Google Cloud SQL (MySQL 5.7)
• Google Cloud SDK installed on your PC

Installation

• Copy file "src\main\resources\application.dist.properties" to "src\main\resources\application.properties". Change Datasource parameters as following:
  • DATABASE_NAME
  • CONNECTION_NAME
  • DATABASE_USERNAME
  • DATABASE_PASSWORD
• Copy file "src\main\webapp\WEB-INF\appengine-web.dist.xml" to "src\main\webapp\WEB-INF\appengine-web.xml". Change GAE configuration as below:
  • PROJECT_NAME
  • GAE_SERVICE_NAME
• Copy file "src\main\webapp\WEB-INF\logging.dist.properties" to "src\main\webapp\WEB-INF\logging.properties" and change logging level

Run on your Local environment

$ mvn clean install
$ mvn appengine:run

Go to http://localhost:8080

Deploy to GAE

$ mvn clean install
$ mvn appengine:deploy

Go to https://GAE_SERVICE_NAME-dot-PROJECT_NAME.appspot.com

Or by using glcoud command as below

$ gcloud app browse -s GAE_SERVICE_NAME

Trouble shooting

You may got this error message:

Error: "Caused by: java.lang.RuntimeException: The Google Cloud SQL API is not enabled for project [GAE_SERVICE_NAME]"

To resolve it, You must enable "Google Cloud SQL API" by go to Google API Manager to enable it or access this url https://console.cloud.google.com/apis/api/sqladmin/overview?project=PROJECT_NAME