Embedded SQL and JDBC API in Java Applications - Assessment and Migration

The JDBC API provides access to databases in Java applications. JDBC is a part of the Java platform and it is divided into 2 packages: java.sql and javax.sql.

The JDBC API includes the following main Java classes and interfaces:

• java.sql Package

Assessment helps estimate the effort and cost of a migration. For conversion of embedded SQL in a Java application, the assessment can involve the following:

• Identifying Java files containing database access code
• Identifying embedded SQL statements

SQLines offers the following built-in assessment features:

• The number of occurrences of import java.sql directives (for each JDBC java.sql class)
• The list of files containing import java.sql directives
• The number of lines of code in each Java file and in all files

Using conversion language and report templates you can extend assessment features of SQLines and develop any custom assessment reports.