fuweng11 opened a new issue, #6768:
URL: https://github.com/apache/inlong/issues/6768
### What happened
Unable to find dataNode information according to keyword.
```
2022-12-06 14:10:25.517 -DEBUG [http-nio-8083-exec-2]
o.a.i.m.s.u.LoginUserUtils :40 - user login: danielzli
2022-12-06 14:10:25.518 -DEBUG [http-nio-8083-exec-2]
o.a.i.l.j.BaseJdbcLogger :137 - ==> Preparing: select count(0) from (
select id, name, type, url, username, token, ext_params, description,
in_charges, status, is_deleted, creator, modifier, create_time, modify_time,
version from data_node WHERE is_deleted = 0 and type = ? name like CONCAT('%',
?, '%') or type like CONCAT('%', ?, '%') or url like CONCAT('%', ?, '%') )
order by modify_time desc ) tmp_count
2022-12-06 14:10:25.520 -ERROR [http-nio-8083-exec-2]
w.c.ControllerExceptionHandler:150 - failed to handle request on path:
/inlong/manager/api/node/list by user: danielzli
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: sql injection
violation, dbType mysql, , druid-version 1.2.5, syntax error: syntax error,
error in :'
name like CONCAT('%', ?, '%')
', expect ), actual null, pos 365, line 14, column 18, token IDENTIFIER name
: select count(0) from (
select
id, name, type, url, username, token, ext_params, description,
in_charges, status, is_deleted,
creator, modifier, create_time, modify_time, version
from data_node
WHERE is_deleted = 0
and type = ?
name like CONCAT('%', ?, '%')
or type like CONCAT('%', ?, '%')
or url like CONCAT('%', ?, '%')
)
order by modify_time desc
) tmp_count
### The error may exist in class path resource
[mappers/DataNodeEntityMapper.xml]
### The error may involve
org.apache.inlong.manager.dao.mapper.DataNodeEntityMapper.selectByCondition_COUNT
### The error occurred while executing a query
```
### What you expected to happen
Data node information can be found according to the keyword.
### How to reproduce
Enter the keyword when searching for the datanode.
### Environment
_No response_
### InLong version
master
### InLong Component
InLong Manager
### Are you willing to submit PR?
- [X] Yes, I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of
Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
