Spring MySQL 커넥션 오류
미해결
MySQL 가 하루 지나면 자꾸 연결이 끊겨요... 구글링 해서 다 따라해도 도저히 해결이 안돼서 결국 지우고 다시 깔았는데 하루 지나니까 연결이 또 안되네요 오류랑 코드 보고 제발 도와주세요 ㅠㅜㅠㅜㅠㅜ <application.properties> # MySQL spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver # JDBC URL of the database. # spring.datasource.url=jdbc:mysql:// localhost :{port}/{DBname}?{options} spring.datasource.url=jdbc:mysql://127.0.0.1:3306/mysql?autoReconnection=true spring.datasource.username=root spring.datasource.password= # // MySQL(jpa 사용시 설정) spring.jpa.database=mysql spring.jpa.show-sql=true spring.jpa.hibernate.ddl-auto=create spring.jpa.properties.hibernate.format_sql=true spring.jpa.generate-ddl=true server.port=8082 <Build.gradle> plugins { id 'java' id 'org.springframework.boot' version '2.7.15' id 'io.spring.dependency-management' version '1.0.15.RELEASE' } group = 'com.project' version = '0.0.1-SNAPSHOT' java { sourceCompatibility = '1.8' } configurations { compileOnly { extendsFrom annotationProcessor } } repositories { mavenCentral() } dependencies { implementation 'org.springframework.boot:spring-boot-starter-data-jpa' implementation 'org.springframework.boot:spring-boot-starter-mustache' /*implementation 'org.springframework.boot:spring-boot-starter-security'*/ implementation 'org.springframework.boot:spring-boot-starter-web' implementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter:2.3.1' compileOnly 'org.projectlombok:lombok' runtimeOnly 'com.mysql:mysql-connector-j' annotationProcessor 'org.projectlombok:lombok' testImplementation 'org.springframework.boot:spring-boot-starter-test' testImplementation 'org.mybatis.spring.boot:mybatis-spring-boot-starter-test:2.3.1' testImplementation ' org.springframework.security :spring-security-test' } tasks.named('test') { useJUnitPlatform() } <오류 내용> 2023-09-14 17:41:23.476 INFO 8728 --- [ main] com.project.board.BoardApplication : Starting BoardApplication using Java 1.8.0_381 on DESKTOP-UR1QF50 with PID 8728 (C:\worksapces\java\board\out\production\classes started by hyeji in C:\worksapces\java\Board) 2023-09-14 17:41:23.486 INFO 8728 --- [ main] com.project.board.BoardApplication : No active profile set, falling back to 1 default profile: "default" 2023-09-14 17:41:25.875 INFO 8728 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode. 2023-09-14 17:41:26.140 INFO 8728 --- [ main] .s.d.r.c.RepositoryConfigurationDelegate : Finished Spring Data repository scanning in 222 ms. Found 1 JPA repository interfaces. 2023-09-14 17:41:26.584 WARN 8728 --- [ main] o.m.s.mapper.ClassPathMapperScanner : No MyBatis mapper was found in '[com.project.board]' package. Please check your configuration. 2023-09-14 17:41:30.926 INFO 8728 --- [ main] o.s.b.w.embedded.tomcat.TomcatWebServer : Tomcat initialized with port(s): 8082 (http) 2023-09-14 17:41:30.955 INFO 8728 --- [ main] o.apache.catalina.core.StandardService : Starting service [Tomcat] 2023-09-14 17:41:30.956 INFO 8728 --- [ main] org.apache.catalina.core.StandardEngine : Starting Servlet engine: [Apache Tomcat/9.0.79] 2023-09-14 17:41:31.577 INFO 8728 --- [ main] o.a.c.c.C.[Tomcat].[ localhost ].[/] : Initializing Spring embedded WebApplicationContext 2023-09-14 17:41:31.578 INFO 8728 --- [ main] w.s.c.ServletWebServerApplicationContext : Root WebApplicationContext: initialization completed in 7938 ms 2023-09-14 17:41:32.433 INFO 8728 --- [ main] o.hibernate.jpa.internal.util.LogHelper : HHH000204: Processing PersistenceUnitInfo [name: default] 2023-09-14 17:41:32.944 INFO 8728 --- [ main] org.hibernate.Version : HHH000412: Hibernate ORM core version 5.6.15.Final 2023-09-14 17:41:33.595 INFO 8728 --- [ main] o.hibernate.annotations.common.Version : HCANN000001: Hibernate Commons Annotations { 5.1.2.Final } 2023-09-14 17:41:34.066 INFO 8728 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting... 2023-09-14 17:41:37.367 ERROR 8728 --- [ main] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization. com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException( SQLError.java:174 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException( SQLExceptionsMapping.java:64 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO( ConnectionImpl.java:833 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.jdbc.ConnectionImpl.<init>( ConnectionImpl.java:453 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.jdbc.ConnectionImpl.getInstance( ConnectionImpl.java:246 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.jdbc.NonRegisteringDriver.connect( NonRegisteringDriver.java:198 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.zaxxer.hikari.util.DriverDataSource.getConnection( DriverDataSource.java:138 ) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.PoolBase.newConnection( PoolBase.java:364 ) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry( PoolBase.java:206 ) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry( HikariPool.java:476 ) [HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariPool.checkFailFast( HikariPool.java:561 ) [HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariPool.<init>( HikariPool.java:115 ) [HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.HikariDataSource.getConnection( HikariDataSource.java:112 ) [HikariCP-4.0.3.jar:na] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection( DatasourceConnectionProviderImpl.java:122 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection( JdbcEnvironmentInitiator.java:181 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService( JdbcEnvironmentInitiator.java:68 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService( JdbcEnvironmentInitiator.java:35 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService( StandardServiceRegistryImpl.java:101 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService( AbstractServiceRegistryImpl.java:272 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService( AbstractServiceRegistryImpl.java:246 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService( AbstractServiceRegistryImpl.java:223 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.id .factory.internal.DefaultIdentifierGeneratorFactory.injectServices( DefaultIdentifierGeneratorFactory.java:175 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies( AbstractServiceRegistryImpl.java:295 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService( AbstractServiceRegistryImpl.java:252 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService( AbstractServiceRegistryImpl.java:223 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>( InFlightMetadataCollectorImpl.java:173 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete( MetadataBuildingProcess.java:127 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata( EntityManagerFactoryBuilderImpl.java:1460 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build ( EntityManagerFactoryBuilderImpl.java:1494 ) [ hibernate-core-5.6.15.Final .jar: 5.6.15.Final ] at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory( SpringHibernateJpaPersistenceProvider.java:58 ) [spring-orm-5.3.29.jar:5.3.29] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory( LocalContainerEntityManagerFactoryBean.java:365 ) [spring-orm-5.3.29.jar:5.3.29] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.buildNativeEntityManagerFactory( AbstractEntityManagerFactoryBean.java:409 ) [spring-orm-5.3.29.jar:5.3.29] at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet( AbstractEntityManagerFactoryBean.java:396 ) [spring-orm-5.3.29.jar:5.3.29] at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.afterPropertiesSet( LocalContainerEntityManagerFactoryBean.java:341 ) [spring-orm-5.3.29.jar:5.3.29] at org.springframework.beans.factory.support .AbstractAutowireCapableBeanFactory.invokeInitMethods( AbstractAutowireCapableBeanFactory.java:1863 ) [spring-beans-5.3.29.jar:5.3.29] at org.springframework.beans.factory.support .AbstractAutowireCapableBeanFactory.initializeBean( AbstractAutowireCapableBeanFactory.java:1800 ) [spring-beans-5.3.29.jar:5.3.29] at org.springframework.beans.factory.support .AbstractAutowireCapableBeanFactory.doCreateBean( AbstractAutowireCapableBeanFactory.java:620 ) [spring-beans-5.3.29.jar:5.3.29] at org.springframework.beans.factory.support .AbstractAutowireCapableBeanFactory.createBean( AbstractAutowireCapableBeanFactory.java:542 ) [spring-beans-5.3.29.jar:5.3.29] at org.springframework.beans.factory.support .AbstractBeanFactory.lambda$doGetBean$0( AbstractBeanFactory.java:335 ) [spring-beans-5.3.29.jar:5.3.29] at org.springframework.beans.factory.support .DefaultSingletonBeanRegistry.getSingleton( DefaultSingletonBeanRegistry.java:234 ) ~[spring-beans-5.3.29.jar:5.3.29] at org.springframework.beans.factory.support .AbstractBeanFactory.doGetBean( AbstractBeanFactory.java:333 ) [spring-beans-5.3.29.jar:5.3.29] at org.springframework.beans.factory.support .AbstractBeanFactory.getBean( AbstractBeanFactory.java:208 ) [spring-beans-5.3.29.jar:5.3.29] at org.springframework.context.support .AbstractApplicationContext.getBean( AbstractApplicationContext.java:1157 ) ~[spring-context-5.3.29.jar:5.3.29] at org.springframework.context.support .AbstractApplicationContext.finishBeanFactoryInitialization( AbstractApplicationContext.java:911 ) ~[spring-context-5.3.29.jar:5.3.29] at org.springframework.context.support .AbstractApplicationContext.refresh( AbstractApplicationContext.java:583 ) ~[spring-context-5.3.29.jar:5.3.29] at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh( ServletWebServerApplicationContext.java:147 ) ~[spring-boot-2.7.15.jar:2.7.15] at org.springframework.boot.SpringApplication.refresh( SpringApplication.java:731 ) ~[spring-boot-2.7.15.jar:2.7.15] at org.springframework.boot.SpringApplication.refreshContext( SpringApplication.java:408 ) ~[spring-boot-2.7.15.jar:2.7.15] at org.springframework.boot.SpringApplication.run ( SpringApplication.java:307 ) ~[spring-boot-2.7.15.jar:2.7.15] at org.springframework.boot.SpringApplication.run ( SpringApplication.java:1303 ) ~[spring-boot-2.7.15.jar:2.7.15] at org.springframework.boot.SpringApplication.run ( SpringApplication.java:1292 ) ~[spring-boot-2.7.15.jar:2.7.15] at com.project.board.BoardApplication.main( BoardApplication.java:10 ) ~[classes/:na] Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_381] at sun.reflect.NativeConstructorAccessorImpl.newInstance( NativeConstructorAccessorImpl.java:62 ) ~[na:1.8.0_381] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance( DelegatingConstructorAccessorImpl.java:45 ) ~[na:1.8.0_381] at java.lang.reflect.Constructor.newInstance( Constructor.java:423 ) ~[na:1.8.0_381] at com.mysql.cj.exceptions.ExceptionFactory.createException( ExceptionFactory.java:61 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.exceptions.ExceptionFactory.createException( ExceptionFactory.java:105 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.exceptions.ExceptionFactory.createException( ExceptionFactory.java:151 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException( ExceptionFactory.java:167 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.protocol.a.NativeSocketConnection.connect( NativeSocketConnection.java:89 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.NativeSession.connect( NativeSession.java:144 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly( ConnectionImpl.java:953 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO( ConnectionImpl.java:823 ) ~[mysql-connector-java-8.0.23.jar:8.0.23] ... 49 common frames omitted Caused by: java.net .ConnectException: Connection refused: connect 오류는 너무 길어서 일단 일부만 가져왔어요





