警告解决 : java.sql.SQLWarning: '@@tx_isolation' is deprecated and will be removed in a future release.

错误信息 :

2019-07-10 09:14:50.529  INFO 21288 --- [r$PoolThread-#1] com.mchange.v2.c3p0.SQLWarnings          : '@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead

java.sql.SQLWarning: '@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead
	at org.mariadb.jdbc.MariaDbConnection.getWarnings(MariaDbConnection.java:548) ~[classes/:na]
	at com.mchange.v2.c3p0.impl.NewProxyConnection.getWarnings(NewProxyConnection.java:907) ~[c3p0-0.9.1.2.jar:0.9.1.2]
	at com.mchange.v2.c3p0.SQLWarnings.logAndClearWarnings(SQLWarnings.java:42) ~[c3p0-0.9.1.2.jar:0.9.1.2]
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:187) [c3p0-0.9.1.2.jar:0.9.1.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) [c3p0-0.9.1.2.jar:0.9.1.2]
	at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32) [c3p0-0.9.1.2.jar:0.9.1.2]
	at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810) [c3p0-0.9.1.2.jar:0.9.1.2]
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547) [c3p0-0.9.1.2.jar:0.9.1.2]

发生场景 :

项目集成 c3p0 & mysql 时遇到 ;

@@tx_isolation is deprecated and will be removed in a future release.Please use ‘@@transaction_isolation’ instesd
翻译 :
@@tx_isolation被禁止使用并且在未来的版本中会被移除，请使用’@@transaction_isolation’代替

错误位置 :

   <dependency>
     <groupId>io.zipkin.java</groupId>
       <artifactId>zipkin-autoconfigure-storage-mysql</artifactId>
       <version>2.9.4</version>
   </dependency>

org.mariadb.jdbc.MariaDbConnection

错误原因 :

此错误信息 , 为 c3p0 ,zipkin, 和 mysql 版本 差异 问题导致 ,
在mysql 5.7版本有更新SQL语句 , SQLAlchemy ;
此 错误信息 是个警告 , 而不是错误 ; 不解决的话 , 貌似也没发现什么问题 ;

解决办法 :

根据 错误信息 找到 MariaDbConnection.class 的源码 位置
根据错误信息 , 修改 源码 中 @@tx_isolation 为 @@transaction_isolation 即可解决