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.
Converting annotations:
Java - Source | Java - Target | |||
1 | @Column(name = “key”) | Reserved words | @Column(name = “`key`”) |
Converting SQL statements in native SQL syntax:
Java - Source | Java - Target | |||
1 | "SELECT TRUNC(SYSDATE) ..." | Native SQL | "SELECT DATE(NOW()) ..." |