ES6.6.1通过Mysql加载字典的问题

[onaple]

plugin-security.policy 配置 grant { permission java.lang.RuntimePermission "getClassLoader"; permission java.lang.RuntimePermission "setContextClassLoader"; permission java.io.FilePermission "<<ALL FILES>>", "read,write"; permission java.net.SocketPermission "*:*", "accept,connect,resolve"; };

jdbc jar ： mysql-connector-java-5.1.17.jar (注mysql MySQL 5.7)

本地基于插件跑test可以获取流文件： 测试的方法： org.ansj.dic.impl.Jdbc2Stream#toStream方法

但是es启动报错如下：

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

[shi-yuan]

请问，字典的url是如何配置的？

# 全局变量配置方式一
ansj:
  ......
  # 从数据库中加载
  dic_d3: jdbc://jdbc:mysql://xxxx:3306/ttt?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull|username|password|select name as name,nature,freq from dic where type=1
 ......