Cloud Pak for Business Automation

Cloud Pak for Business Automation

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
Back to discussions
Expand all | Collapse all

IBM CP4BA/BPM - Service Flow - Database Queries with SQLParameters does not work with latin characters - Issue [Solved]

  • 1.  IBM CP4BA/BPM - Service Flow - Database Queries with SQLParameters does not work with latin characters - Issue [Solved]

    Posted 2 days ago
    Edited by Mohammed Shaker 2 days ago

    While using SQL Parameters with non-latin values we receive the below in our Table Record that value is inserted with ???????? and face limitation due to the below

    But this can easily be fixed instead of writing basic query
    eg: UPDATE TABLENAME SET COL1 = 'عربي'

    We need to override database connection attribute of

    jdbc:sqlserver://XX.XX.X.XX:XXXX;databaseName=XXX;user=XXX;password=XXX;trustServerCertificate=true;sendStringParametersAsUnicode=true

    Note:
    While applying this on java the attribute is defaulted with true value

    So we need override current jdbc connection attribute from Redhat Open shift CR Yaml File as per below

    And after waiting for pods reconciliation ~ 30 Min To 1 Hr

    We can use SQLParameters from our IBM CP4BA/BPM Services with non-latin characters.



    ------------------------------
    Mohammed Shaker
    IBM BPM Consaultant
    Valleysoft
    Nasr City
    01007073310
    ------------------------------



Related Content