jogaco’s gists

jogaco / application.properties

Created May 21, 2017 16:27

Spring Boot Tutorial

	# Spring Boot: must use @..@ instead of ${...} https://docs.spring.io/spring-boot/docs/current/reference/html/howto-properties-and-configuration.html
	[email protected]@
	[email protected]@
	[email protected]@
	[email protected]@

jogaco / Game.java

Created May 21, 2017 16:37

Spring Boot Tutorial

	package com.operatornew.gamemanager.domain;

	import javax.persistence.Entity;
	import javax.persistence.GeneratedValue;
	import javax.persistence.GenerationType;
	import javax.persistence.Id;
	import javax.persistence.Table;

	@Entity
	@Table(name = "game")

jogaco / pom.xml

Last active May 21, 2017 17:30

Spring Boot Tutorial: Adding dbunit-maven-plugin

	...
	<plugin>
	<groupId>org.codehaus.mojo</groupId>
	<artifactId>dbunit-maven-plugin</artifactId>
	<version>1.0-beta-3</version>
	<configuration>
	<dataTypeFactoryName>${dbunit.dataTypeFactoryName}</dataTypeFactoryName>
	<driver>${jdbc.driverClassName}</driver>
	<username>${jdbc.username}</username>
	<password>${jdbc.password}</password>

jogaco / sample-data.xml

Created May 21, 2017 17:33

Spring Boot Tutorial: sample-data.xml file for dbunit-maven-plugin

	<?xml version="1.0" encoding="UTF-8"?>
	<dataset>
	<table name="game">
	<column>id</column>
	<column>name</column>
	<column>description</column>
	<row>
	<value description="id">-1</value>
	<value description="name">name1</value>
	<value description="description">desc1</value>

jogaco / GameRepository.java

Last active May 21, 2017 17:42

Spring Boot Tutorial

	package com.operatornew.gamemanager.repository;

	import com.operatornew.gamemanager.domain.Game;
	import org.springframework.data.repository.PagingAndSortingRepository;

	public interface GameRepository extends PagingAndSortingRepository<Game, Integer> {

	}

jogaco / SpringBootMySqlApplicationTests.java

Created May 21, 2017 17:46

Spring Boot Tutorial: tests

	package com.operatornew.gamemanager;

	import com.operatornew.gamemanager.domain.Game;
	import com.operatornew.gamemanager.repository.GameRepository;
	import java.util.ArrayList;
	import java.util.List;
	import static org.junit.Assert.assertEquals;
	import org.junit.Test;
	import org.junit.runner.RunWith;
	import org.springframework.beans.factory.annotation.Autowired;

jogaco / console_output_1.txt

Created May 21, 2017 17:51

Spring Boot Tutorial: build failure as we have no tables to insert dbunit data

	[INFO] --- dbunit-maven-plugin:1.0-beta-3:operation (test-compile) @ spring-boot-mysql ---
	78 [main] INFO org.dbunit.database.DatabaseDataSet -
	database name=MySQL
	database version=5.6.36-82.0
	database major version=5
	database minor version=6
	jdbc driver name=MySQL Connector Java
	jdbc driver version=mysql-connector-java-5.1.35 ( Revision: 5fb9c5849535c13917c2cf9baaece6ef9693ef27 )
	jdbc driver major version=5
	jdbc driver minor version=1

jogaco / pom.xml

Last active May 21, 2017 18:13

Spring Boot Tutorial: adding hibernate-maven-plugin

	...
	<build>
	<plugins>
	...
	<plugin>
	<groupId>de.juplo</groupId>
	<artifactId>hibernate-maven-plugin</artifactId>
	<version>2.0.0</version>
	<executions>
	<execution>

jogaco / hibernate.properties

Created May 21, 2017 18:09

Spring Boot Tutorial: hibernate.properties

	# https://docs.spring.io/spring-boot/docs/current/reference/html/howto-properties-and-configuration.html
	# Must use @...@ instead of ${...}
	[email protected]@

	# Needed by Hibernate3 Maven Plugin defined in pom.xml
	hibernate.connection.username= @jdbc.username@
	[email protected]@
	[email protected]@
	[email protected]@

jogaco / console_output_2.txt

Created May 21, 2017 18:18

Spring Boot Tutorial: hibernate-maven-plugin created tables and schema file

	--- hibernate-maven-plugin:2.0.0:drop (default) @ spring-boot-mysql ---
	[INFO] HHH000318: Could not find any META-INF/persistence.xml file in the classpath
	[INFO] Found no META-INF/persistence.xml.
	[INFO] Gathered hibernate-configuration (turn on debugging for details):
	[INFO] hibernate.connection.username = username
	[INFO] hibernate.connection.password = password
	[INFO] hibernate.dialect = org.hibernate.dialect.MySQL5InnoDBDialect
	[INFO] hibernate.connection.url = jdbc:mysql://localhost/game_manager?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC
	[INFO] hibernate.hbm2dll.create_namespaces = false
	[INFO] hibernate.connection.driver_class = com.mysql.jdbc.Driver

J. Garcia jogaco