spring boot で xamppのmysqlにアクセスできない

Question

ネットの記事を見て設定しているのですが、spring boot3でxamppのmysqlにアクセスしようとしても、エラーが出て表示されません。

spring bootのコンソールでcom.zaxxer.hikari.pool.HikariPoolという箇所でエラーとなっています。
以下使用しているコードとエラーです。

(データベースをmysqlではなくh2にすると可動します)

sts3.9.6
jdk1.8.0_131

MainController.java

package com.example.demo;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class MainController {
    @Autowired
    private SyainRepository syainRepository;

    @RequestMapping(value = "/test1")
    public List<Syain> get() {
        return syainRepository.findAll();
    }
}

Syain.java

package com.example.demo;
import javax.persistence.Entity;
import javax.persistence.Table;
import javax.persistence.Id;

@Entity
@Table(name="syain")
public class Syain {
    @Id
    private Integer id;
    
    private String name;
    
    private String romaji;
    
    public Integer getId() {
        return id;
    }
	public String getName() {
		return name;
	}
	public String getRomaji() {
		return romaji;
	}
}

SyainRepository.java

package com.example.demo;
import org.springframework.data.jpa.repository.JpaRepository;

public interface SyainRepository extends JpaRepository<Syain, Integer> {
}

application.properties

spring.jpa.hibernate.ddl-auto=none
spring.datasource.url=jdbc:mysql://localhost:3306/testphp
spring.datasource.username=root
spring.datasource.password=

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.1.1.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example.demo</groupId>
	<artifactId>test1</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>test1</name>
	<description>riirusystem</description>

	<properties>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>

xamppのmysqlに追加したddl

CREATE TABLE `syain` (
  `id` int(11) NOT NULL,
  `name` varchar(10) NOT NULL,
  `romaji` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `syain` (`id`, `name`, `romaji`) VALUES
(1, 'ああああ', 'aaaa');
COMMIT;

実行したところ　springbootのコンソールにエラーが出力されている

2019-01-05 11:17:52.394  INFO 1928 --- [           main] c.r.web.RiiruSystemApplication           : Starting RiiruSystemApplication on Masaki-PC with PID 1928 (C:\Users\Masaki\Documents\workspace-sts-3.9.6.RELEASE\RiiruSystem\target\classes started by Masaki in C:\Users\Masaki\Documents\workspace-sts-3.9.6.RELEASE\RiiruSystem)
2019-01-05 11:17:52.399  INFO 1928 --- [           main] c.r.web.RiiruSystemApplication           : No active profile set, falling back to default profiles: default
2019-01-05 11:17:53.242  INFO 1928 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data repositories in DEFAULT mode.
2019-01-05 11:17:53.321  INFO 1928 --- [           main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 70ms. Found 1 repository interfaces.
2019-01-05 11:17:53.748  INFO 1928 --- [           main] trationDelegate$BeanPostProcessorChecker : Bean 'org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration' of type [org.springframework.transaction.annotation.ProxyTransactionManagementConfiguration$$EnhancerBySpringCGLIB$$9e0d0b58] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
2019-01-05 11:17:54.117  INFO 1928 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
2019-01-05 11:17:54.146  INFO 1928 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
2019-01-05 11:17:54.146  INFO 1928 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet Engine: Apache Tomcat/9.0.13
2019-01-05 11:17:54.154  INFO 1928 --- [           main] o.a.catalina.core.AprLifecycleListener   : The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: [C:\Program Files\Java\jre1.8.0_171\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:/Program Files/Java/jre1.8.0_171/bin/server;C:/Program Files/Java/jre1.8.0_171/bin;C:/Program Files/Java/jre1.8.0_171/lib/amd64;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Toshiba\Bluetooth Toshiba Stack\sys\;C:\Program Files (x86)\Toshiba\Bluetooth Toshiba Stack\sys\x64\;C:\Program Files (x86)\Common Files\Adobe\AGL;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\ProgramData\chocolatey\bin;C:\Program Files\nodejs\;C:\Program Files (x86)\Brackets\command;C:\xampp\php;C:\ProgramData\ComposerSetup\bin;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files\Git\cmd;C:\Program Files\TortoiseGit\bin;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Ruby22-x64\bin;C:\Ruby24-x64\bin;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\Microsoft VS Code\bin;C:\Users\Masaki\AppData\Roaming\npm;C:\Program Files\PostgreSQL\9.6\bin;C:\Users\Masaki\AppData\Roaming\Composer\vendor\bin;C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe;C:\Program Files\Java\jdk1.8.0_131\bin;C:\Users\Masaki\Desktop\sts-bundle\sts-3.9.6.RELEASE;;.]
2019-01-05 11:17:54.264  INFO 1928 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
2019-01-05 11:17:54.265  INFO 1928 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 1813 ms
2019-01-05 11:17:54.448  INFO 1928 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...
2019-01-05 11:17:55.574 ERROR 1928 --- [           main] com.zaxxer.hikari.pool.HikariPool        : HikariPool-1 - Exception during pool initialization.

ご教授のほどよろしくおねがいします。

Comments

[退会済みユーザー]

mysql は 自動起動 しません

[x-ryo]

ありがとうございます。
解決しました！

Answer 1

application.propertiesのデータソースをいかに変更すると接続できますか？

spring.datasource.url=jdbc:mysql://localhost:3306/testphp?useUnicode=true&characterEncoding=UTF-8&serverTimezone=JST