I am Migrating ADF web application from oracle DB to MySql DB. ( Using glassfish 3.1.2.19 and JDeveloper 12.1.3 and mysql-connector-java-5.1.29 and mysql Ver 14.14 Distrib 5.7.31). I am facing issues in view criteria LOV search operation with contains operator. For soma case changing Database to in memory in View criteria working fine .. But for some cases it is not working. There is no resemblance in working and not working cases too. Kindly help us on this.