jogaco

Create Root CA (Done once)

Create Root Key

Attention: this is the key used to sign the certificate requests, anyone holding this can sign certificates on your behalf. So keep it in a safe place!

openssl genrsa -des3 -out rootCA.key 4096

jogaco

  .   ____          _            __ _ _
 /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
 \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  '  |____| .__|_| |_|_| |_\__, | / / / /
 =========|_|==============|___/=/_/_/_/
 :: Spring Boot ::        (v1.5.3.RELEASE)

2017-05-21 20:14:25.542  INFO 9085 --- [           main] c.o.g.SpringBootMysqlApplicationTests    : Starting SpringBootMysqlApplicationTests on hal9003 with PID 9085 (started by jgarcia in /home/java-projects/spr-boot)
2017-05-21 20:14:25.544  INFO 9085 --- [           main] c.o.g.SpringBootMysqlApplicationTests    : No active profile set, falling back to default profiles: default

jogaco

 --- 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

jogaco

# https://docs.spring.io/spring-boot/docs/current/reference/html/howto-properties-and-configuration.html
# Must use @...@ instead of ${...}
hibernate.dialect=@hibernate.dialect@

# Needed by Hibernate3 Maven Plugin defined in pom.xml
hibernate.connection.username= @jdbc.username@
hibernate.connection.password=@jdbc.password@
hibernate.connection.url=@jdbc.url@
hibernate.connection.driver_class=@jdbc.driverClassName@

jogaco

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

jogaco

[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

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

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

<?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

...
         <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>