一夜之间失去连接(Spring Boot + MySQL)

我的Spring Boot" title="Spring Boot">Spring Boot应用程序总是在早上向我显示此whitelabel错误:无法打开JPA

EntityManager进行事务;嵌套异常是javax.persistence.PersistenceException:org.hibernate.TransactionException:JDBC开始事务失败:

我在网上搜索,我认为可能是mysql关闭了8个小时的非活动连接。但是,根据该文档,spring boot将自动配置pooling

apache数据源。http://docs.spring.io/spring-boot/docs/current/reference/html/boot-

features-sql.html

我不确定如何配置应用程序代码或数据库。

这是我正在使用的build.gradle:

buildscript {

ext {

springBootVersion = '1.2.3.RELEASE'

}

repositories {

maven { url "http://repo.spring.io/libs-snapshot" }

mavenLocal()

}

dependencies {

classpath("org.springframework.boot:spring-boot-gradle-plugin:1.2.3.RELEASE")

}

}

apply plugin: 'java'

apply plugin: 'eclipse'

apply plugin: 'idea'

apply plugin: 'spring-boot'

apply plugin: 'war'

apply plugin: 'application'

repositories {

mavenCentral()

maven { url "http://repo.spring.io/libs-snapshot" }

maven { url "http://maven.springframework.org/milestone" }

}

// Seems tomcat 8 doesn't work with paypal

configurations.all {

resolutionStrategy {

eachDependency {

if (it.requested.group == 'org.apache.tomcat.embed') {

it.useVersion '7.0.59'

}

}

}

}

dependencies {

compile("org.springframework.boot:spring-boot-starter-web:${springBootVersion}")

compile("org.springframework.boot:spring-boot-starter-tomcat:${springBootVersion}")

compile("org.springframework.boot:spring-boot-starter-actuator")

compile("org.springframework.boot:spring-boot-starter-mail:${springBootVersion}")

compile("org.springframework.boot:spring-boot-starter-aop:${springBootVersion}")

compile("org.springframework.boot:spring-boot-starter-test:${springBootVersion}")

compile("org.springframework.boot:spring-boot-starter-security:${springBootVersion}")

compile("org.springframework.boot:spring-boot-starter-data-jpa:${springBootVersion}")

compile("org.springframework.data:spring-data-rest-webmvc")

compile("javax.servlet:jstl:1.2")

compile("org.apache.logging.log4j:log4j-api:2.3")

compile("org.apache.logging.log4j:log4j-core:2.3")

compile("com.paypal.sdk:rest-api-sdk:1.2.1")

compile("com.opencsv:opencsv:3.4")

compile("mysql:mysql-connector-java:5.1.35")

compile("com.google.guava:guava:17.0")

compile("org.apache.httpcomponents:httpclient:4.3.4")

compile("com.squareup.retrofit:retrofit:1.6.0")

compile("commons-io:commons-io:2.4")

compile("org.apache.commons:commons-lang3:3.4")

compile("com.amazonaws:aws-java-sdk:1.9.34")

providedCompile("org.apache.tomcat.embed:tomcat-embed-jasper:8.0.22")

testCompile("junit:junit")

}

sourceCompatibility = 1.7

targetCompatibility = 1.7

war {

baseName = 'gs-convert-jar-to-war'

version = '0.1.0'

}

task wrapper(type: Wrapper) {

gradleVersion = '2.3'

}

这是application.properties中的数据库配置:

spring.datasource.url=jdbc:mysql://fakeurl:3306/qa

spring.datasource.username=username

spring.datasource.password=password

spring.datasource.driverClassName=com.mysql.jdbc.Driver

spring.jpa.database-platform=org.hibernate.dialect.MySQLDialect

#

# hibernate

#

spring.jpa.hibernate.ddl-auto=update

对于数据源,我使用spring数据的存储库:

@Repository

public interface EventRepository extends CrudRepository<EventDetail, Long> {

}

这是针对运行“显示变量,如’%timeout%’的mysql数据库的结果:

'connect_timeout','10'

'delayed_insert_timeout','300'

'innodb_flush_log_at_timeout','1'

'innodb_lock_wait_timeout','50'

'innodb_rollback_on_timeout','OFF'

'interactive_timeout','28800'

'lock_wait_timeout','31536000'

'net_read_timeout','30'

'net_write_timeout','60'

'rpl_stop_slave_timeout','31536000'

'slave_net_timeout','3600'

'wait_timeout','28800'

回答:

检查这个答案:Spring Boot JPA-配置自动重新连接

简而言之,您需要:

spring.datasource.testOnBorrow=true

spring.datasource.validationQuery=SELECT 1

以上是 一夜之间失去连接(Spring Boot + MySQL) 的全部内容, 来源链接: utcz.com/qa/416506.html

回到顶部