WebServices: Adding to upper in sql query data to avoid case sensitive db configs

Description

Hi community,

Sometimes databases (in my case ORACLE 12) have case sensitive restrictions, so it's not possible create queries by matching. I added a simple UPPER sentence in the SQL creation to avoid it.

Before:
sqlBuilder.append(" AND ").append(field.getColumn()).append(" LIKE ?");

After:
sqlBuilder.append(" AND UPPER(").append(field.getColumn()).append(") LIKE UPPER");

 

Environment

None

Status

Assignee

Saúl Piña

Reporter

Saúl Piña

Labels

Tested By

None

Components

Affects versions

Priority

Minor
Configure