README.md

qon-demo-springboot

Demo using QueryOn with Spring Boot. Uses the same environment variables as qon-demo-anydb.

running

Examples using qon-demo-minimal

QON_JDBC_URL="jdbc:h2:~/.queryon/demo-minimal;SCHEMA_SEARCH_PATH=public,queryon" QON_JDBC_USER=admin QON_JDBC_PASSWORD= mvn clean spring-boot:run -Dspring-boot.run.jvmArguments="-Dspring.output.ansi.enabled=ALWAYS -Dserver.port=8083"

OR (using jar)

mvn clean package
QON_JDBC_URL="jdbc:h2:~/.queryon/demo-minimal;SCHEMA_SEARCH_PATH=public,queryon" QON_JDBC_USER=admin QON_JDBC_PASSWORD= java -jar target/qon-demo-springboot.jar

and go to http://localhost:8080/

building & running with docker

• building:

mvn package && mkdir -p target/dependency && (cd target/dependency; jar -xf ../qon-demo-springboot.jar)
docker build --file src/main/docker/Dockerfile -t qon-demo-springboot .

• running:

docker run -it --rm -p 8080:8080 qon-demo-springboot

Example using demo-minimal

docker run -it --rm -v $HOME/.queryon/:/data/ -e QON_JDBC_URL="jdbc:h2:/data/demo-minimal;SCHEMA_SEARCH_PATH=public,queryon" -e QON_JDBC_USER=admin -e QON_JDBC_PASSWORD= -p 8080:8080 qon-demo-springboot

You man set system properties using the JAVA_TOOL_OPTIONS env

docker run -it --rm -e JAVA_TOOL_OPTIONS=-Djava.security.egd=file:/dev/./urandom -e QON_JDBC_URL="jdbc:h2:/data/demo-minimal;SCHEMA_SEARCH_PATH=public,queryon" -p 8080:8080 qon-demo-springboot

• tagging & publishing:

#export TAG=<TAG>
#export TAG=0.8-SNAPSHOT
#export TAG=latest
docker tag qon-demo-springboot tbrugz/qon-demo-springboot:$TAG
docker push tbrugz/qon-demo-springboot:$TAG

• images in Docker Hub:

https://hub.docker.com/r/tbrugz/qon-demo-springboot/

• ref:

https://spring.io/guides/gs/spring-boot-docker/

misc links

• Release Notes / Migration Guide https://github.com/spring-projects/spring-boot/wiki/Spring-Boot-2.7-Release-Notes