ORA-01425: escape character must be character string of length 1

[gowrishankarjhcbb]

Query Generated by spring data jpa is invalid and having double slash for oracle.

This is my code snippet

Optional<EdpRecordData> findByMsgIdAndCreditorAgentStartsWithAndDebtorAgentStartsWith(
      String msgId,
      String creditorAgent,
      String debtorAgent);

SQL Query Generated

    select
        erd1_0.msg_id,
        erd1_0.debtor_agent,
        erd1_0.creditor_agent 
    from
        edp_records erd1_0 
    where
        erd1_0.edp_status=? 
        and erd1_0.creditor_auto_presentment_flag=1 
        and erd1_0.creditor_auto_presentment_date=? 
        and erd1_0.creditor_agent like ? escape '\\'
Hibernate: 
    select
        erd1_0.msg_id,
        erd1_0.debtor_agent,
        erd1_0.creditor_agent 
    from
        edp_records erd1_0 
    where
        erd1_0.edp_status=? 
        and erd1_0.creditor_auto_presentment_flag=1 
        and erd1_0.creditor_auto_presentment_date=? 
        and erd1_0.creditor_agent like ? escape '\\'

Exception thrown by Oracle.
java.sql.SQLDataException: ORA-01425: escape character must be character string of length 1

[christophstrobl]

Please do not post images of code but use proper code fences.
If you'd like us to spend some time investigating, please take the time to provide a complete minimal sample (something that we can unzip or git clone, build, and deploy) that reproduces the problem.

[gowrishankarjhcbb]

Please do not post images of code but use proper code fences. If you'd like us to spend some time investigating, please take the time to provide a complete minimal sample (something that we can unzip or git clone, build, and deploy) that reproduces the problem.

updated with code snippet

[mp911de]

Spring Data isn't generating any SQL from queries, Hibernate is doing so. I suggest reporting the issue in the Hibernate issue tracker as we're using CriteriaBuilder.like(Predicate like(Expression<String> x, Expression<String> pattern, char escapeChar) to create the LIKE expression.