mybatis 里使用load data infile

我在mybatis里使用 load data infile 。执行的时候报错了。

<select  id="loadTest">       
load data infile '/data/dawncms/qinghai/QHdx_userlogs/qhdx_userlogs_2019_08_08_08.txt' replace into table edu_userlog_jsdx character set utf8 fields terminated by ',' enclosed by '"' lines terminated by '\r\n' (businessid,content,contentExtends,type,startTime,endTime,platform,hasHD,isFirst)     
</select >

报错信息

### Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, illegal charset : load data infile '/data/dawncms/qinghai/QHdx_userlogs/qhdx_userlogs_2019_08_08_08.txt' replace into table edu_userlog_jsdx character set utf8 fields terminated by ',' enclosed by '"' lines terminated by '\r\n' (`businessid`,`content`,`contentExtends`,`type`,`startTime`,`endTime`,`platform`,`hasHD`,`isFirst`)
### The error may exist in file [E:\eclipsespace\DawnCMS\target\classes\mybatis\cms\DataImportMapper.xml]
### The error may involve com.bootdo.cms.dao.DataImportDao.loadTest
### The error occurred while executing a query
### SQL: load data infile '/data/dawncms/qinghai/QHdx_userlogs/qhdx_userlogs_2019_08_08_08.txt' replace into table edu_userlog_jsdx character set utf8 fields terminated by ',' enclosed by '"' lines terminated by '\r\n' (`businessid`,`content`,`contentExtends`,`type`,`startTime`,`endTime`,`platform`,`hasHD`,`isFirst`)
### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, illegal charset : load data infile '/data/dawncms/qinghai/QHdx_userlogs/qhdx_userlogs_2019_08_08_08.txt' replace into table edu_userlog_jsdx character set utf8 fields terminated by ',' enclosed by '"' lines terminated by '\r\n' (`businessid`,`content`,`contentExtends`,`type`,`startTime`,`endTime`,`platform`,`hasHD`,`isFirst`)
; uncategorized SQLException; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, illegal charset : load data infile '/data/dawncms/qinghai/QHdx_userlogs/qhdx_userlogs_2019_08_08_08.txt' replace into table edu_userlog_jsdx character set utf8 fields terminated by ',' enclosed by '"' lines terminated by '\r\n' (`businessid`,`content`,`contentExtends`,`type`,`startTime`,`endTime`,`platform`,`hasHD`,`isFirst`); nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, illegal charset : load data infile '/data/dawncms/qinghai/QHdx_userlogs/qhdx_userlogs_2019_08_08_08.txt' replace into table edu_userlog_jsdx character set utf8 fields terminated by ',' enclosed by '"' lines terminated by '\r\n' (`businessid`,`content`,`contentExtends`,`type`,`startTime`,`endTime`,`platform`,`hasHD`,`isFirst`)
org.springframework.jdbc.UncategorizedSQLException: 
阅读 4.1k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题