SQL Conversion in Java Applications

SQLines SQL Converter can help you convert native dynamic SQL statements in native SQL synatx, reserved words used in JPA annotations and other language elements in Java applications.

To run the conversion in command line:

  # Convert multiple files
  ./sqlines -s=oracle -t=mysql -sl=java -tl=java -a -in=Project/src/main/java/*.* -out=Converted/

See the command line options.

Migration Reference

Annotations

Converting annotations:

Java - Source Java - Target
1 @Column(name = “key”) Reserved words @Column(name = “`key`”)

Dynamic SQL Statements

Converting SQL statements in native SQL syntax:

Java - Source Java - Target
1 "SELECT TRUNC(SYSDATE) ..." Native SQL "SELECT DATE(NOW()) ..."