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

Dynamic SQL Statements

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()) ..."

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to MySQL

Migration to PostgreSQL

Migration to SQL Server

Migration to Oracle

SQL in Applications

SQL Conversion in Java Applications

Migration Reference

Annotations

Dynamic SQL Statements