ADF BC ViewCriteria Include '||' Instead Of 'CONCAT' When Using MySQL Database. (Doc ID 1162508.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version: 11.1.1.3.0 and later   [Release: No Release Description and later ]
Information in this document applies to any platform.

Goal

You are using ADF Business Components (BC) 11g with MySQL database.
You set up your ADF BC project with the following properties when you created it
SQL Flavor: SQL92
Type Map: Java


However, you see that the SQL queries use the '||' for concatenation instead of the 'CONCAT' function.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms