Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. token : USE, pos : 229

11:32:23 [http-nio-8081-exec-1] ERROR c.k.c.exception.BDExceptionHandler - 
### Error querying database.  Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. token : USE, pos : 229 : SELECT
        c.OBJECT_SID,
        c.CREATED,
        IFNULL( cot.SEX, '未知' ) AS SEX,
        IFNULL( c.STATUSTWO, 0 ) AS STATUSTWO,
        IFNULL( dic.value, '未知' ) AS STATUSTWO_NAME,
        c.CREATED_BY,
        IFNULL( use.name, '未知' ) AS CREATED_BY_NAME,
        
        FROM
        ccpm_crm_customer c
        LEFT JOIN crm_custome_ext cce ON cce.CUSTOMER_SID = c.OBJECT_SID
        LEFT JOIN sys_user use ON c.CREATED_BY=use.user_id
        
         WHERE  c.IS_ACTIVE = ?
         order by OBJECT_SID desc

可以通过token : USE快速定位到错误原因
错误原因:use是限定词,不能作为别名使用,换一个别名即可


版权声明:本文为yinzitun7947原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。