Dynamic SQL Statements - Java Applications Migration

Java applications can contain dynamic SQL statements in the native syntax of the source database (e.g., Oracle), which you need to convert to the native syntax of the target database (e.g., MySQL) during migration.

Source - Oracle:

  // Native SQL in string
  StringBuilder sql = new StringBuilder("SELECT TRUNC(SYSDATE) FROM t");
  Query query = entityManager.createNativeQuery(sql.toString());
  query.getResultList();

Target - MySQL:

  // Converted native SQL in string
  StringBuilder sql = new StringBuilder("SELECT DATE(NOW()) FROM t");
  Query query = entityManager.createNativeQuery(sql.toString());
  query.getResultList();

To see how native SQL constructs are migrated, refer to the corresponding database migration pairs in the site’s right sidebar.

For more information, see SQL Conversion in Java Applications.