How to deal with the error of JDBC connection MySQL that cannot use load data?

Alibaba cloud Q & A 2022-02-13 06:46:14 阅读数:19

deal error jdbc connection mysql

jdbc Connect mysql Can't use load data

Report errors The used command is not allowed with this MySQL version,local_infile yes true

Direct use mysql The remote invocation , No problem .




Take the answer 1:

Hello! ,jdbc url You need to add a parameter ,allowLoadLocalInfile=true, normal navicat Can run ,jdbc Need to add .


copyright:author[Alibaba cloud Q & A],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/02/202202130646127487.html