SQLI ERROR

Confluence User - 06 Dec, 2024

                String sql = "SELECT c_process_def_id, c_processid FROM app_fd_bill WHERE c_bill_number = ?";
                stmt = con.prepareStatement(sql);
                stmt.setString(1, billNo);
                rs = stmt.executeQuery();


I need to get values of c_process_def_id, c_processid because these are needed for 
assignmentReassign(processDefId, processId, activityId, username, user);
where
c_process_def_id = Accounts#70#bill_management
and  
processId= 2602_Accounts_bill_management.
stmt.setString(1, billNo); billNo=2

I'm doing this outside process, so I'm storing the values in the database instance, but when I execute these values i get error

ERROR 06 Dec 2024 12:12:31 org.joget.apps.app.service.SqlFilterAspect - Possible SQLi from IP:0:0:0:0:0:0:0:1. Query string is _action=submit&OWASP_CSRFTOKEN=D8YK-063H-WJGC-PRLX-Y2PJ-EAC7-DLK0-THNZ
4794
java.sql.SQLException: Possible SQLi from IP:0:0:0:0:0:0:0:1. Query string is _action=submit&OWASP_CSRFTOKEN=D8YK-063H-WJGC-PRLX-Y2PJ-EAC7-DLK0-THNZ

jdbc;sql;sqli;database

1


08 Dec, 2024
confluenceUser
confluenceUser

This is a duplicate of sqli error.

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print