Solr——链接数据库出现SQL无法执行
问题描述:
连接数据库建立索引时出现如下错误:
解决方法:
关键在于
Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value '�й���ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
需要配置data-config.xml文件,在第6行url后添加“?serverTimezone=UTC”,如下所示:
1 <?xml version="1.0" encoding="UTF-8"?>
2
3
4
5 driver="com.mysql.jdbc.Driver"
6 url="jdbc:mysql://127.0.0.1:3306/solrtest?serverTimezone=UTC"
7 user="root"
8 password="123456" />
9
10
11 query="SELECT cc_bill.bill_id,cc_bill.`name`,cc_bill.address,cc_bill.city_name,cc_bill.create_time FROM cc_bill">
12
13
14
15
16
17
18
19