[submarine] branch master updated: SUBMARINE-446. Submarine server does not reconnect automatically to MySQL

[li...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

liuxun pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/submarine.git


The following commit(s) were added to refs/heads/master by this push:
     new f1ca541  SUBMARINE-446. Submarine server does not reconnect automatically to MySQL
f1ca541 is described below

commit f1ca541b72d760e206cdb119024e5a1bfeaa2ea1
Author: cchung100m <cc...@cs.ccu.edu.tw>
AuthorDate: Tue Mar 24 20:43:16 2020 +0800

    SUBMARINE-446. Submarine server does not reconnect automatically to MySQL
    
    ### What is this PR for?
    Hi jojochuang
    
    This PR is going to solve the submarine server does not reconnect automatically to MySQL, I would appreciate that if you can help to review/manage it, thanks.
    
    ### What type of PR is it?
    [Bug Fix ]
    
    ### Todos
    * [ ] - Task
    
    ### What is the Jira issue?
    
    https://issues.apache.org/jira/browse/SUBMARINE-446
    
    ### How should this be tested?
    
    https://travis-ci.org/github/cchung100m/submarine/builds/666269006?utm_medium=notification&utm_source=github_status
    
    ### Questions:
    * Does the licenses files need update? No
    * Is there breaking changes for older versions? No
    * Does this needs documentation? No
    
    Author: cchung100m <cc...@cs.ccu.edu.tw>
    
    Closes #247 from cchung100m/SUBMARINE-446 and squashes the following commits:
    
    8ce1550 [cchung100m] Trigger notification
    e475397 [cchung100m] SUBMARINE-446. Submarine server does not reconnect automatically to MySQL
---
 submarine-server/server-core/src/main/resources/mybatis-config.xml | 2 ++
 1 file changed, 2 insertions(+)

diff --git a/submarine-server/server-core/src/main/resources/mybatis-config.xml b/submarine-server/server-core/src/main/resources/mybatis-config.xml
index 12870ff..d2958d3 100755
--- a/submarine-server/server-core/src/main/resources/mybatis-config.xml
+++ b/submarine-server/server-core/src/main/resources/mybatis-config.xml
@@ -47,6 +47,8 @@
         <property name="url" value="${jdbc.url}"/>
         <property name="username" value="${jdbc.username}"/>
         <property name="password" value="${jdbc.password}"/>
+        <property name="poolPingQuery" value="SELECT NOW()"/>
+        <property name="poolPingEnabled" value="true"/>
       </dataSource>
     </environment>
   </environments>


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@submarine.apache.org
For additional commands, e-mail: dev-help@submarine.apache.org