spring boot项目，运行卡住

sinat_41595730 2019-06-11 10:44:13

框架：spring boot
数据库： oracle 11g

问题：项目运行卡住，不报错，约15分钟后提示数据库连接超时，如下图

问题具体描述： spring boot项目，本地idea运行没问题，打成jar包，放服务器上跑，跑了一个多月也没问题，前两天停了重跑，就运行不了了。

尝试解决过程： 1、判断网络问题，用服务器ping数据库能ping通，用另一使用相同数据库的jar程序在那台服务器跑，也没问题
2、判断程序问题，程序打包成jar包后，再在本机运行，没问题，在其他电脑运行也没问题，在其他服务器运行也没问题
3、服务器重启过，还是运行不了，重装过，还是不行
很疑惑的问题：该jar包开始在那台服务器上是能运行的，还运行了一个多月

配置文件：
spring:
datasource:
driver-class-name: oracle.jdbc.driver.OracleDriver
username:
password:
url: jdbc:oracle:
jpa:
database: oracle
hibernate:
ddl-auto: update
show-sql: true
main:
allow-bean-definition-overriding: true
server:
port: 8080
logging:
file: spring.log
pattern:
level: debug

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.2.RELEASE</version>
<relativePath/> 
</parent>
<groupId></groupId>
<artifactId>datashow</artifactId>
<version>0.1.7</version>
<packaging>war</packaging>
<name>datashow</name>
<description>Demo project for Spring Boot</description>

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

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

<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-quartz</artifactId>
</dependency>

<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
<version>2.1.0.RELEASE</version>
<exclusions>
<exclusion>
<artifactId>spring-boot-starter-jdbc</artifactId>
<groupId>org.springframework.boot</groupId>
</exclusion>
</exclusions>
</dependency>

<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
<version>1.5.17.RELEASE</version>
</dependency>

<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>10.2.0.5.0</version>
</dependency>

<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.1.1</version>
<exclusions>
<exclusion>
<artifactId>spring-boot-starter-jdbc</artifactId>
<groupId>org.springframework.boot</groupId>
</exclusion>
</exclusions>
</dependency>

<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>4.0.0</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>4.0.0</version>
</dependency>

</dependencies>

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

</project>

repository使用了Mapper注解，用mybatis的方式对数据库进行查询